See other articles
Integrations

Google Sheets format

Utilising Google Sheets as a data source gives you a lot of flexibility to connect a variety of systems that aren't already covered. For this to work there are a few rules that you need to follow for our system to be able to extract your data correctly. Please follow the guide below or reach out to the support team if you are having difficulty getting your data organised correctly in a Sheet.

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. Avoid time on Date Column

Intra day data is currently not factored into the prediction process, so where possible please aggregate values to a single day value.

5. Avoid Duplicating dates

The first occurrence will be honoured and succeeding duplicate values will be ignored.

6. Don't include dashes within the Metric Column

Some systems utilise a dash to represent missing or no value, avoid this as we only accept numeric, currency and negative values.

7. Avoid different currencies within the same column

Avoid using different currencies on a single row.

8. Current time will be based on your spreadsheet timezone

9. Rows that has a future dates will be ignored

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

Utilising Google Sheets as a data source gives you a lot of flexibility to connect a variety of systems that aren't already covered. For this to work there are a few rules that you need to follow for our system to be able to extract your data correctly. Please follow the guide below or reach out to the support team if you are having difficulty getting your data organised correctly in a Sheet.

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. Avoid time on Date Column

Intra day data is currently not factored into the prediction process, so where possible please aggregate values to a single day value.

5. Avoid Duplicating dates

The first occurrence will be honoured and succeeding duplicate values will be ignored.

6. Don't include dashes within the Metric Column

Some systems utilise a dash to represent missing or no value, avoid this as we only accept numeric, currency and negative values.

7. Avoid different currencies within the same column

Avoid using different currencies on a single row.

8. Current time will be based on your spreadsheet timezone

9. Rows that has a future dates will be ignored