I am new to Zapier and am trying to use it to integrate Squarespace and EveryAction. When a website visitor submits a form on Squarespace, I’d like a contact record created/updated in EveryAction and a specific activist code assigned to the record.

I connected both accounts and added Filter by Zapier to filter form submissions based on one of the questions on the form. Based on the response to the question, “my state of interest field”, a specific activist code should be assigned to the contact record so that they’re enrolled in one of our state mailing lists. My issue is that Zapier cannot effectively test the zap (see below). Zapier support suggests that I use Google Sheets instead and have form submissions sent to a spreadsheet because they say that with the Squarespace trigger it can be difficult to understand which form you're selecting in the trigger within Zapier and you're not able to get live sample data. Google Sheets seems like a weird workaround and would then require more manual work, which is what we’re trying to avoid by using Zapier.

Has anyone else successfully used Zapier to integrate Squarespace and EveryAction in a similar way? If so, what do you recommend I do?