Workflow Description:
This workflow automates the synchronization of product data from a Shopify store to a Google Sheets document, ensuring seamless management and tracking. It retrieves product details such as title, tags, description, and price from Shopify via GraphQL queries. The outcome is a comprehensive list of products neatly organized in Google Sheets for easy access and analysis.
Key Features:
- Automated: Runs on a schedule you define (e.g., daily, hourly) to keep your product data fresh.
- Complete Product Details: Retrieves titles, descriptions, variants, images, inventory, and more.
- Cursor-Based Pagination: Efficiently handles large product sets by navigating pages without starting from scratch.
- Google Sheets Integration: Writes product data directly to your designated sheets.
Set up Instructions:
-
Set up GraphQL node with Header Authentication for Shopify:
-
Create Google Sheet Credentials: Follow this guide to set up your Google Sheet credentials for n8n: https://docs.n8n.io/integrations/builtin/credentials/google/
-
Choose your Google Sheet: Select the sheet where you want product information written. For the setup, we need a document with two sheets: 1. for storing Shopify data 2. for storing cursor details.
Google sheet template :
https://docs.google.com/spreadsheets/d/1I6JnP8ugqmMD5ktJlNB84J1MlSkoCHhAEuCofSa3OSM -
Schedule and run: Decide how often you want the data refreshed (daily, hourly, etc.) and let n8n do its magic!