Using Google Sheets Trigger

Using SureTriggers, you can take actions in other applications when new data is added to a Google Sheet.

For example, you can create a workflow to automatically create subscribers in your email marketing tool when a new row is added to your Google Sheets.

To set up the Google Sheets Trigger, we will use a Google Sheets add-on called SureTriggers Webhooks.

In this article, we’ll learn how you can use the SureTriggers Webhook addon to trigger your workflows when new data is added to Google Sheets.

Let’s start!

What Is SureTriggers Webhook Addon?

Google Sheets Trigger is an extension for Google Sheets that helps you connect your SureTriggers account with Google Sheets using webhooks.

It can help you create workflows to create workflows that trigger when new rows are added to a specific spreadsheet.

What Can You Do With SureTriggers Webhook Add-On?

The SureTriggers Sheets add-on not only helps you connect your SureTriggers account with your spreadsheet, but it also facilitates the execution of advanced actions.

There are four different functions that you can do using the SureTriggers Webhook addon. These functions are:

Enable Sending Data

This option allows you to execute workflows when any column is updated in your spreadsheet.

For example, imagine you have a spreadsheet tracking contact information, and you want to automatically send an email to the sales team whenever the “Status” column is updated to “subscriber,” “new lead,” “customer,” “opportunity,” etc.

If you update the “Status” of a specific row to “Customer,” the add-on can trigger and send the complete row’s data, including customer details, which you can send to other applications using SureTriggers.

Send Data Every One Hour

This option helps you execute workflows when any row is added to your spreadsheet.

For example, if you are using a spreadsheet to log daily tasks and want to send a summary of the day’s tasks to a project management tool every hour.

If you add a new task to your spreadsheet, the add-on will wait for the next hourly interval and then send the newly added rows’ data to SureTriggers.

Send Data Range Manually

If you have a large dataset in your spreadsheet and only want to send specific rows within a selected range to an external database.

You can select a range of rows (e.g., rows 10 to 20) in your spreadsheet and manually trigger the add-on. It will then send the data of the selected rows in the form of an array to SureTriggers and pass it on to any other application.

Send All Data From This Sheet

With this option, you can send all the data from a spreadsheet to SureTriggers, and forward it to any application you desire.

One row of data is presented in an array, so you can take action from all row data one by one.

These examples show how the Google Sheets add-on enhances automation and connectivity, making it easier to integrate your spreadsheet data with various applications in the simplest ways.

Now let’s see how you can use this addon.

How to Set Up Google Sheets Triggers

We’ll understand this by creating a simple workflow to add new Mailchimp subscribers when new rows are added in Google Sheets.

We’ll assume that our spreadsheet has three columns: first name, last name, and email. We’ll create the subscriber with the same details in Mailchimp.

Here’s a video that explains the complete setup.

By following the instructions in this video, you will be able to understand how you can trigger your workflows when new rows are created in your Google Sheets, and if you run into any blockers, please feel free to reach out to us at support@suretriggers.com!