In this video, I’ll show you how to trigger a webhook from Google Sheets using Google Apps Script. With this setup, you can automatically send data to Make.com when a checkbox is checked—eliminating the need to log in and manually run your scenario.
You’ll learn how to add a script that detects when values are entered, inserts a checkbox, and triggers a webhook when checked. If a value is deleted, the checkbox disappears, ensuring the process stays automated and efficient. This method is perfect for automating reports, data processing, and other workflows directly from Google Sheets.
🔥 What You’ll Learn:
✔️ How to add Google Apps Script to Google Sheets.
✔️ Automatically add checkboxes when data is entered.
✔️ Set up a webhook trigger to send row data to Make.com.
✔️ Ensure seamless automation with smart script logic.
✔️ Advanced Make.com tips & tricks to streamline your workflows.
Links (I may earn a commission if you sign up using these):
Sign Up with MAKE –
Generate Midjourney Images for as low as 0.001$ here –
Sign UP with PLACID to automatically generate social media posts –
I used this ChatGPT prompt to create apps script: I need a google apps script that will add automatically a checkbox in column D, when column A, column B, column C has values. When the checkbox is checked it will trigger a webhook and send the row number, A, B, C values to this webhook. If I delete a value, checkbox disappears and if I uncheck the checkbox and check it again it will trigger the webhook again.
If you’d like personalized coaching on Make.com or need help with your automation projects, feel free to reach out. Together, we’ll create efficient workflows that save time and increase productivity! 💼✨
📧 Email: janis@jsautomates.com
📱 WhatsApp: +37125340386
Book A Meeting Here:
AI Automations & Coaching:
Let’s automate smarter with Make.com! 🎉”
Chapters:
00:00:00 – Triggering Make.com Scenarios from Google Sheets
00:01:28 – How the Checkbox Automation Works
00:03:01 – Setting Up Google Apps Script
00:04:34 – Connecting Make.com with a Webhook
00:06:07 – Authorizing and Testing the Setup
00:07:39 – Adding Status Updates in Make.com
00:09:12 – Finalizing the Scenario with “Done” Status
00:11:00 – Benefits and Call to Action
