How to Instantly Trigger Make.com from Google Sheets

This article demonstrates how to set up instant triggers in Make.com (formerly Integromat) to respond immediately to changes in Google Sheets.

The process involves using the Watch Changes and Perform a Function modules in Make.com, along with the Make for Google Sheets add-on. This setup allows for real-time data processing and immediate responses to sheet updates.

I go through the entire process in the video below:

Setting Up the Watch Changes Trigger

To begin, we need to configure the Watch Changes module in Make.com:

1. Add a new module in Make.com and select Google Sheets.
2. Choose the Watch Changes option for instant triggers.
3. Copy the provided webhook URL.

Next, we need to set up the Google Sheets add-on:

1. Open Google Sheets and go to Extensions > Add-ons > Get Add-ons.
2. Search for “Make for Google Sheets” and install it.
3. Navigate to Extensions > Make for Google Sheets > Settings.
4. Paste the webhook URL into the designated field.
5. Select the sheet name and specify the range you want to monitor.
6. Save the settings: If pop-up doesn’t appear then it didn’t work. If so, try another browser or sign out of all your other Google acounts so that the google account you want to use is the primary one that you’re logged in to.

Check the video above to watch me throughout this process as it’s quite finicky.

Configuring the Automation Workflow

After setting up the trigger, we need to configure the automation workflow in Make.com:

1. Set up filters to trigger the workflow based on specific conditions.
2. Add modules to process the data as needed (e.g., OpenAI GPT integration).
3. Include an Update Row module to write the processed data back to Google Sheets.

Using the Perform a Function Option

For more advanced functionality, we can use the Perform a Function option:

1. Create a separate Make.com scenario with a Google Sheets – Perform a Function module.
2. Copy the webhook URL and paste it into the Perform a Function settings in Google Sheets.
3. Save the settings: If pop-up doesn’t appear then it didn’t work. If so, try another browser or sign out of all your other Google acounts so that the google account you want to use is the primary one that you’re logged in to.
4. Use a formula in Google Sheets to construct a prompt and trigger the function.

Finalizing the Setup

To complete the setup:

1. Test the workflow by running the scenario and updating the Google Sheet.
2. Verify that the trigger activates and the data is processed correctly.
3. Enable scheduling in Make.com to keep the workflow active.

By following these steps, you can create a powerful automation that responds instantly to changes in your Google Sheets, streamlining your workflow and improving efficiency.