1. Spoke Phone Support
  2. Integrations
  3. Reporting and Analytics

How to enable call reporting with Google Sheets using a Google Organization or Workspace account

Avatar
Gareth Willmore

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.

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

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

Personal Gmail accounts can be used, see the help article here.

 

Whitelisting the integration in Google

Before installing the integration, you will need to Whitelist our integration partners app (BlendR.io) inside your Google account.  Follow the steps below or click on the link at the bottom of the steps for more information.

  1. Navigate to https://admin.google.com and sign in with an admin account
    View the google help article if you're having trouble signing in.
  2. From the Admin console Home page, go to Menu  Security API controls.
  3. Under App access control, click MANAGE THIRD-PARTY APP ACCESS.
  4. Click Configure new app, and choose OAuth App Name or Client ID.
  5. Type the app's name in the search box "blendr.io", and then click SEARCH.
  6. From the list of search results, click Select on the blendr.io app.
    Note: If you are configuring by OAuth app name or client ID, check the boxes for the client IDs that you want to configure, and then click SELECT.
  7. Choose the following:
    Trusted: Can access all Google services
  8. Click CONFIGURE.
    On the apps page, the Access column will display the access status for the apps: Trusted or Blocked.
  9. You're done.  The integration can now be installed.

    For more information, view the Google help article.

 

Installing the integration

  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.
    2021-03-26_12_20_22-Spoke.png

  4. Select Connect your Google Drive
    2021-03-25_14_42_11-Setup_for_Call_reporting_in_Google_Sheets_-_Spoke_Phone.png

  5. NOTE: Make sure you have completed the whitelisting process with an admin account noted in the section above.

    Choose Yes and select Save

    2021-03-25_14_42_29-Setup_for_Call_reporting_in_Google_Sheets_-_Spoke_Phone.png
  6. Select Link datasource
    2021-03-25_14_42_42-Setup_for_Call_reporting_in_Google_Sheets_-_Spoke_Phone.png

  7. Select your organization Google account
    2021-03-25_14_43_22-Sign_in_-_Google_Accounts_-_spoke2.png

  8. Select Allow to give the app access to Google
    2021-03-26_11_19_34-Sign_in_-_Google_Accounts.png
  9. 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.
    2021-03-25_14_46_04-Setup_for_Call_reporting_in_Google_Sheets_-_Spoke_Phone.png
  10. 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.
    2021-03-25_14_46_19-Setup_for_Call_reporting_in_Google_Sheets_-_Spoke_Phone.png

  11. You should now see this screen, the setup is complete.
    2021-03-25_14_46_50-Slack.png

 

 

Articles in this section

Related articles

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