Good day fellas,
Everyday a row should be added in a specific sheet and in this row make.com should automatically create a checkbox. I tried multiple things already but havent found a solution. Would be amazing to get some support.
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!