Latenode
Google sheets
Mailchimp

Sync Squarespace newsletter signups to Mailchimp via Google Sheets

This automation template helps Squarespace website owners synchronize their newsletter subscriber data from Squarespace to Mailchimp via Google Sheets. It addresses the limitation of Squarespace's native Mailchimp integration, which only supports new, empty audiences.

The workflow captures newsletter signups in a Google Sheets spreadsheet and then automatically creates new contacts in a selected Mailchimp audience based on the email addresses and names from the spreadsheet. Users can trigger the workflow manually or schedule it to run periodically for continuous synchronization. The template requires Mailchimp API credentials and Google Sheets API access.

Updated Apr 2, 2026Est. run: 8sEst. cost: $0.0005
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Data, spreadsheets & databases

Workflow preview

What this template does

  • Extracts newsletter subscriber data from Squarespace
  • Stores subscriber data in a Google Sheets spreadsheet
  • Adds new subscribers to a selected Mailchimp audience
  • Supports continuous synchronization via scheduled workflow
  • Requires Mailchimp API credentials and Google Sheets API access

How it works

1
Trigger

Retrieve Squarespace Newsletter Signups

Retrieve the Squarespace newsletter subscriber data from a Google Sheets spreadsheet.

2
Logic

Transform Subscriber Data

Prepare the subscriber data (email addresses and names) for import into Mailchimp.

3
Action

Add Contacts to Mailchimp

Create new contacts in the specified Mailchimp audience based on the transformed data from the Google Sheets spreadsheet.

Setup guide

1

Add Mailchimp credential

Add your Mailchimp API key in the Latenode Credentials panel. This will allow the workflow to create new contacts in your Mailchimp audience.

2

Add Google Sheets credential

Add your Google Sheets API credentials in the Latenode Credentials panel. This will allow the workflow to access the Google Sheets spreadsheet containing the Squarespace newsletter signups.

3

Configure Google Sheets node

In the Latenode visual builder, add a Google Sheets node and configure it to read data from the spreadsheet containing the Squarespace newsletter signups. Specify the spreadsheet ID and sheet name.

4

Configure Mailchimp node

In the Latenode visual builder, add a Mailchimp node and configure it to create new contacts in your desired Mailchimp audience. Map the email address and name fields from the Google Sheets data to the Mailchimp contact fields.

5

Add manual trigger

In the Latenode visual builder, add a manual trigger node to allow you to run the workflow on demand. You can also add a schedule trigger node if you want to run the workflow periodically.

Requirements

Mailchimp account with API credentials
Google Sheets API access and a Google Cloud Platform project
Squarespace website with newsletter signup functionality
Latenode workspace with the required integrations (Squarespace, Google Sheets, Mailchimp)

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.
Contact support →

More templates

You might also like

Browse all templates →
Data, spreadsheets & databases

Automatically sync new Notion items to Google Docs documents

This Latenode automation template allows you to automatically create a new Google Docs document whenever a new item is added to a Notion database. This streamlines your workflow, ensuring that your important information is easily accessible across both platforms. The integration works by detecting new items in your Notion database and then creating a corresponding document in a specified Google Docs folder, with the content from the Notion item copied over. This saves time and keeps your documentation organized, allowing you to focus on more strategic priorities.

8s$0.0005
Data, spreadsheets & databases

Automatically create Google Docs from new Google Forms submissions

This Latenode automation template creates a Google Doc based on a pre-defined template, using data from new submissions in a linked Google Forms spreadsheet. Whenever a new response is added or an existing one is updated in the spreadsheet, the integration automatically generates a corresponding Google Doc, eliminating the need for manual copy-pasting. This saves time and ensures that all form responses are captured in a document format for further processing. The key integrations involved are Google Forms and Google Docs, with the Google Forms spreadsheet serving as the data source and the generated Google Docs as the output.

7s$0.0004
Data, spreadsheets & databases

Automatically notify via Burst SMS when new rows added to Google Sheets

This Latenode automation allows users to stay focused on their primary workflows by automatically sending SMS messages through the Burst SMS platform whenever a new row is added to a specified Google Sheets spreadsheet. It connects the Google Sheets data source to the Burst SMS service, streamlining the notification process. Users can configure the specific spreadsheet and mobile number to receive the SMS updates, helping them stay informed without getting distracted from their main tasks.

7s$0.0004