How to sync Squarespace orders to Google Sheets (step by step)

This guide is for Squarespace store owners who want their orders in Google Sheets without downloading a CSV every time. We'll walk through the real setup in SuperJack, screen by screen. At the end you'll have a sheet with one row per item ordered, custom form answers included, that keeps itself up to date every hour. (Looking for forms, products or showing a sheet on your site instead? See all the ways to connect Squarespace to Google Sheets.)

What you need

• A Squarespace store that takes orders.
• A Google account. Create a blank spreadsheet in Google Sheets before you start, so it's ready to pick.
• About two minutes.

1. Create your account

Go to superjack.app/register. Fill in Name, Email, Password (at least 8 characters) and Confirm password, then click Start free trial. If you'd rather not make a new password, click Sign up with Google.

You won't be asked for a card yet. That comes at the end, once you've seen your orders in your sheet.

2. Connect Squarespace

The next screen is Connect your store and your sheets. Click Connect Squarespace. A Squarespace window opens: sign in if it asks, then allow access to your store.

Squarespace access is read-only. SuperJack copies your orders and products, and never changes your store.

3. Connect Google Sheets

Once Squarespace shows Connected, click Connect Google Sheets. Choose the Google account that owns your spreadsheet and allow access. In Google, SuperJack can only open spreadsheets you pick or that it creates for you.

When both cards say Connected, click Continue.

4. Set up your first sheet

This screen is where you create your first workflow. A workflow connects your Squarespace store to one sheet.

1. Give it a Workflow name, such as "Shop orders". Only you see it.
2. Under Source, check that your Squarespace store is the right one. If you connected more than one store, pick it from the list.
3. Under What to sync, leave Orders selected. (Choose Products if you want your product list with prices and stock levels instead.)

4. Under Destination, click Spreadsheet and type to search your Google Drive. If your spreadsheet doesn't show up, click Find it in Google Drive.
5. Choose the Sheet (the tab) the orders should go in. Use a sheet you keep just for SuperJack. We'll come back to why in the tips below.

6. Click Create workflow.

5. Run a test sync

Your workflow exists now, so a Run a test sync button appears next to Save. Click it.

SuperJack fetches your orders from Squarespace and writes them to your sheet. When it's done you'll see Test sync finished. Click Open in Google Sheets to look.

6. Start your free trial

Back in SuperJack, click Choose a plan. Pick monthly ($19 a month) or yearly ($12 a month, billed $144 a year) and click Start free trial on that plan. You add a card on Stripe's checkout page, and nothing is charged for 3 days. Cancel before then from Settings, Billing and you won't pay anything.

Once your trial starts, hourly syncing starts too.

What you'll see in the sheet

Row 1 holds the column headers. Below it, every item ordered gets its own row, the same way Squarespace's own CSV export works. An order with three products becomes three rows, with the order details (number, date, customer, totals) repeated on each. Newest orders are at the top.

An illustration of the sheet, with some columns hidden to fit.

You get columns for the order (Order Number, Created On, Fulfillment Status, Subtotal, Grand Total, Refunded Total, Promo Codes, Internal Notes), the customer and billing address (Customer Email and the BA - columns), shipping (Shipping Address, Shipping Option, Fulfilled On), and the item (Name, Product SKU, Quantity, Price, Options for variants like size).

Custom form answers get columns too. Every checkout form question has its own column, and so does every product form question. Our guide to custom form answers in Google Sheets shows how those columns are named and what you can do with them.

It keeps going on its own

After the test sync, you don't need to do anything else. Every hour, SuperJack syncs again, and each sync updates the whole order history: every order, not only the new ones. So when you mark an order fulfilled, refund it or add an internal note in Squarespace, the sheet catches up within the hour. Orders never appear twice, and orders from before you signed up are there from the first sync.

If you want the sheet updated right now, open the workflow from your dashboard and click Run a test sync again.

Optional settings

Open the workflow from your dashboard to see everything. Changes apply from the next sync.

Columns. Untick any column you don't need. ID, Order Number, Created On and Name are always included. If you add a new custom form question, click Refresh columns after someone has answered it.

Filters. Set a Start date or End date to sync only orders placed in that range. Under Products, untick a product to leave its rows out of the sheet.

Options.

• Sync every hour: turn it off to pause syncing. Your sheet stays as it is until you turn it back on.
• Oldest orders first: new orders go at the bottom of the sheet instead of the top. Turn this on if you use Zapier's New spreadsheet row (Team Drive) trigger.
• Show the last sync time: writes the time of the last sync in cell A1 and moves the column headers to row 2.

Tips

Keep your own work on another sheet. SuperJack keeps the synced sheet matching your store, so anything you type into it is replaced on the next sync. Put your notes, formulas and charts on another sheet (tab) in the same spreadsheet that reads from the synced one. That way your work stays put and always sees the latest orders.

Build a packing list. A second sheet with a few formulas can turn your orders into a list of what to pack today. See how to make a Squarespace packing list in Google Sheets.

Use form answers. Gift notes, pickup or delivery, engraving text: see how to get Squarespace custom form answers into Google Sheets.

Questions

Does it include orders from before I signed up?

Yes. The first sync brings in your whole order history, and every sync after that updates all of it. If you only want recent orders, set a Start date under Filters.

What if I change an order in Squarespace?

The next sync picks it up. Because each sync updates the whole order history, a new fulfilment status, a refund or an internal note shows up in the sheet within the hour, on the rows that are already there.

How many sheets can I sync?

Up to 10 workflows on either plan, and each workflow keeps one sheet up to date. You might use one for orders and another for your products and stock levels.

What happens if I disconnect Google?

SuperJack stops syncing and deletes the workflows that use that Google account. Your spreadsheets and the orders already in them stay as they are. Connect Google again and create a new workflow to start syncing again.

Start syncing

That's the whole setup: connect two accounts, pick a sheet, run a test sync. If you get stuck, use Get help in your SuperJack dashboard and a real person will help.

Start your free trial and see your orders in your sheet in about two minutes.