Key gotchas -

  1. We currently support connecting one Google account per organisation. This means we will be able to connect any Google sheet created by the connected Google account.
  2. Connecting Google sheets is a one-time process. Please confirm with your account admin if you need to do it. If there are other apps running with Google sheet on Tuneal, this step will already be taken care of. You can directly jump to step 3 of the process described below.

Steps to connect Google sheets and get data from Google sheet

Step 1: Write the sentence -

Get users data from users google sheet

Please replace the words users with whatever you are fetching from google sheet. Once you are done writing the sentence, hit save.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/ae7b5451-f2ae-4a53-ac67-63734454545c/Screenshot_2020-10-06_at_5.00.04_PM.png

Step 2: Click on the sentence and then click on the "Connect Google" button.

If you don't see the "Connect Google" button, it means that this step is already taken care of in your organisation. When you click on the connect google button, you will be taken to Google Auth page. Please authorise Tuneal to access your Google spreadsheets.

https://s3-us-west-2.amazonaws.com/secure.notion-static.com/5908f61e-cc55-4822-9869-e348e2b4a2d2/Screenshot_2020-10-06_at_5.00.13_PM.png