Automate Squarespace Orders to Google Sheets Using Make.com

Running a Squarespace store is a thrill—until you’re bogged down manually exporting orders to keep track of sales. I hit that snag recently when I moved my latest freebie, Ground Control, behind a paywall. It’s a digital product I’d been offering for free, but now that it’s a paid item (you can pay whatever you want), I needed a seamless way to monitor orders without juggling spreadsheets. That’s where Make.com (formerly Integromat) stepped in, automating my Squarespace orders into Google Sheets in real time. Here’s how I set it up.

Why Automate with Make.com?

Make.com is a powerhouse for automation. It’s flexible, intuitive, and connects apps like Squarespace and Google Sheets with ease. Instead of spending time on manual exports, you can let Make.com do the work, so you can focus on your business. Plus, it’s cost-effective and scales as you grow.

What You’ll Need

Here’s your quick checklist:

• A Squarespace account with a store (Commerce plan recommended).

• A Make.com account (the free tier offers 1,000 operations/month—plenty to start with).

• A Google account with Google Sheets access.

• About 15 minutes to set it up.

Step 1: Set Up Your Google Sheet

Create a new Google Sheet and name it something like “Squarespace Orders” for clarity. In the first row, add headers for the data you want to capture—think “Order ID,” “Customer Name,” “Email,” “Product,” “Total,” and “Date.” This keeps your order details organized once the automation kicks in.

Step 2: Connect Squarespace to Make.com

Log into Make.com and click “Create a New Scenario” from the dashboard—it’s your starting point.

1. Add Squarespace as a Trigger:

   • Click the “+” icon to add a module.

   • Search for “Squarespace” and select it.

   • Choose the “Watch Orders” trigger to track new orders—it’s ready to go in Make.com.

   • Click “Add” next to Connection, then “Create a Connection.” A pop-up will prompt you to sign into Squarespace and authorize Make.com. Follow the steps, select your site, and you’re linked via OAuth—no manual API keys needed.

2. Test the Trigger:

   • Run the scenario once to pull sample data. If you’ve had a recent sale, it’ll grab that. No orders yet? Place a test order for Ground Control (or your own product!).

Step 3: Link Google Sheets

Now, let’s send those orders to your spreadsheet.

1. Add Google Sheets as an Action:

   • Click the “+” after the Squarespace module to add the next step.

   • Search for “Google Sheets” and select “Add a Row.”

   • Connect your Google account via OAuth (just like Squarespace)—sign in when prompted.

2. Map the Data:

   • Choose your “Squarespace Orders” spreadsheet and the specific sheet (usually “Sheet1”).

   • Match the columns to Squarespace fields, like:

     • “Order ID” → Order ID.

     • “Customer Name” → Customer First Name + Customer Last Name.

     • “Email” → Customer Email.

     • “Product” → Line Items Name (multiple items might need an iterator—see below).

     • “Total” → Grand Total.

     • “Date” → Created On.

   • Make.com’s drag-and-drop interface makes this a breeze—just pull the fields over.

3. Handle Multiple Items (Optional):

   • If an order has multiple products, add an “Iterator” module before Google Sheets. Set it to loop through Line Items, then tweak the Google Sheets action to use the iterator’s output. This gives each item its own row.

Step 4: Test and Activate

• Click “Run Once” to test it. Check your Google Sheet—your test order should appear with all the mapped details.

• If it’s perfect, toggle the scenario “On” at the bottom left. Make.com will now watch your store 24/7, adding new orders as they happen.

Bonus Tips

• Filter Specific Orders: Want only Ground Control sales? Add a “Filter” module after Squarespace to check conditions like Line Items Name contains "Ground Control".

• Scheduling: Make.com runs scenarios every 15 minutes interval by default, but you can adjust it to batch orders hourly if you prefer.

• Pricing: The free plan suits small setups. Scaling up? Plans start at $9/month for more operations.

Why This Rocks

This setup revolutionized how I track Ground Control sales. Every order hits Google Sheets instantly—great for monitoring revenue, spotting trends, or even linking to other tools (Make.com connects to 2,000+ apps). Whether you’re selling digital products or physical goods, this automation keeps you in control.

Ready to try it? Sign up for Make.com, follow these steps, and watch your Squarespace orders organize themselves. Questions? Drop them in the comments—I’d love to help!