Fetch Squarespace Orders to Google Sheets

Name: Fetch Squarespace Orders to Google Sheets
Rating: 5 (5 reviews)
Author: Free N8N

Beginner

6 nodes connected

detail.loadingPreview

Free N8N Temples

58 views

0 downloads

E-commerceE-commerceGoogle SheetsOrdersReportingSquarespace

Automate fetching Squarespace orders and export them to a Google Sheet.

About This Workflow

This workflow automates the retrieval of order data from your Squarespace store and populates it into a Google Sheets spreadsheet. It uses the Squarespace Commerce API to fetch order details, supporting pagination to ensure all orders are captured. The data is then mapped and appended to a specified Google Sheet for easy analysis and reporting.

Key Features

Connects to Squarespace Commerce API to retrieve order data.
Supports pagination to fetch all available orders.
Customizable filters for fetching orders (e.g., modifiedAfter, modifiedBefore, fulfillmentStatus).
Maps various order details to columns in a Google Sheet.
Appends or updates existing rows in the Google Sheet.
Allows setting the API version and pagination limits.

How To Use

How to Use

Trigger: The workflow can be triggered manually by clicking 'execute' or automatically via a schedule.
Configure Globals: Open the Globals node and set the following parameters:
- api-version: The Squarespace API version (e.g., 1.0).
- modifiedAfter (optional): Fetch orders modified after a specific date in ISO 8601 format.
- modifiedBefore (optional): Fetch orders modified before a specific date in ISO 8601 format.
- cursor (optional): For pagination, cannot be combined with other filters.
- fulfillmentStatus (optional): Filter orders by status (e.g., PENDING, FULFILLED, CANCELED).
- maxPage: Set to -1 to fetch all available orders (infinite pagination).
Connect Squarespace: Ensure your Squarespace API credentials are set up in the Query Orders node.
Configure Google Sheets: Open the Squarespace Orders Spreadsheet node and configure:
- Google Sheet: Select your Google Sheets account and the target spreadsheet and sheet.
- Columns: Review and adjust the column mappings to match your desired spreadsheet structure. The workflow provides default mappings.
- Operation: Choose appendOrUpdate to add new orders or update existing ones based on the Order ID.
Execute: Trigger the workflow manually or wait for the scheduled time. The order data will be exported to your Google Sheet.

Apps Used

E-commerce

Google Sheets

Orders

Reporting

Squarespace

Workflow JSON

{
  "id": "e29cad6d-c48a-448c-9021-2cba3c40b8b2",
  "name": "Fetch Squarespace Orders to Google Sheets",
  "nodes": 6,
  "category": "E-commerce",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.

Get This Workflow

ID: e29cad6d-c48a...

About the Author

SaaS_Connector

Integration Guru

Connecting CRM, Notion, and Slack to automate your life.

Statistics

Downloads0

Rating5/5

Get Custom Workflow

Need a specific automation? Our experts can build it for you.

Trusted by top companies
7+ years experience

Related Workflows

Discover more workflows you might like

Advanced

E-commerceprice monitoringcompetitor analysisweb scraping

Competitor Price Monitoring with AI Scraping and Analysis

Automate competitor price tracking, AI-driven data extraction, analysis, and alerts.

24 nodes

420

View Workflow

Intermediate

E-commerceshopifymetadataseo

Generate Structured Metadata from Shopify Data

Fetches all data from Shopify and prepares it for structured metadata generation.

19 nodes

409

View Workflow

Advanced

E-commerceWooCommerceDHLCustomer Support

WooCommerce Order and Tracking Bot

Retrieves WooCommerce orders and DHL tracking information based on user email.

28 nodes

241

View Workflow

How to Use

Trigger: The workflow can be triggered manually by clicking 'execute' or automatically via a schedule.

Configure Globals: Open the Globals node and set the following parameters:

api-version: The Squarespace API version (e.g., 1.0).
modifiedAfter (optional): Fetch orders modified after a specific date in ISO 8601 format.
modifiedBefore (optional): Fetch orders modified before a specific date in ISO 8601 format.
cursor (optional): For pagination, cannot be combined with other filters.
fulfillmentStatus (optional): Filter orders by status (e.g., PENDING, FULFILLED, CANCELED).
maxPage: Set to -1 to fetch all available orders (infinite pagination).

Connect Squarespace: Ensure your Squarespace API credentials are set up in the Query Orders node.

Configure Google Sheets: Open the Squarespace Orders Spreadsheet node and configure:

Google Sheet: Select your Google Sheets account and the target spreadsheet and sheet.
Columns: Review and adjust the column mappings to match your desired spreadsheet structure. The workflow provides default mappings.
Operation: Choose appendOrUpdate to add new orders or update existing ones based on the Order ID.

Execute: Trigger the workflow manually or wait for the scheduled time. The order data will be exported to your Google Sheet.