How to configure Zapier to trigger on checkbox clicks in Google Sheets

Hi ​@Martygh 

I’d recommend using Airtable instead of GSheets.

Airtable has specific column types. (checkbox, date, single select, number, formula, etc.)

Airtable has Views that can be configured with filter conditions to control which records trigger automations.

Airtable has native Automations that can be used to set record field values and do other actions.

Help links for using Airtable in Zaps: https://zapier.com/apps/airtable/integrations#help

Hey ​@Martygh,

I would recommend changing the logic so that Zapier can reliable detect the updates. Maybe make it a dropdown field rather than just a checkbox if it’s reliably triggering the Zap.

You can also consider using Zapier Tables/Airtable for your use case. Hope it helps!

PS: If you need more active help, I’m happy to connect through my Zapier Solution Partner page if you’d like to reach out here- https://zapier.com/partnerdirectory/automation-jinn

Hi ​@Martygh 

The issue is that Zapier's "New or Updated Spreadsheet Row" trigger sees your formula-driven change but doesn't reliably detect it. Here's the fix:

Step 1: Keep your Google Sheets trigger as "New or Updated Spreadsheet Row"

Step 2: Add a Filter by Zapier step immediately after the trigger

Step 3: Set the filter condition to:

• Checkbox column → (Boolean) Is true

How it works: The Zap triggers on any row update (manual or formula). The filter stops the Zap unless the checkbox was actually checked to TRUE. This ignores your formula's changes completely.

Hope this helps you get it sorted! And let me know how it goes — happy to dig deeper if needed!

And if you'd rather just get it sorted quickly, I offer a free 20-min Zapier troubleshooting call. Book it under Resources on my Zapier Directory profile: https://zapier.com/partnerdirectory/automatemybiz!-->

The main issue is that Zapier is better at seeing the checkbox change itself than a formula result.

So instead of triggering from the formula column (Survey Status = SENT), set the trigger to watch the checkbox column directly.

Simple setup:

1. Use Google Sheets → New or Updated Spreadsheet Row
2. In the trigger, watch the Completion Status column
3. Make sure the checkbox writes a real value like TRUE when checked
4. Add a Filter step: continue only if Completion Status = TRUE
5. Then send the email using the email from that same row

Why this helps:

• Zapier may miss formula-driven changes
• But it can more reliably catch the actual row update from the checkbox click

Also:

• Do not use “Any column” if you want this to be precise
• Pick the checkbox column only
• Test with a new checkbox click on a fresh row, not an old value you already used before

So the short answer is:

Trigger on the checkbox column, not on the formula column.
Then use a filter for TRUE, and that should make the Zap much more stable.

Hy ​@Martygh, just checking in – have you got it sorted, or are you still having the issue?