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 Notion items to new Google Docs documents

This automation allows users to automatically create a new Google Docs document whenever a new item is added to a Notion database. It streamlines the process of transferring data from Notion to Google Docs, making it easier for teams to collaborate on documents and reports. The automation triggers when a new item is added to the specified Notion database, and it then creates a corresponding Google Docs document with the relevant information. This integration between Notion and Google Docs helps users to centralize their data and workflows, improving productivity and efficiency.

26s$0.0703
Data, spreadsheets & databases

Automatically generate customized Google Docs from new form data

This automation allows users to create a new Google Doc based on a predefined template, using data from a new submission in a linked Google Form. Whenever a new row is added to the associated Google Sheets spreadsheet, the automation will trigger and generate a personalized document using the form data. This streamlines the process of creating documents from structured data, making it more efficient for individuals or teams working with Google's productivity suite. The primary systems involved are Google Forms, Google Sheets, and Google Docs.

26s$0.0703
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