Categories
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

Categories
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!

Categories
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.

Categories
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!

Categories
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: https://www.squarespace.com/websites/create-a-portfolio

Categories
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

Categories
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

Categories
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

Categories
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

Categories
Squarespace Plugin

Squarespace Plugin: Geolocation based Currency Converter

Do you ever need a currency converter on website?

If you are a store owner, I guess you always want your products price to be display on user’s currency so they can easily figure how much it cost in their country/region