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.
Zaps is creating new row to middle of spreadsheet. Why?
Userlevel 7
+11
- Community Manager
- 4706 replies
-
2 May 2023
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!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.