I'm sending some data from Zapier to Google Sheets and every time Zapier creates a new row, all formulas from that row are gone. I'm looking for a script that would allow the following solution:

I set up Zapier to always update row no. 2 (Row 1 is for table headlines) => Once Zapier fills the data in this row, a script automatically creates a new row above it, pushing all the other rows one place lower (with formulas remaining in all cells in row 2).

1 Answer 1


Use ARRAYFORMULA in row 1 and calculate rest automatically regardless of newly inserted rows. Example:



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.