Best answer

Stop Zapier from overwriting existing data in Google sheets

  • 18 January 2023
  • 3 replies
  • 413 views

Hello I’m adding new rows to Google sheets using a Stripe trigger. In some of the columns I’ve added formulas but every time a new row is added by zapier, the existing data is overwritten. Is there a way to prevent this?

icon

Best answer by christina.d 18 January 2023, 01:08

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Hey there, @Koen! Welcome to the community!

I just wanted to add some extra context to what Troy mentioned by sharing this similar question:

I hope it helps! 

 

Thanks, the idea of creating a reference sheet and hiding it is great. That will do the job.

Userlevel 7
Badge +9

Hey there, @Koen! Welcome to the community!

I just wanted to add some extra context to what Troy mentioned by sharing this similar question:

I hope it helps! 

Userlevel 7
Badge +14

Hi @Koen 

Good question.

You’d be better served using a database app such as Airtable instead of GSheets.

Airtable has a Formula field that will be applied to all records/rows.