Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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!

Hi @Learn Music 

You will need to add a “lookup” column to search by to find a row to fill in then update that found row.

  • Action: GSheets - Lookup Row
    • e.g. Column = USED, Value = NO
  • Action: GSheets - Update Row
    • Map the Row/ID from the previous step
    • Set the column Used = YES

Thank you @Troy Tessalone!

I think I understand, but would you mind breaking it down in a bit more detail? Thanks so much!

@Learn Music

Add a column to the GSheet called: USED

  • Set the value for populated rows to: YES
  • Set the value for unpopulated rows to: NO

 

Add these steps:

  • Action: GSheets - Lookup Row
    • e.g. Column = USED, Value = NO
  • Action: GSheets - Update Row
    • Map the Row/ID from the previous step
    • Set the column Used = YES

 

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.

 

Hi @Learn Music,

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 @ken.a!

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:

 

@Learn Music 

Check 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/

@Learn Music 

Help 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.

@Troy Tessalone It is working now! Thanks for all the help.

That’s amazing @Learn Music! A huge thanks to Troy for pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗

Terms & Conditions