INVALID_ARGUMENT - You are trying to edit a protected cell or object

Questions
1

I am trying to create a scenario to add a row to the spreadsheet whenever a message is sent in a slack channel but I get this error INVALID_ARGUMENT - You are trying to edit a protected cell or object because the sheet has some protected columns although I am not trying to update those protected rows. Is there a way to configure the module to skip those protected rows instead of having to remove the protection from the fields in the spreadsheet ?

1 Like
3

Hi @Nadir_Khan,

You can use Make an API call in Google Sheets action list, can be found at the end to Append a Row with specific Range or set of non continues ranges or you can use Bulk add rows module for 1 or more rows and add columns mapping, this can work if your protected range falls outside of the range that you need to for new row.

image
image442Ă—782 27.8 KB

if range that you need to create a new row contains the protected range, you need to Make An API call.

Best,
@Prem_Patel

4

Welcome to the Make community!

Unfortunately, Make doesn’t have a “updateProtectedRange” module for Google Sheets yet.

See if such an endpoint exist in the Google Sheets Developer API reference. If it exists, you can integrate the endpoint in Make using the app’s universal module (Make an API call) or generic HTTP “Make a request” module.

According to this thread on Stack Overflow, How do you modify an existing protected range in Google sheets, it seems like you can send a “updateProtectedRange” request. An example is provided in the Sheets documentation here Named & protected ranges  |  Google Sheets  |  Google for Developers.

You can also suggest for a “updateProtectedRange” module to be made in the Idea Exchange. However, do search for a similar request (and also upvote), just in case it has already been suggested to avoid duplicates.

If you need assistance in setting up the app’s universal module, or the built-in generic HTTP modules, please provide additional information about what you have tried in relation to the external service’s Developer API Reference — how you are setting the connection up, a link to the endpoint are you trying to connect to, and what errors you are encountering.

You can also complete this brand new course/tutorial in the Make Academy on how to use external APIs — API calls with HTTP modules

  • API and Endpoints
  • Header and body
  • Multipart/form-data
  • OAuth 2.0

Hope this helps! Let me know if there are any further questions or issues.

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!