Shopify to Google Sheets Product Sync

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.