DougB

I want email notifications of email subscriber sign-ups (and for them to be saved in a list somewhere). I've seen the Google Sheets notification option described here but couldn't get it working end-to-end. Reason seems to be that although the Google Sheet is created and entries are made by the Squarespace email sign-up form, Google Sheet notifications fire only when changed by someone other than the owner of the spreadsheet. Because I'm connecting as the Owner when I connect to Google Sheets as the storage option, the sheet is created and entries are made but the notification won't fire (well, it didn't for me). A workaround was to share the Google Sheet with a different Gmail account and set the notifications from that account. In other words: 1. In SQ, you connect the email sign-up form storage to Google Sheets using Google account "A". The notifications won't fire because the Sheet is created by "A". 2. Google account "A" shares the Sheet with separate Google account "B" 2. Google account "B" can now set notifications on that shared sheet and will receive them when account "A" makes changes (by adding rows through the Squarespace email sign-up form) Ridiculously complicated workaround / hack but I wanted a list AND notifications. Seems Squarespace is content with providing either a list (email sign-ups) OR notification emails (contact forms). But not both 🤔 Another benefit is that it's much easier to manage rows in a Google sheet than Squarespaces contacts management.

Took a while to find it, but there is a "Delete Profile" option when you click on a Subscriber profile in the "Contacts" section.