We are super excited to introduce you to our new integration with Google Sheets!
Here are some useful tips to get you started:
Google will display 100 most recent sheets connected to your account;
A single spreadsheet should only have a single sheet per file. If there are more sheets in the same file, please create a new spreadsheet in a separate file and try to link it to Whatagraph;
The document must have a date column – this is how the platform is able to recognise the date range;
The reports will refresh every hour – so if you update something in your Google Sheets, it will update on our side within one hour (not instantly), you can however try to refresh a specific widget to speed it up;
If you need to report on different number types (i.e. percentage or currency), you will have to build your own custom metrics.
1. Add Google Sheets as a new source to Whatagraph;
2. When you select Google Sheets as a source for your report, do not forget to set the same date range as the one you have in your Google Sheets document;
Download a sample Google Sheet template here.