How to Send Squarespace Forms to Google Sheets: 5 Methods That Actually Work in 2026

Squarespace ships a built-in Google Drive connection that creates a Sheet per form and writes one row per submission. Fastest path, costs nothing, and breaks more often than any other method on this list.

Plan requirement: available on every paid Squarespace plan. Trial does not include form storage to Drive.

1. 1

   Open the page that holds your form. Hover the form block and click the pencil icon.

2. 2

   Click Storage in the form editor.

3. 3

   Click Add Storage, then Google Drive.

4. 4

   Sign in to the Google account that should own the Sheet. Approve the Drive permission.

5. 5

   Name the spreadsheet. Squarespace creates a new file in the connected Drive root folder, one Sheet per form.

6. 6

   Save the form. Submit a test entry. A row should appear in the Sheet within 30 to 60 seconds.

What breaks: token refreshes drop and forms quietly stop writing without raising an error. Squarespace maintains a reconnect help article for exactly this. Check the Sheet weekly. If a workflow depends on this sync, pick a different method.

Zapier owns the integration directory entry for Squarespace Forms and Google Sheets and it is the path most Squarespace docs default to once the native Drive sync fails.

Pricing: free for 100 tasks per month. One submission to Sheets is one task. Paid plans start at $19.99 per month for 750 tasks.

1. 1

   In Zapier, click Create Zap.

2. 2

   Trigger: search Squarespace, pick New Form Submission. Connect your Squarespace account, select the site and the specific form.

3. 3

   Click Test trigger. Submit a test entry in Squarespace if Zapier needs one to pull a sample.

4. 4

   Action: search Google Sheets, pick Create Spreadsheet Row.

5. 5

   Connect the Google account, pick the Spreadsheet and Worksheet. Map each Squarespace field to the matching column header.

6. 6

   Test action. Confirm a row appears in the Sheet, then turn the Zap on.

What breaks: the free 100-task ceiling is the most common pain. A site doing 5 form fills a day hits it on day 20. Field mapping also resets if you rename a Squarespace form field, so re-check the Zap after any form edit.

Make is the Zapier alternative most Squarespace power users land on once monthly task counts climb. The free tier is 10x larger and the per-op cost is meaningfully lower at scale.

Pricing: 1,000 operations per month free. One submission written to Sheets is roughly two ops (trigger plus action). Paid starts at $10.59 per month for 10,000 ops.

1. 1

   In Make, click Create a new scenario.

2. 2

   Add a Squarespace, Watch Form Responses module. Authorize Squarespace, pick the form.

3. 3

   Set the polling interval. The free tier polls every 15 minutes, paid plans drop to 1 minute.

4. 4

   Add a Google Sheets, Add a Row module. Authorize Google, pick the Sheet and worksheet.

5. 5

   Map each Squarespace field to the right column. Make's mapping panel is more granular than Zapier's, useful when one form field needs to land in two columns.

6. 6

   Run once with a test submission. Save and switch the scenario on.

What breaks: free tier polls every 15 minutes, fine for daily lead capture but useless for real-time alerts. Upgrade or use a webhook-based method if speed matters.

Sheet Monkey and LeadToSheet pipe form data straight into Sheets without an automation platform sitting in the middle. Cheaper, faster, fewer moving parts.

Pricing: Sheet Monkey is free up to 100 submissions per month, $9 per month after. LeadToSheet has a free tier with a 50-submission cap.

1. 1

   Create an account on Sheet Monkey or LeadToSheet. Connect Google and pick the destination Sheet.

2. 2

   The tool generates a unique webhook URL.

3. 3

   Squarespace cannot natively post to a custom webhook from a default Form Block. Two workarounds: use Squarespace's Code Block to inject a custom HTML form that posts to the webhook, or use Zapier Webhooks as a relay (defeats the point unless you are already on Zapier).

4. 4

   Submit a test. Confirm the row.

What breaks: the Squarespace Form Block does not expose a custom action URL, so you are forced into a Code Block or a Zapier relay. That removes a chunk of the value. Worth it only if you cannot stomach Zapier's task pricing and you are comfortable pasting an HTML form into a code block.

Every method above starts from the same broken assumption: that Squarespace's form block is the right collection layer. Cleaner pattern: embed a Formester form inside a Squarespace Code Block and use Formester's native Google Sheets integration. The form still lives on your Squarespace page. The submission flow no longer touches Squarespace's storage layer.

Free tier: 10 forms, 100 responses per month, Sheets integration included on every plan. Paid starts at $13 per month.

1. 1

   Build the form in Formester. Pick the Google Sheets integration in the Automate tab, connect the Google account, pick the Sheet.

2. 2

   In Formester, open Share, Embed. Copy the embed code (toggle auto-height off if you want a fixed frame).

3. 3

   In Squarespace, open the page. Click Add Section, choose a blank section, click Add Block, pick Code.

4. 4

   Paste the Formester embed code into the Code Block. Save.

5. 5

   Submit a test. The row appears in Sheets within seconds. See the cousin guide on how to send contact form data to Google Sheets free for the inverse setup.

What breaks: nothing on Squarespace's side, since the form runs on Formester's infrastructure. Trade-off is the Code Block: Squarespace restricts Code Blocks on the Personal plan, so you may need the Business plan or above on Squarespace's side.