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.