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.

Answer

How do I fill in a row on Google Sheets rather that create a new row?

  • October 17, 2024
  • 9 replies
  • 49 views
L
Forum|alt.badge.img

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

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

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • October 17, 2024

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
⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
L
L
Forum|alt.badge.img
  • Learn MusicBeginner
  • Author
  • Beginner
  • October 18, 2024

Thank you @Troy Tessalone!

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

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • Answer
  • October 18, 2024

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

 

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
L
ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • October 21, 2024

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! 🤗

L
Forum|alt.badge.img
  • Learn MusicBeginner
  • Author
  • Beginner
  • October 23, 2024

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:

 

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • October 23, 2024

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

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
L
Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • October 23, 2024

@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 - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
L
L
Forum|alt.badge.img
  • Learn MusicBeginner
  • Author
  • Beginner
  • October 24, 2024

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

ken.a
ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • October 25, 2024

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 & ConditionsAccessibility statement