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.

Did this answer your question?