Integrating with Google Sheets

Are you tired of manually inputting data? Integrating with Google Sheets can help automate your workflow and streamline your data entry process. By using webhooks, you can automatically insert new notification data into your Google Sheets without any manual intervention.

In this lesson you'll learn how to:

• Use webhooks to insert a new row in Google Sheets automatically.

• Webhook alert example sent to Google Sheets

Step 1:

Install the Webhooks for Sheetsapp from Google Marketplace. You'll need to allow the required permissions.

Step 2:

Open a new Google Sheet. Then, click on the Webhook icon.

Step 3:

Follow the prerequisites.

Step 4:

Once finished, click, create.

Step 5:

You may be prompted to Authorize the Webhook.

In this case, you'll need to refresh the page. Then, navigate to the Webhooks tab and click Authorize. Once finished, click next. Then, try creating the new webhook URL again.

Step 6:

Copy the webhook URL.

Step 7:

In job settings, click on the Google Sheets icon and paste the URL in the input field.

Step 8:

Finally, click save.

Webhook columns:

• URL

• Description (job name)

• Datetime

• Preview (screenshot)

• Original (screenshot)

• Change (percent change)

• View_changes (link to diff modal)

• Text_changes (for Text jobs)

• Added_text (for Text jobs)

• Removed_text (for Text jobs)

• Labels_0

• Summarizer (AI Summary)

• Important (AI Analyzer flag - Contact us for more details)

Google Sheets has several storage limits in place, all of which apply to data inserted by this webhook, including:

• 10,000,000 cells per spreadsheet (across all sheets).

• 50,000 characters per cell on a spreadsheet.

As the alert webhook send 13 columns of data, any spreadsheet will have an effective limit of 769,229 rows of alerts per spreadsheet. (Note that, at one alert per hour, it would take 87 years to exhaust all ten million cells.)

Google Sheets may also truncate some very long columns at the cell-character limit as they are imported, particularly the "Text_changes", "Added_text", and "Removed_text" columns.