See other articles
Integrations

Google Sheet format

1. Make sure the first row is a header row with column names

We recommend all your columns have text in the header row, but you must have text in the first column header, especially if you are using the Create Spreadsheet Row action. Without any text there, the job will send your data to the top of the sheet rather than to the bottom.
Make sure you have a data and it's on a right date format.

2. Don’t include headers for separate sections but do remove blank rows

Your spreadsheet should have no blank rows in between rows with content.

And it should not have any headers for separate sections in the same column.

3. Don’t delete rows

Do not delete rows in your spreadsheet while your sheet is in use, and don't add rows in the middle of data your job has already recognized. This can cause errors with your job. If you need to delete any rows, ensure the job is turned off as you make your amendments. Once you've finished deleting your rows, you can then turn your job back on.

4. Don’t include punctuation in your Sheet name

If you include punctuation of any sort, it can make it harder for Jepto to find the right sheet in Google Sheets. This is especially true for colons, which will break your job.

Was this article helpful?
Nice one!

Thanks a lot for your feedback!
If you’d like a member of our support team to respond to you,

please send a message here
Please try again

Oops! Something went wrong while submitting the form.

Sorry about that. What did you find most unhelpful?

Nice one!

Thanks a lot for your feedback!
If you’d like a member of our support team to respond to you,

please send a message here
Please try again

Oops! Something went wrong while submitting the form.

See all categories

Integrations

1. Make sure the first row is a header row with column names

We recommend all your columns have text in the header row, but you must have text in the first column header, especially if you are using the Create Spreadsheet Row action. Without any text there, the job will send your data to the top of the sheet rather than to the bottom.
Make sure you have a data and it's on a right date format.

2. Don’t include headers for separate sections but do remove blank rows

Your spreadsheet should have no blank rows in between rows with content.

And it should not have any headers for separate sections in the same column.

3. Don’t delete rows

Do not delete rows in your spreadsheet while your sheet is in use, and don't add rows in the middle of data your job has already recognized. This can cause errors with your job. If you need to delete any rows, ensure the job is turned off as you make your amendments. Once you've finished deleting your rows, you can then turn your job back on.

4. Don’t include punctuation in your Sheet name

If you include punctuation of any sort, it can make it harder for Jepto to find the right sheet in Google Sheets. This is especially true for colons, which will break your job.