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

To trigger a Zap in Zapier when a checkbox is clicked in Google Sheets, you need to understand how checkboxes work—they return TRUE (checked) or FALSE (unchecked).

Here’s how to set it up:

1. Set up your trigger

• In Zapier, choose Google Sheets as the app
• Select the trigger event “New or Updated Spreadsheet Row”
• Connect your sheet and pick the correct worksheet

2. Structure your sheet

• Make sure your checkbox column is already added in Google Sheets
• Each checkbox should return TRUE/FALSE (default behavior)

3. Add a Filter (important)

• After the trigger, add a Filter by Zapier step
• Set the condition:
  → Checkbox column (Text/Boolean) is exactly TRUE
• This ensures the Zap only runs when the box is checked

4. Test the Zap

• Check a box in your sheet
• Run a test to confirm Zapier picks up the updated row

5. Turn on the Zap

• Once confirmed, enable it so it runs automatically

Tip:
Zapier doesn’t detect the “click” itself—it detects the change in value. So every time the checkbox flips to TRUE, the Zap triggers.

If you want, tell me what you want to happen after the checkbox is clicked (email, Slack message, CRM update, etc.), and I can help you build the full workflow.

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.