Fetch All Shopify Orders (Handles 250 Limit Loop)

This n8n workflow is designed to efficiently retrieve all orders from a Shopify store, overcoming the typical API limit of 250 orders per request by implementing a looping mechanism. It processes the fetched data, transforms it, and then stores the relevant order information in a Google Sheet.

What it does

1. Triggers on a Schedule: The workflow starts automatically at predefined intervals (e.g., daily, hourly).
2. Fetches Shopify Orders: It initiates a GraphQL query to the Shopify API to fetch orders. It's configured to handle pagination and retrieve orders in batches, likely using a cursor-based approach to bypass the 250-order limit.
3. Processes Order Data: A Code node is used to process the raw data received from Shopify. This step likely extracts specific fields, transforms data types, or restructures the order objects for easier storage.
4. Filters Data: An If node conditionally routes the processed data. This could be used to filter orders based on certain criteria (e.g., order status, date, specific products).
5. Prepares Data for Google Sheets: An "Edit Fields (Set)" node (Set node) is used to format the order data into a structure suitable for appending to a Google Sheet. This might involve renaming fields or creating new ones.
6. Appends to Google Sheet: Finally, the prepared order data is written as new rows to a specified Google Sheet, providing a centralized and accessible record of all Shopify orders.

Prerequisites/Requirements

• n8n Instance: A running n8n instance to import and execute the workflow.
• Shopify Account: Access to a Shopify store with API credentials (e.g., a private app or custom app with appropriate read access for orders) to use with the GraphQL node.
• Google Account: A Google account with access to Google Sheets.
• Google Sheets Credential: An n8n credential configured for Google Sheets to allow the workflow to write data.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Shopify GraphQL credential (if not already configured). This typically involves providing your Shopify store URL and an Access Token.
   • Set up your Google Sheets credential (if not already configured). This usually involves OAuth2 authentication.
3. Customize Nodes:
   • Schedule Trigger: Adjust the schedule to your desired frequency for fetching orders.
   • GraphQL Node: Verify the GraphQL query and variables to ensure it fetches the desired order fields and correctly handles pagination. You might need to adjust the limit and after (cursor) variables.
   • Code Node: Review and modify the JavaScript code within the "Code" node to match your specific data processing and transformation needs for Shopify order data.
   • If Node: Adjust the conditions in the "If" node if you need to filter orders based on specific criteria.
   • Edit Fields (Set) Node: Configure this node to map the processed Shopify order fields to the column headers in your Google Sheet.
   • Google Sheets Node: Specify the Spreadsheet ID and Sheet Name where you want the order data to be written. Ensure the sheet has appropriate headers matching the fields output by the "Edit Fields (Set)" node.
4. Activate the Workflow: Once configured, activate the workflow to enable it to run on its schedule.