Question

How do I trigger a new calendar event when clicking on a Microsoft Excel sheet checkbox through Google Drive?


when I click on a checkbox in my excel sheet I want it to automatically create a google calendar event with the information in the same row. thanks.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

I already tried this but marking the checkbox did not create a event on my google calendar


“New or Updated Spreadsheet Row” trigger behavior

If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap. If you select a specific column, then the Zap will only trigger when there are changes on that column.

 Note

Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank. To avoid triggering in those cases, add a Filter step to your Zap.

Userlevel 7
Badge +6

Hi there @amymillar,

Welcome to the Community! 🎉

You mentioned that you want to trigger the Zap when a checkbox is checked in your spreadsheet in Google Drive.

Have you tried using the “New or Updated Spreadsheet Row (Team Drive)” trigger? Please note that this trigger is a polling trigger so you would need to wait for around 15 minutes for it to trigger or depends on if you’re on a Professional Plan or higher.

Polling means that Zapier checks the triggering app at regularly set intervals, and only runs your Zap when new information is found. For example, the polling interval for our free and Starter plans is 15 minutes, while it can be as low as one minute for plans such as Companies! More about this here: https://help.zapier.com/hc/en-us/articles/8495924437005#polling-triggers-0-0

Hopefully, this helps! 😊