Squarespace Squarespace Solutions

Squarespace Workflow: Connect Order to Mailchimp

Squarespace actually allows to connect with Mailchimp, but it only happens with Form/Newsletter submission only (to create new lead on Mailchimp list). What would you do to assign tags based on purchased products on lead item?

1. The problem

Let’s see…

  1. Get email notified when someone ordered
  2. Check email to get basic info: customer email, billing address, line item’s product name, look up for lead tag value (in case you need to trigger an automation via tag assigning)
  3. Manually place these pieces of information to Mailchimp

Repeat these steps for 1, 10 or thousands of times may become a pain, check how people asked about it around

2. How it solved?

When it comes to automation, Zapier is a common name, but sadly the connection between Squarespace and Zapier is limited (only available for form submission). So for the first version of the implementation, I tried to implement an email parser to read the order confirmation email in admin inbox and use these info to fire Mailchimp API to register lead and assign tag.

It turned out working well, but it was a bit silly (!?) because I overlooked the built-in API of Squarespace, which can be found here. Which the help of the API and a Google Spreadsheet, I can achieve the working solution smoothly. How a Google Sheet can help (?), you may asked yourself, so here’s why

  • It’s free (with quota limitation)
  • It provide scripting editor called Google Apps script, a handy tool that can get the automation job done, with Javascript syntax
  • Google Apps script can trigger Squarespace API call as well as Mailchimp API
  • A time driven trigger can be set up to check for lastest order made automatically
  • The Google Sheet can be used as logger to display the tagged order

3. Is it actually work?

So after enable Mailchimp and Squarespace API key, I tested it and as below

  1. An order made on my store
  2. Upon a certain period of time ( 5 minutes in this case ) the order is fetched from the api
  3. A JSON object is recieved and parsed into basic lead info
  4. The Mailchimp API endpoint is called to pass the info along and new lead with tag created/updated

Squarespace Squarespace Plugin

Squaresplace Plugin: Custom description per product

Have you ever wanted to place different description on different set of products and this info will be constantly changed? Manually adding them into each product can be an option, but it will soon become a headache when there are lots of products and the description required to update every week!

Squarespace Squarespace Plugin

Squarespace Plugins: Create custom Headlines for Tag and Category Pages

You may already feel familiar with Blog feature of Squarespace, when create new /blog page, you got a list of blog posted and can also manage them in tags and categories to make them organized.

Squarespace Solutions

Squarespace Solutions: Create personalized certificate on donation

Squarespace has provided Donation block feature that can help people to donate in your account, what if you need to give them a personalized certificate as a gift? The current system allow you to edit the email template but there is no way you can create an attachment!

Squarespace Plugin

Squarespace Plugin: Side-by-Side sticky section

Squarespace’s Designers crew is the best, when I am run out of idea, I usually visit their homepage to learn something new. One of the most catchy design there is a side-by-side sticky version where one side of section is sticked to top of screen while the other side is scrollable, like so:

Squarespace Plugin

Squarespace Plugin: Filterable table with GSheets

Squarespace builder always complain a lot about table on the platform, it’s simply not supported! Therefore site owner always looking for the best way to display table on the site

Squarespace Plugin

Squarespace Plugin: Geolocation World Clock

You may have familiar feeling whenever seeing your current location is displaying on a website right? That is what Charlie expect when he asking me to build a World Clock on his website

Squarespace Plugin

Squarespace Plugin: Modify embedded Vimeo

Have you used Vimeo?

Embedding videos from another host like Vimeo helps your site load faster, enables visitors to share your videos, and provides multiple options for video hosting

Squarespace Plugin

Squarespace Plugin: Animated Signature

In 2020, Squarespace has become one of the most CMS out there, but back in 2016, it’s not quite popular that much, let’s see how a regular project feature become a Squarespace custom code request

Squarespace Tips

Squarespace 101: How to inject custom code

Being an active member on squarespace forum, I’ve been asked a lot questions about some simple customization, most of them can be solved by inject custom css or javascript, here is how to do

Add Custom Css to the site

  • Navigate to Settings Page
    Usually your
  • Click for item Design, then select Custom Css
  • Paste the code to Custom css textarea
    Tips: Paste it in the end of the box
  • Press Save

Add Custom snippet to Single page

  • Navigate to Settings Page
    Usually your
  • Select Pages item, where you manage ste’s pages
  • Hover over the name of the page name, click on gear icon
    There will be a popup show up, click on Advanced
  • Paste the code snippet to end of the Page Header Code Injection

Add Custom snippet side-wide

  • Navigate to Settings Page
    Sed do eiusmod ut tempor incididunt ut labore et dolore.
  • Click Advanced, then Code Injection
  • There 2 boxes, HEADER and FOOTER
    Paste the snippet in one of them, based on the instruction, usually on Footer

Find the fixed element id with Chrome Extension

Sometime you just wanna apply the code to one block only, what is when this plugin useful

Find this plugin on Chrome Extension and Install it
Squarespace ID Finder – Chrome Web Store (

  • Once install, visit your website
  • Look for the extension icon on the top right of browser
  • Click on the icon, there will be some text show up above your blocks
  • Click on them to copy to clipboard and follow answers instruction