top of page

Add an annotation automatically when "New or Updated Spreadsheet Row in Google Sheets"

It only takes 5 minutes to automate this annotation, and NO coding skills are required.
Annotation from Google Sheets

Here is how to do it:
 
 













1. Login to your Crystal Ball account here
 
2. Create a new Google Sheet and add columns similar to these













3. Create your Zapier account here, you can start FREE
 
4. Create a new Zap, click on "MAKE A ZAP" button

Google Sheets for annotations
ZAPIER Google Sheets

5. Type "Google Sheets" to find the app trigger and select it

Zapier Trigger for Google Sheets

6. For Trigger Event, select "New or Updated Spreadsheet Row in Google Sheets"

Trigger Google Sheets for Annotations

7. Connect your Google Sheets (Google Drive) account and test that everything works

Connect Drive Account for annotations

8. Select the Spreadsheet and the Worksheet you created before. Then to test the trigger (looks it's some kind of issue with this test, see the video, you can skip and continue)

select Spreadsheet for annotations

9. Continue and select the action app, search for "Webhooks by Zapier" and select it.

Weebhooks for GAannotations

10. Select "POST" option

POST selection

11. Add the POST URL
IMPORTANT: Pay attention there is NO extra space after the URL when you paste it

GAannotations API

The POST URL you can copy it from the documentation page

GAannotations documantation

12. Choose "Form" in the "Payload type" section

GA automated annotations settings

13. On the data section, you need to copy/paste the mandatory fields and choose the incoming data from Google Sheet, this will be the data for the annotation

Google Sheet data for annotations

14. Scroll down to the "header", then:
 

  1. - Copy/paste the word "Authorization" on the header section
     

  2. - Copy/paste the word "Bearer" on the undefended section
     

  3. - Go to the API KEYS page and generate a key, copy/paste it after the word "Bearer".

    IMPORTANT :There must be a <space> between the word Bearer and Access Token.
     

  4. - Click Continue & Test

15. Test your ZAP

Test Zap

16. It's READY!
Add a new row to the Google Sheet, wait for 3-4 minutes and go back to the annotations page and check if the annotations it's there, it will be also displayed on the Google Analytics account.

You can always edit or delete annotations from your dashboard ; )

Google Sheets Annotations on GAannotations
Annotations from Google Sheets

Check out all the Integrations!

bottom of page