Keep your product catalog in a simple Google Sheet that updates on its own. Each morning, product titles, tags, descriptions, and prices are pulled from Shopify and written into rows you can filter and share. Great for marketing teams that need fresh data for ads, SEO, or content planning without manual exports.

A daily schedule at 7 AM starts the run. The flow reads a batch size, checks a cursor saved in a Curser tab in Google Sheets, and uses Shopify GraphQL to fetch products with pagination. Results are split into single product items so each row writes cleanly to the sheet. The process appends product details, updates the end cursor, waits briefly, and continues until all pages are processed.

Setup needs a Shopify Admin API access token and a Google account with a sheet ready for two tabs, one for data and one named Curser. Expect large time savings and fewer copy paste errors. Teams can use the sheet for campaign planning, promo calendars, feed checks, and quick price or tag audits.

• Daily Schedule Trigger runs at 7 AM to keep data fresh
• Shopify GraphQL query pulls titles, tags, descriptions, and prices
• BatchSize control defaults to 100 and can increase up to 250
• Cursor tracking in a Curser sheet to resume where it left off
• Split output converts batches into one product per row
• Google Sheets append writes clean product rows for easy filtering
• If and Wait logic handles next pages and pacing between calls
• End cursor is updated after each page to support incremental sync

• Reduce manual product export from hours to minutes
• Automate 100 percent of daily catalog updates
• Improve data accuracy by removing copy paste errors
• Handle large catalogs with cursor based pagination
• Connect Shopify and Google Sheets with no manual steps

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Shopify and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. In Shopify Admin, create an Admin API access token with read products scope. Go to Apps > Develop apps > Create app > Configure Admin API scopes > grant read products > Install app > copy the access token.
4. In n8n, double click the Shopify GraphQL nodes and in the 'Credential to connect with' dropdown click 'Create new credential'. Choose HTTP Header Auth, add a header named X-Shopify-Access-Token with your token, then save.
5. In n8n, open the Google Sheets nodes and create a new Google Sheets OAuth2 credential. Click Connect, sign in to your Google account, and allow read and write access.
6. Prepare your Google Sheet with two tabs: one for product data (for example Sheet1) and another named Curser with columns tracker and endCursor. Enter one row in Curser with tracker set to cursor and leave endCursor blank for the first run.
7. In each Google Sheets node, select your document and choose the correct tab. Confirm the product columns map to title, tags, description, and price.
8. Open the BatchSize Set node and adjust the number if needed. Shopify allows up to 250 per page.
9. Open the Schedule Trigger and set the time that fits your team, or keep 7 AM.
10. Run a manual test once. Check Sheet1 for new rows and confirm the Curser tab now shows an endCursor value.
11. If your store has many products, watch the execution. The flow will loop pages using the Wait and If nodes until done.
12. Troubleshoot: If you see 401 or 403 from Shopify, verify the token and read products scope. If Sheets fails to write, confirm the selected document and that your Google credential has edit access.
13. When everything looks good, switch the workflow to Active so it runs on schedule.