Skip to main content

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

Reply


Terms & Conditions