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?
New line added by Zap deletes existing formulas in Google Sheets
Userlevel 1
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Hi
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:
- In your Zap, you can add the formula to the field
- You can create dynamic ARRAYFORMULA in the GSheet: https://support.google.com/docs/answer/3093275?hl=en
- Try using Airtable instead of GSheets: https://zapier.com/apps/airtable/integrations
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.