Skip to main content

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.

Hey @esat, welcome to the Community! 🙂

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:
a65bdba37625b7dbf81b4937050d7268.png
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