This workflow automates the synchronization of product data from a Shopify store to Google Sheets. It retrieves product details like title, tags, description, and price via GraphQL queries and appends them into a Google Sheet. With built-in batching, cursor tracking, and scheduling, it ensures incremental updates and prevents duplicate syncing. Ideal for keeping Shopify product data organized, analyzable, and always up to date in Google Sheets.
Features:
- 🔄 Automated Sync – Runs daily at 7 AM (can be customized).
- 📦 Batch Fetching – Retrieves up to 250 products per run for efficiency.
- 🧭 Cursor Tracking – Continues from the last synced product, avoiding re-fetching duplicates.
- 📊 Google Sheets Integration – Stores product title, description, tags, and price neatly in your sheet.
- ⚡ Incremental Updates – Ensures seamless syncing without overwriting existing data.
- 🛠️ Customizable Queries – GraphQL query can be extended to fetch additional product attributes.
- ✅ Error Handling – Includes checks for missing cursor data and smooth fallback logic.
