You can use data from your Google Sheets as a source for your automated reports and dashboards in Datarails. 

Set-up

Follow these steps to bring data from your Google Sheets into Datarails:

Note: You can paste the link to your Google Sheet here or simply select it from the drop-down menu that appears when you select "File Name" and click in the box. 

You will see the data from your Google Sheet appear on the version tab. From here, you can map it to your database like any other data source.

Sync incremental data only

Datarails can be configured to synchronize data from Google Sheet only when changes are detected in the source file. This reduces the size of your database and optimizes performance. You can turn this feature on by making the following selection under Filebox Settings:

If you have any questions that weren’t addressed by this article, please reach out to the Support Team via support@datarails.com. We are happy to help.

Updated May 08, 2023 15:50