We are having trouble with one of our zaps auto-populating new Squarespace leads into a random row in the middle of the Google Sheet, rather than the last row of the sheet. I have tried repopulating the Zap, turning it off/on, but nothing will trigger the new lead to populate at the bottom of the sheet, only in the middle. Please advise!
Best answer
Zaps not populating to last row of Google Sheets
Best answer by JammerS
Hi
Thanks for reaching out! When Zapier inserts new data into the middle of your Google Sheet instead of at the bottom, it's often due to hidden or blank rows that appear empty but still contain formatting or characters. Zapier treats the first empty row as the next available one. To fix this, delete—not just clear—any unused rows below your data. For a smoother experience, consider using a separate tab just for Zapier entries and avoid filters, sorting, or merged cells on that sheet. This helps prevent conflicts and ensures Zapier behaves as expected.
If you have any further questions or need additional guidance, feel free to ask. We're here to help.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+6- Zapier Staff
- 6780 replies
Hi
Welcome to the Community! 🎉
Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the CONFIGURE section of the Google Sheets action step that shows all of its fields.
Please don't include personal information in the screenshot, or be sure blur out any personal information.
Thanks!
+6- Zapier Staff
- 3527 replies
- Answer
Hi
Thanks for reaching out! When Zapier inserts new data into the middle of your Google Sheet instead of at the bottom, it's often due to hidden or blank rows that appear empty but still contain formatting or characters. Zapier treats the first empty row as the next available one. To fix this, delete—not just clear—any unused rows below your data. For a smoother experience, consider using a separate tab just for Zapier entries and avoid filters, sorting, or merged cells on that sheet. This helps prevent conflicts and ensures Zapier behaves as expected.
If you have any further questions or need additional guidance, feel free to ask. We're here to help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.