--- title: Triggering a Zap from Google Sheets with a Button description: Learn how to trigger a Zap from Google Sheets with a button to automate tracking project milestones in Asana. Enhance workflows with this flexible solution. image: https://www.whimpact.co/hubfs/trigger%20a%20zap%20with%20a%20button%20in%20google%20sheets.webp --- [Skip to content](https://www.whimpact.co/wh1nsights/triggering-a-zap-from-google-sheets-with-a-button#main-content) [![whimpact logo](https://www.whimpact.co/hs-fs/hubfs/whimpact%20logo.png?width=333&height=250&name=whimpact%20logo.png)](https://www.whimpact.co) - [About WHI](https://www.whimpact.co/about) - [Learn - WHInsights](https://www.whimpact.co/wh1nsights) Open main navigation Close main navigation - [About WHI](https://www.whimpact.co/about) - [Learn - WHInsights](https://www.whimpact.co/wh1nsights) - [Start Your Assessment](https://www.whimpact.co/whintensive) [Start Your Assessment](https://www.whimpact.co/whintensive) Mar 7, 2024 5:38:19 PM # Triggering a Zap from Google Sheets with a Button ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) Be a hero and share this WHInsight: [Share this page via Email](mailto:?body=https://www.whimpact.co/wh1nsights/triggering-a-zap-from-google-sheets-with-a-button) [facebook-f icon](http://www.facebook.com/share.php?u=https://www.whimpact.co/wh1nsights/triggering-a-zap-from-google-sheets-with-a-button) [Share this page on LinkedIn](http://www.linkedin.com/shareArticle?mini=true&url=https://www.whimpact.co/wh1nsights/triggering-a-zap-from-google-sheets-with-a-button) [Share this page on Twitter](https://twitter.com/intent/tweet?url=https://www.whimpact.co/wh1nsights/triggering-a-zap-from-google-sheets-with-a-button) This guide explains how to use Google Sheets, Google Apps Script, and Zapier to create a trigger that starts an automation with a button click. This method was developed to track project milestones in Asana, overcoming the limitations of Asana's reporting features. ## The Challenge Our client needed a way to monitor project milestones within Asana, but the platform's reporting tools were insufficient. We decided to build a custom milestone tracker using Google Sheets, enhanced with automation from Zapier. ## The Solution We used Google Sheets to create the tracker and added a custom button to initiate the Zapier automation. Here's how we did it: ### Step 1: Preparing Zapier We set up a Zapier webhook as our trigger instead of using a scheduled trigger. This allows us to start our automation whenever the button is clicked. Zapier generates a unique URL for this webhook. ### Step 2: Google Sheets Configuration In Google Sheets, we added a drawing that serves as our button. This button, when clicked, will trigger our automation. ### Step 3: Connecting with Google Apps Script Through Google Sheets' Extensions menu, we accessed Google Apps Script and inserted code that calls the Zapier webhook URL when the button is clicked. This connects our button in Google Sheets directly to our Zapier automation. Here's the code for the function: `function sendGetRequest() {` `var response = UrlFetchApp.fetch('https://hooks.zapier.com/hooks/catch/11684903/30b2ea0/silent/');` `Logger.log(response.getContentText());` `}` ### Step 4: Testing After setting everything up, we tested the button to ensure it triggered the Zapier automation as expected. We also discussed adding a "Last Updated" flag to the tracker for better data transparency. ## Conclusion This setup provides a flexible way to automate tasks from Google Sheets, offering solutions for tracking and updating project milestones, among other applications. ## Further Steps If there's interest, I can detail the construction of the entire Asana tracker, including technical steps like using VLOOKUPs and custom code. I'm curious to hear about your potential uses for this setup and encourage experimentation to enhance your workflows. Feel free to share your experiences and insights. [Systemize Your Busyness](https://www.whimpact.co/wh1nsights/tag/systemize-your-busyness) ## Related posts [![](https://www.whimpact.co/hs-fs/hubfs/woman%20setting%20up%20deal%20tags%20in%20hubspot%20on%20her%20computer.webp?height=200&name=woman%20setting%20up%20deal%20tags%20in%20hubspot%20on%20her%20computer.webp)](https://www.whimpact.co/wh1nsights/a-guide-to-creating-deal-tags-in-hubspot) [Systemize Your Busyness](https://www.whimpact.co/wh1nsights/tag/systemize-your-busyness) ## [A Guide to Creating Deal Tags in HubSpot when Invoice Paid or Quote Signed](https://www.whimpact.co/wh1nsights/a-guide-to-creating-deal-tags-in-hubspot) ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) Feb 9, 2024 3:35:19 PM Hey, there! Creating deal tags in HubSpot allows us to efficiently track the status of deals, such... [Read more](https://www.whimpact.co/wh1nsights/a-guide-to-creating-deal-tags-in-hubspot) [![](https://www.whimpact.co/hs-fs/hubfs/2025.07.30_whinsight.png?height=200&name=2025.07.30_whinsight.png)](https://www.whimpact.co/wh1nsights/how-i-created-a-referral-and-reward-program-using-hubspot-basecamp-tremendous-and-zapier) [Strategize Your Business](https://www.whimpact.co/wh1nsights/tag/strategize-your-business) ## [A Demo of my Referral and Reward Program Using HubSpot, Basecamp, Tremendous, and Zapier](https://www.whimpact.co/wh1nsights/how-i-created-a-referral-and-reward-program-using-hubspot-basecamp-tremendous-and-zapier) ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) Jul 29, 2025 6:43:42 PM If you're looking to set up a client referral program that integrates directly with your HubSpot... [Read more](https://www.whimpact.co/wh1nsights/how-i-created-a-referral-and-reward-program-using-hubspot-basecamp-tremendous-and-zapier) [![](https://www.whimpact.co/hs-fs/hubfs/2024.07.10%20whinsight%20thumbnail.png?height=200&name=2024.07.10%20whinsight%20thumbnail.png)](https://www.whimpact.co/wh1nsights/how-i-created-a-deal-in-hubspot-with-line-items-automatically-associated-after-customer-purchase) [Systemize Your Busyness](https://www.whimpact.co/wh1nsights/tag/systemize-your-busyness) ## [How I Created a Deal in HubSpot with Line Items Automatically Associated after Customer Purchase](https://www.whimpact.co/wh1nsights/how-i-created-a-deal-in-hubspot-with-line-items-automatically-associated-after-customer-purchase) ![Picture of Ryan Schweighart](https://www.whimpact.co/hs-fs/hubfs/Chat_photo-1.jpg?width=50&name=Chat_photo-1.jpg) [Ryan Schweighart](https://www.whimpact.co/wh1nsights/author/ryan-schweighart) Jul 10, 2024 12:43:53 PM Hello, I’m Ryan Schweighart, founder of Whole Hart Impact, where I help organizations grow without... [Read more](https://www.whimpact.co/wh1nsights/how-i-created-a-deal-in-hubspot-with-line-items-automatically-associated-after-customer-purchase) --- [![Whole Hart Impact Logo 43-2](https://www.whimpact.co/hs-fs/hubfs/Whole%20Hart%20Impact%20Logo%2043-2.png?width=266&height=200&name=Whole%20Hart%20Impact%20Logo%2043-2.png "Whole Hart Impact Logo 43-2")](https://www.whimpact.co) [![SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE](https://www.whimpact.co/hs-fs/hubfs/SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE.png?width=200&height=200&name=SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE.png "SolutionPartnerTierBadges_FINAL_PARTNER_ORANGE")](https://app.hubspot.com/marketplace/20619232/solutions/whole-hart-impact) [![hubspot community champions logo](https://www.whimpact.co/hs-fs/hubfs/logos/hubspot%20community%20champions%20logo.png?width=170&height=170&name=hubspot%20community%20champions%20logo.png "hubspot community champions logo")](https://community.hubspot.com/u/rschweighart/summary) - [About WHI](https://www.whimpact.co/about) - [Get $500, Give $1,000 - WHIntroductions](https://www.whimpact.co/whintroductions) - [Pricing - WHImplementation](https://www.whimpact.co/whimplementation) - [Grow - WHIntensive](https://www.whimpact.co/whintensive) - [Learn - WHInsights](https://www.whimpact.co/wh1nsights) - [Careers - WHImpacters](https://www.whimpact.co/careers) ### I want to hear from you! [ryan@whimpact.co](mailto:ryan@whimpact.co) +1 (405) 972-6809 Located in Carlsbad, CA -- Available worldwide --- Copyright © 2026, Whole Hart Impact ```json { "@context" : "https://schema.org", "@type" : "BlogPosting", "author" : { "@type" : "Person", "name" : "Ryan Schweighart", "url" : "https://www.whimpact.co/wh1nsights/author/ryan-schweighart" }, "dateModified" : "2024-03-07T23:38:19.691Z", "datePublished" : "2024-03-07T23:38:19.000Z", "headline" : "Triggering a Zap from Google Sheets with a Button", "image" : [ "https://www.whimpact.co/hubfs/trigger%20a%20zap%20with%20a%20button%20in%20google%20sheets.webp" ], "mainEntityOfPage" : { "@id" : "https://www.whimpact.co/wh1nsights/triggering-a-zap-from-google-sheets-with-a-button", "@type" : "WebPage" }, "publisher" : { "@type" : "Organization", "logo" : { "@type" : "ImageObject", "url" : "https://www.whimpact.co/hubfs/Whole%20Hart%20Impact%20Logo%2043-1.png" }, "name" : "Whole Hart Impact, LLC" } } ```