New to Zapier - have created a trigger to add a new row to an excel spreadsheet. Other than the first row of headers, all the excel fields in the sheet are empty. Yet Zapier is adding new fields from row 560 and counting upwards as the test or zaps are created? How do i reset the start row to say 2 or understand why this is happening as the excel empty row should be 2?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
- Beginner
- 2 replies
So i found a way around my issue - i created a new sheet, copied the top row from the old sheet to the new sheet, deleted the old one, renamed the new sheet with the old sheet name and the row now resets to 2 for zaps. So seems something linked to the file or spreadsheet has a count that Zapier uses to understand which rows it thinks are occuppied with data - so by recreating a new sheet with the same headers is a way to get the row count to reset to the start count - usually row 2. I would say how the row count is established needs to be looked at.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.