How to enable call reporting with Google Sheets using personal gmail accounts


Spoke Phone's Google Sheets integration automatically populates a Google sheet with your call data and generates a pre-built reporting dashboard.  You can easily change the date range to explore the dashboard across your selected timeframe.

This article will show you how to get started with the pre-built Google sheets integration.

Note: You will need a Google workspace account and a Google admin account to whitelist our integration partners app ( in order to successfully install this integration.



Personal Gmail accounts can be used to install this integration, see the authorization process below.

In order to use this integration within a Google Workspace account, you will need to authorize the integration with an admin account.  See this help article

Authorizing with personal Gmail accounts

If your google account is not a workspace, organization, or managed account, then you can still use this integration after allowing the app access to write the data into your Google account.

  1. Go to your Spoke Phone account portal online and login.
  2. Go to integrations > add integration.
  3. Select to add on the Google Sheets - Call reporting card.

  4. Select Connect your Google Drive
  5. Choose Yes and hit Save
  6. Select Link datasource

  7. Choose or login to your google account

  8. Select Advanced and then select Go to (unsafe)
    Don't worry, we have verified this is safe to do.

  9. Select Allow to confirm the installation

  10. Select Ok

  11. Repeat the process with Google Sheets until both are connected as below
    You MUST ensure you have connected both Google Drive and Google Sheets to the same account, otherwise this integration will not work.

  12. Then click Next
  13. Select the timezone you wish your reports to be localized to and then click next
    : Data will begin streaming converted to this timezone, so make sure you get this right.
    You can always remove the integration and add it again if you wish to change this.

  14. You should now see this screen, the setup is complete.

Was this article helpful?
1 out of 1 found this helpful