You can use the Perdoo Google Sheets Add-on or Perdoo Google sheets integration to easily update your goals with your Google Analytics data.

If you haven't already, install our Google Sheets Add-on or enable our Google sheets integration.

1. In the Google Workspace Marketplace, search for Google Analytics, then select Install:

2. Confirm that you're happy to give Google Sheets access to your Google Analytics account by clicking Continue:

3. Once you've received confirmation that the add-on is successfully installed, click Done:

4. Then load the Google Analytics add-on on your Google Sheet via Extensions > Google Analytics > Create new report:

5. Next, give your report a name, and choose your configuration options, such as picking which metrics to pull (for example "new users"):

6. You can then continue to configure your report from inside the Sheet, by editing the cells to ie. change start/end dates. More details on how to create reports can be found here.

7. Once you've prepared your report, you can run it via Extensions > Google Analytics > Run reports:
​

8. The Add-on then creates a new sheet for each report:

9. Follow the step linked for our Google Sheets Add-on or the following step linked for our Google sheets integration to update your goals in Perdoo.

Contact our friendly Support team via the live chat at the bottom-right of your screen, or email support@perdoo.com.