This guide explains how to work with Google Sheets checkboxes in Zapier. We'll cover how to write checkbox values from a Zap, use checkboxes as trigger conditions, and set checkbox states dynamically.
Step-by-step guide
Method 1: Add a checkbox to Google Sheets natively, then write to it via Zapier
- Add a checkbox column to your Google Sheet. Open your spreadsheet, select at least one cell where you want checkboxes (e.g., the first data row in your checkbox column), click Insert in the top menu, then click Tick box. The selected cells will now show as unchecked boxes (false). Add a header to the column, such as "Completed" or "Approved".
- In your Zap action step, map true or false to the checkbox column. When setting up a Create Spreadsheet Row or Update Spreadsheet Row action in Zapier, find the field that corresponds to your checkbox column. Enter true to create a checked box, or false to create an unchecked box (capitalization doesn't matter: TRUE, true, FALSE, and false all work). You can use a static value or map a dynamic value from an earlier step.
- Test your Zap. Run a test to confirm the value is written correctly. The cell in your checkbox column should display as checked (true) or unchecked (false) accordingly.
Method 2: Use a checkbox value as a condition in your Zap
- Set up a Google Sheets trigger. Use the New or Updated Spreadsheet Row trigger and set the Trigger Column to your checkbox column. This means the Zap will run whenever that checkbox is updated.
- Add a Filter step to check the checkbox value. Click the + icon to add a Filter by Zapier step. Set the filter’s condition to check your checkbox column field and use the (Boolean) is true rule condition. This ensures the Zap only continues when the checkbox is ticked, not when it is unticked.
- Add your action steps after the filter. Any actions that follow the filter will only run when the checkbox is checked. This is useful for workflows where you might want to send an email when a row is marked as complete, or move a record when a task is ticked off.
Method 3: Set a checkbox value based on data from another app
- Set up your trigger from another app. For example, trigger from a new form submission, a CRM update, or a calendar event.
- Add a Google Sheets action. Choose Create Spreadsheet Row or Update Spreadsheet Row.
- Map true or false to the checkbox column dynamically. You can use a Formatter by Zapier step to convert values from your trigger into true or false before mapping them to the checkbox column. For example, if a form field returns "Yes", use Formatter (Text > Replace) action to convert "Yes" to true before writing it to the sheet. Note: Formatter is available on Professional plans and above
- Test and publish your Zap. Run a test to confirm the checkbox state is set correctly based on the incoming data.
Notes and limitations
- Zapier cannot create or format checkbox columns in Google Sheets. You must insert at least one checkbox in your target column in Google Sheets before your Zap runs. Google Sheets will automatically extend the checkbox formatting to new rows added below. Once the column’s cell is formatted as checkboxes, Zapier can writes true or false values (case-insensitive) that will display as checked or unchecked. There’s no need to pre-fill checkbox rows below where Zapier will add rows.
- When reading checkbox data in a trigger or lookup step, Zapier returns the value as true or false. You can compare against either value in a Filter or Path step to control your workflow logic.
FAQs
Q: Why is Zapier writing "true" or “false” as text instead of a checkbox?
A: The checkbox formatting may not have been applied to that column in Google Sheets. Select the relevant cell in your checkbox column, click Insert, then choose Tick box. Once the column is formatted, any true or false values Zapier writes will display as checked or unchecked boxes.
Q: Can I use checkbox values in Paths or conditional logic?
A: Yes. Checkbox values work like any other field in Zapier. You can use them in Paths the same way as with Filter steps (see Method 2 above). Just compare against true or false accordingly. See our Add branching logic to Zap workflows with Paths guide for more details.
Q: Why didn't my Zap trigger when I re-checked a checkbox?
A: The New or Updated Spreadsheet Row trigger only runs when it sees a value it hasn't encountered before in that row. If a checkbox was previously checked, unchecked, and then checked again, Zapier won't trigger on it again. To work around this, use a separate column (such as a unique value or timestamp), and set that as your Trigger Column. Learn more in the Google Sheets: Updated Spreadsheet Row trigger isn't working guide.
