Overview

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.

• Requirements
• Authorizing with personal Gmail accounts

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

Requirements

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 blendr.io (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
    NOTE: 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.