👉 Get all of our make.com templates here (including this one): [ Ссылка ]
The video demonstrates how to instantly trigger Make.com from Google Sheets using instant triggers instead of scheduled checks. Scheduled operations in Google Sheets typically poll for new data every 15 minutes, which can lead to delays and consume many operations. Instead, you can set up instant triggers to respond immediately to changes, saving operations and improving efficiency.
Book a 60-minute call with us: [ Ссылка ]
Timestamps:
0:00 Overview
0:31 Watch Changes (Instant)
5:22 Perform a Function (Instant)
Step-by-Step Guide
Step 1: Set Up the Watch Changes Trigger
Add the Watch Changes Module:
In Make.com, add a new module by selecting Google Sheets.
Choose the Watch Changes option, which allows instant triggers.
Copy the Webhook URL:
The module provides a webhook URL. Copy this URL to your clipboard.
Install Google Sheets Add-On:
Open your Google Sheets.
Go to Extensions - Add-ons - Get Add-ons.
Search for Make for Google Sheets and install it.
Configure the Google Sheets Add-On:
Go back to Extensions - Make for Google Sheets - Settings.
Paste the webhook URL into the provided field.
Select the Sheet and Range:
Choose the sheet name (e.g., Sheet1) and specify the range you want to monitor.
You can select a specific range (e.g., A1
) or leave it open for the entire sheet.
Save the settings.
Handle Multiple Google Accounts:
If you encounter issues, ensure you're logged into the correct Google account.
You may need to use a different browser or set the desired account as the default.
Step 2: Set Up the Automation Workflow
Configure Filters and Triggers:
In Make.com, set up filters to trigger only on specific conditions.
Example: Trigger only if the status in a column equals "Generate Text".
Run the Scenario:
Click Run Once to test the setup.
Update the status in your Google Sheet to see if the trigger fires instantly.
Verify Trigger Activation:
Ensure the scenario is triggered and runs as expected.
If filters are applied, verify they work correctly.
Step 3: Update Google Sheets with Results
Add Update Row Module:
In Make.com, add a module to update a row in Google Sheets.
Select the same spreadsheet and sheet name used in the Watch Changes module.
Choose the row number dynamically based on the changes.
Write Data Back to Sheets:
Configure the module to write the processed data back to a specific column (e.g., column D).
Test the Complete Workflow:
Run the scenario again and update the sheet to trigger the entire process.
Confirm that the updated data appears correctly in your Google Sheets.
Step 4: Use the Perform a Function Option
Set Up Perform a Function Module:
Create a separate Make.com scenario.
Add a Google Sheets - Perform a Function module.
Configure the Webhook:
Copy the provided webhook URL and paste it into the Perform a Function settings.
Build the Prompt:
Use a formula in Google Sheets to construct a prompt.
Example: =make_function("Create text for " & B2 & " topic").
Trigger the Function:
Enter the formula in Google Sheets to trigger the function instantly.
Check Make.com to see the prompt being processed.
Validate the Output:
Ensure the result is returned to Google Sheets as expected.
Step 5: Schedule the Workflow
Enable Scheduling:
Turn on scheduling in Make.com to keep the workflow active.
This ensures that any updates in Google Sheets will trigger the automation automatically.
Access Make.com Blueprints:
For ready-to-use automations, access Make.com blueprints provided in the video's description.
Conclusion
By following these steps, you can efficiently automate tasks with Make.com and Google Sheets, minimizing delays and saving on operations. This setup allows you to handle data changes in real-time and process them instantly, enhancing your workflow's responsiveness.
If you have any specific questions or need further clarification, feel free to ask!
Ещё видео!