Question

New line added by Zap deletes existing formulas in Google Sheets

  • 15 January 2022
  • 1 reply
  • 326 views

Userlevel 1
hello community,I shoot information into a Google Sheets spreadsheet (columns from A to D) via Zapier. From column E I have certain formulas in it. Calculating certain things based on columns A through D. The big problem is as soon as a new line is created via zapier, all the forms from column E onwards are lost. Do you have an idea how I can solve it? That the formulas in the columns from E on remain. Although a new row is created via Zapier?

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

1 reply

Userlevel 7
Badge +14

Hi @Atilla 

This is because the GSheets Create Row action actually adds a new row to the GSheet.

For example, if your GSheet has 100 rows, then the Zap runs, the GSheet will now have 101 rows.

Some options:

  1. In your Zap, you can add the formula to the field
  2. You can create dynamic ARRAYFORMULA in the GSheet: https://support.google.com/docs/answer/3093275?hl=en
  3. Try using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations