Question

Google Sheets to Slack Zap - Spreadsheet rows with checkboxes not detected

  • 18 January 2022
  • 1 reply
  • 113 views

I have a couple Google Sheets set up where they would send a Slack message with new or updated rows. I’ve recently added some checkboxes to the sheet - not as the trigger column - and I’ve found with both my zaps that adding the checkboxes to the sheets breaks the zap. 

 

The zaps either don’t send, or they send with missing column data (again, not columns with the checkboxes). When I back to the zap settings, during the test trigger phase it can no longer pull row information. If I delete the checkboxes from the sheet, the data is pulled again, no problem. Anyone else having this issue with checkboxes in Google Sheets breaking the zap? 


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

1 reply

Userlevel 7
Badge +14

Hi @sydney 

It’s likely because you’ve added the checkbox to all cells in that GSheet column.

The checkbox is a friendly input for a cell value.

Behind the scenes, an empty checkbox = FALSE value in the cell, and a checked checkbox = TRUE value in the cell.

 

Make sure to review the available help articles for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

As an alternative to GSheets, check out Airtable, which also has a checkbox field option: https://support.airtable.com/hc/en-us/articles/360042311954-Checkbox-field