Link Goal With Google Sheets

When a goal is linked with the Google Sheets report, any update made in the Google Sheets report will be reflected in the goal progress. By linking the goal with the Google Sheets report, you do not need to update the goal progress manually.

To link a goal with Google Sheets:

Step 1: Navigate to Home > Goals > My Goals

Step 2: Click Add Goal to create a goal.

Step 3: After providing all the goal details, go to the “Integration” section and click Google Sheets Icon.

Note: You can link Google Sheets reports only for the goals with measurement type given as quantity.

Step 4: Sign in to your Google account. You can also manage the integration connection from the user profile.

Step 5: Select the worksheet from the list to link with the goal.

Step 6: Select the spreadsheet from the list and enter the cell.

Step 7: Click Verify to verify the details added.

Step 8: Select the checkbox to set the current field value in the Google Sheets cell as the start value for the goal target.

Step 9: Click Link to link the Google Sheets with the goal.

Step 10: After the goal is linked with the Google Sheets report, click Publish to publish the goal.