Checkbox in google sheets

Good day fellas,

Everyday a row should be added in a specific sheet and in this row should automatically create a checkbox. I tried multiple things already but havent found a solution. Would be amazing to get some support.

Best regards

Welcome to the Make community!

The Google Sheets “Add a Row” module cannot be used to add checkboxes when adding a new row.

This is because you cannot change the kind of value the cell(s) can accept while adding data to it using the “Add a Row” module.

According to the Google Sheets API documentation, to change the kind of value cells can accept, is by using the ExtendedValue property. Setting the ExtendedValue’s boolValue (boolean: true/false), will set a checkbox (checked/unchecked) based on whether you pass a true or false to it.

This can only be set using the batchUpdate method, which you can call using the generic “Make an API call” module:


For more information, see

You can also submit a suggestion for such a module to be made, in the Idea exchange, under App improvement ideas. Don’t forget to search for it first, just in case someone already suggested it!

1 Like