Hello!
I am trying to do the following: When someone fills out one of two forms on Squarespace, transfer the information to a Google Sheet.
I would like the information to be put in the first empty row from the top rather than creating a new row (I tried using Update Spreadsheet Row, but I believe I may have messed it up somehow).
What is the process for setting up something like this?
Thank you!
Best answer by Troy Tessalone
Add a column to the GSheet called: USED
Add these steps:
Zap will find the next row with USED = NO, then update that row to be USED = YES, along with the other columns you specify to be set with values.
When in doubt, test it out.
+14Hi
You will need to add a “lookup” column to search by to find a row to fill in then update that found row.
Thank you
I think I understand, but would you mind breaking it down in a bit more detail? Thanks so much!
+14Add a column to the GSheet called: USED
Add these steps:
Zap will find the next row with USED = NO, then update that row to be USED = YES, along with the other columns you specify to be set with values.
When in doubt, test it out.
+6Hi
I just came across your post here and wanted to check in here to see how you’re getting on. Were you able to follow Troy’s suggestion here?
Please do let us know if you’re still in need of some help on this at all - happy to assist further! 🤗
Hello
Thank you for checking in. I am still struggling to get the sheet to populate. When I test the step on Zapier, it works, but when I test it from the website it does not. This is what I have:
+14Check your Zap Runs history details to see activity and the DATA IN/OUT for each step to help you troubleshoot: https://zapier.com/app/history/
+14Help links for using Squarespace in Zaps: https://zapier.com/apps/squarespace/help
From experience using Squarespace Forms in Zaps can be a bit tricky to get configured correctly.
+6That’s amazing
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
