Fetch Squarespace Orders to Google Sheets

• 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

1. Trigger: The workflow can be triggered manually by clicking 'execute' or automatically via a schedule.
2. 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).
3. Connect Squarespace: Ensure your Squarespace API credentials are set up in the Query Orders node.
4. 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.
5. Execute: Trigger the workflow manually or wait for the scheduled time. The order data will be exported to your Google Sheet.