Best answer

Error: Confusion with Squarespace Trigger Action for Spreadsheet Row Creation

  • 22 February 2024
  • 3 replies
  • 19 views

I set up form submission as a trigger via squarespace, but am finding the action step a little confusing. I have created a spreadsheet called ‘Leads’ and would like a spreadsheet row to be created after each form submission. 


When connecting the bridge between the two services, the Action contains required entries for the spreadsheet (which populates with the correct spreadsheet) and ‘worksheet.’ I’ve no idea what the worksheet is and why it’s required, when the spreadsheet is being retrieved properly. 

 

If anyone could help with this, I”d be super grateufl

 

icon

Best answer by Troy Tessalone 22 February 2024, 22:24

View original

3 replies

Userlevel 7
Badge +14

Hi @nuclear-rabbit 

A spreadsheet is a file.

1 spreadsheet can have 1+ worksheets.

The Worksheets are the tabs at the bottom.

 

To help us have more context, post screenshots with how your Zap steps are outlined and configured.

 

Ahhh

 

Thank you. I thought I was losing my mind when I didn’t see a ‘create worksheet’ option under the top menu bar. As soon as I looked down at the bottom it cleared everything up. 

Userlevel 7
Badge +6

That’s great news @nuclear-rabbit! Big 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! 🤗

Reply