Integrations: Google Sheets

Contents

Overview

The Google Sheets integration can be used to automatically track activity or progress made within Google Sheets. Similar to our Microsoft Excel 365 integration, the Google integration allows users to access their existing Google Sheets and select a cell that will impact the progress of a Betterworks milestone. 

Integration Benefits

  • Time-saving automation
  • Easy data import for streamlined performance tracking
  • Increased accuracy by reducing the risk of errors in manual data entry
  • Improved collaboration between team members through shared Google worksheets

Setup — Administrators

Note: You must be a Super Admin to set up the integration.

1. Go to the Admin → Platform Configuration → Integrations → Third-party Integrations → Google Sheets → Setup.

2. Enable the option. 

Connecting Milestones — Users

Once the integration has been set up, any user in the organization can access the integration.

1. Go to Goals → My Goals → Create Goal.

2. Add a milestone.

3. Select the Google Sheets icon.

4. Click "Sign in with Google" and enter your credentials.

5. Select the worksheet, followed by the cell.

Note: It is possible to connect multiple milestones to the same worksheet.

Data Sync

  • Automatic Sync: The Betterworks integration captures data from and automatically updates the progress of your milestones at the top of every hour (2 PM, 3 PM, etc.). Therefore, if you make a change in the worksheet at 2:15 PM, our application will check at 3 PM and make the update to progress in Betterworks at that time.
  • Manual Sync: You can manually sync the progress on your milestones by going to Goals → My Goals, selecting the relevant goal, clicking on its corresponding milestone, and opening the right-side panel. From there, click the three horizontal dots and select "Sync" from the drop-down menu to update the progress. This will take a few minutes.

Troubleshooting

There are a few situations that can result in an error:

  • Selected value is not a number: The cell that's selected in the Google Sheets integration has an alphabetical character which is not supported. The integration's progress calculations only take numbers as input. Please check your sheet and make the necessary changes.
  • Selected value no longer available: The cell selected for the milestone no longer has any value in it. This could be due to a column being deleted in the worksheet, and the cell that was selected has shifted left. Check your sheet to ensure that the intended value is selected.
  • Worksheet was not found: The worksheet may have been deleted. Confirm that the worksheet still exists in Google Sheets.
  • Worksheet access denied: Betterworks can no longer access the worksheet that was selected using the user's Google account, possibly due to editor/viewer access being changed. Please confirm the access using the corresponding account in Google Sheets.

FAQs

How long does it take for progress made in my Google worksheet to be reflected in Betterworks?

Our application checks for updates from Google Sheets at the top of every hour (2 PM, 3 PM, etc.). Therefore, if you make a change in the workbook at 2:15 PM, our application will check at 3 PM and make the update to progress in Betterworks at that time.