Step 2: Connect Google Sheets

Set up Google Sheets nodes to read the last cursor, append product data, and update the cursor tracker sheet.

1. Open Fetch Last Cursor and select the sheet named Curser and the document ID [YOUR_ID].
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Last Cursor.
3. In Append First Product Row, set documentId to [YOUR_ID] and sheetName to gid=0 (Sheet1).
4. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append First Product Row, Append Product Rows, and Update Cursor Sheet.
5. In Update Cursor Sheet, confirm operation is update and the tracker columns include tracker with cursor and endCursor as ={{ $json.data.products.pageInfo.endCursor }}.

Step 3: Connect Shopify GraphQL

Configure the Shopify GraphQL nodes to fetch initial and paginated product data.

1. Open Initial Shopify Fetch and set endpoint to https://test-store-collection.myshopify.com/admin/api/2024-01/graphql.json.
2. Set the query in Initial Shopify Fetch to the provided GraphQL with first: 1.
3. Credential Required: Connect your httpHeaderAuth credentials in Initial Shopify Fetch and Retrieve Shopify Items.
4. In Retrieve Shopify Items, confirm endpoint is https://test-store.myshopify.com/admin/api/2024-01/graphql.json and the query uses {{$json.batchsize}} and {{$json.endCursor}}.

Step 4: Set Up Cursor & Pagination Logic

Control pagination using the cursor, branch logic, and a delay between requests.

1. Connect Fetch Last Cursor to Branch on Cursor and keep the condition ={{ $json.endCursor }} with the empty operator.
2. Route the “empty” branch to Initial Shopify Fetch and the other branch to Merge Cursor Data.
3. In Merge Cursor Data, keep the provided JavaScript that merges outputs from Set Batch Limit, Fetch Last Cursor, and Initial Shopify Fetch.
4. Configure Assign Next Cursor to set endCursor as ={{ $('Retrieve Shopify Items').item.json.data.products.pageInfo.endCursor }} and =batchsize as ={{ $('Merge Cursor Data').item.json.batchsize }}.
5. Set Delay Interval to unit seconds and amount 10, then connect it to Assign Next Cursor to throttle pagination.
6. In Verify More Pages, keep the boolean condition ={{ $json.data.products.pageInfo.hasNextPage }} to branch to Delay Interval or finish at Idle Step.

Step 5: Configure Product Row Appends

Split Shopify results into individual items and append them to Google Sheets.

1. In Divide Results, keep the Python code that iterates through data.products.edges and outputs one product per item.
2. Ensure Retrieve Shopify Items outputs to both Divide Results and Validate Cursor Present in parallel.
3. In Append Product Rows, map columns using expressions like ={{ $json.data.product.title }}, ={{ $json.data.product.tags }}, and ={{ $json.data.product.variants.edges[0].node.price }}.
4. In Append First Product Row, map fields using the first edge: ={{ $json.data.products.edges[0].node.title }} and similar fields for tags, price, and description.
5. Route Validate Cursor Present to Update Cursor Sheet to store ={{ $json.data.products.pageInfo.endCursor }} after each fetch.

Step 6: Test and Activate Your Workflow

Run the workflow end-to-end, confirm Sheets updates, then activate it for scheduled syncing.

1. Manually execute Scheduled Run Trigger and confirm Set Batch Limit outputs a batchsize of 100.
2. Verify that Retrieve Shopify Items runs and that Retrieve Shopify Items outputs to Divide Results and Validate Cursor Present in parallel.
3. Check Google Sheets to confirm rows were added by Append First Product Row and Append Product Rows, and that Update Cursor Sheet wrote the latest cursor.
4. When successful, toggle the workflow Active to allow scheduled runs at the configured hour.