Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Using Checkboxes in Sheets to trigger Slack Messages

  • November 3, 2022
  • 2 replies
  • 341 views
A

Hello folks, I have a ZAP that I want to trigger when a checkbox is ticked in a column.

I currently have it set up to trigger when a column is updated, and all the cells in that column (where there are rows that contain data) have an empty checkbox in them by default.
 

The problem is, it appears never to actually trigger this first step. I do have a filter set up for step 2 as shown here:

But the ZAP never gets started. When I tick the checkbox in the spreadsheet, I expect Zapier to understand that as an Updated Row from Sheets. But it is not even starting the first step, so there’s no history to investigate.

Why wouldn’t ticking the checkbox in the assigned column result in a trigger?

Did this topic help you find an answer to your question?
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

Troy Tessalone
Forum|alt.badge.img+14

Hi @AutomatonMarshall 

Good question.

 

Triggering on new/updated rows in a sheet on another Team Drive

Zapier relies on Google Drive's notification system to identify when there are changes in a spreadsheet.
This currently works well for Google Sheets in your own Google Drive, but can be a problem for spreadsheets within a Team Drive.

In order to help Google prioritize that issue, please visit Google’s issue tracker, and click on the "star" at the top, to indicate that you would like the problem to be fixed.

In the meantime, Zapier has created separate triggers that work with Team Drives.
These are marked with (Team Drive) in the Event dropdown menu, in the Choose App & Event part of your trigger step.

 

The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger

The triggers for Google Sheets are unique among Zapier triggers.
When there is a trigger event in the spreadsheet,
Zapier gets a notification webhook from Google about this.
After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods.
This process takes about 3 minutes overall.

While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
A
1 person likes this
  • A
    AutomatonMarshall
jesse
Forum|alt.badge.img+9
  • jesseArchitect
  • Architect
  • 1348 replies
  • November 7, 2022

Hey @AutomatonMarshall! Just checking in here to see if either of Troy’s suggestions ended up being the issue and where you’re at now. I see you “liked” his post and wanted to make sure you got the answers you were after!

Terms & Conditions