Newsletter sign-ups not populating Google Sheets from Squarespace

Userlevel 1

I am trying to do a simple zap . From our website (which we use squarespace) to google sheets, anyone who signs up for our newsletter (after they double opt in) to pop up on a google spreadsheet.  When I test this it works but when I use an email to sign up it does not show up on the spreadsheet.  Is there someone out there that can help?  Thanks, Susan

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

5 replies

Userlevel 7
Badge +8

Hi @Abound Chiro - Beginner -

I would love to help with this! Do you mind sharing a screenshot of your Zap set up, in similar fashion to this screenshot? It will allow me to take a closer look and determine a good starting point to getting this Zap set up successfully! 

Userlevel 1

You rock!  Ok, see if this screen shot helps.



Userlevel 1

You Rock .. Thanks so much for looking into this.  


Userlevel 7
Badge +14

Hi @Abound Chiro - Beginner 

Good question.

Looks like you are using ConvertKit as the Zap trigger step.

Please clarify which ConvertKit Zap trigger you are using. (post screenshots)

Userlevel 1

Thank you, Troy, for responding. I actually just got it to work via squarespace and google drive hookup.  I bypassed Zapier.  Not sure what was going on with Zapier but nonetheless I am good to go!  Thank you!!