It have to write o last row which comes new lead data. But Zap wrote middle of excel sheet. We do not realize. It have to add to last row. Create new row. Not working correctly.
Question
Zaps is creating new row to middle of spreadsheet. Why?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+11- Community Manager
Hey
Are you using formulas in the spreadsheet? If so it might be reading the formula as content and skipping those formulas and adding a new row in the first new row it finds without a formula present. You can find out more about how to fix that type of issue here: The Zap is skipping blank rows
That said, this could also apply for other values as well, not just formulas. For example, say column A already contained a number for each lead:
In the above example we can see that rows up to row 30 all contain a value so the Zap would add a new row of data into row 31, not row 19. So the contents of rows from 19-30 would need to be cleared in order for the Zap to add new data into row 19 next.
Do you think formulas or existing content in the spreadsheet might be causing the Zap to add data into the wrong row? Looking forward to hearing your thoughts on this!
The Zappy Awards are back
We're celebrating the Zapier builders making AI transformation happen. Winners get a published story on zapier.com, a trophy, $5,000 cash, and a feature at ZapConnect. Nominate yourself or a peer by July 24th, 2026.
Log in to the Community
No account yet? Create an account
Use your Zapier credentials
Log in with ZapierEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.