How do I auto-populate data in a protected Excel/Google Sheet without allowing edits?

Hi @Hitesh Modi 

Good question.

400 bad request

If you see this error in a Zap, check if your worksheet is locked or protected.
This prevents Zapier from being able to write to the sheet, so you'll need to unlock it.

Is there some way to work in a protected sheet, i need it for CRM and my agents will be adding other data in the same sheet manually, and i don’t want them to accidentally alter the zapier data

@Hitesh Modi 

It will result in an error if trying to use a locked GSheet worksheet.

400 bad request

If you see this error in a Zap, check if your worksheet is locked or protected.
This prevents Zapier from being able to write to the sheet, so you'll need to unlock it.

thank you, doesn’t solve my problem though, there should be a way we could give restricted access to zapier, it works in specified columns anyway

@Hitesh Modi 

If you have a Zapier paid plan, you can submit feedback and feature requests via a ticket to Zapier Support to be logged: https://zapier.com/app/get-help

can i run the zap manually, instead of auto update, this way i could stop the protection when i need to update the sheet

@Hitesh Modi 

Look into using Transfers by Zapier: https://zapier.com/app/transfers