New Google Sheets trigger

New Google Sheets trigger
Google Sheets
·
8/10/2022
·
5 min. read
eye

We have added a new Google Sheets trigger - Watch for cell change and send the row.

This trigger lets you keep track of all updates in the cells of your sheet. Trigger works on webhooks and sends events immediately when a cell is updated and a row is added.

You’ll need to make additional setup in your spreadsheet to use this trigger, but first, connect your Google Sheets account to Albato.

Connecting Google Sheets to Albato

How to set up spreadsheet

  • Open your spreadsheet which you want to use in the integration.
  • Go to the Extensions section → Apps Scripts.
  • Remove the data from the Editor section and paste a code from this link
  • Copy the Albato webhook URL from your Google Sheets connection in the Apps section.

2022-08-10_18-33-24.png

  • Paste this webhook into the endpoint variable (line 14).

2022-08-10_18-35-24.png

  • Click the Save icon. Pick the “createSpreadsheetOpenTrigger” option and click the Run button.

2022-08-10_18-37-08.png

  • Click the Review permissions button.

2022-08-10_18-40-11.png

  • Select your account.

2022-08-10_18-41-11.png

  • If you receive a warning, open the "Advanced" tab.

2022-08-10_18-42-26.png

  • Next, click the “Go to Untitled Project” button.

2022-08-10_18-43-23.png

  • Give access to your app by clicking the “Allow” button.

2022-08-10_18-45-22.png

  • Now go to the "Triggers" section and make sure you have one trigger saved. If you made mistakes during the setup process, several triggers may be saved. These triggers should be deleted.

2022-08-10_18-48-37.png

The spreadsheet is ready!

You can create your automation scenario with the “Watch for cell change and send the row” trigger.


Google Sheets