I have a zap that adds a new row to a google sheet with each new lead we get. How can I have one of the cells be a checkbox? I can add the true/false checkbox in the sheet manually but cannot find any documentation on adding it via Zapier.
Best answer by Liz_Roberts
Thanks for reaching out- great question! This is doable with a few steps and a bit of a workaround provided by my colleague! Check out this GIF and steps below:
- Initially you will have nothing in the column (where you aim to include the checkbox)
- Use the Zap to add TRUE or FALSE as text
- Highlight the data in the column and click Insert >checkbox
- Result: a check box being added with ticks/empty as appropriate
The thing to remember is that this will not work if the checkboxes are added prior to turning on the Zap (the Zap will think that the row is full and will add the row underneath the checkboxes)! So you would need to add the data from the Zap, then select it and turn it into checkboxes.
Let us know how it goes or if you have any additional questions!