Shopify to Google - Product & Inventory Master

Technical Specifications

Sync Frequency: Every 30 minutes (customizable)

Data Sources:

• Streamline Connector /products/search endpoint (product catalog)
• Streamline Connector /products/inventory endpoint (multi-location inventory)
• Streamline Connector /api/order-data endpoint (sales history for velocity)

Update Capabilities:

• Product pricing (price, compare-at price)
• Inventory adjustments (all locations)
• Product status (active, archived)
• Manual sync trigger available

Calculations Performed:

• Velocity score (30-day average daily sales)
• Stock coverage days (inventory / velocity)
• Reorder point (7 days of average sales)
• Reorder quantity (30 days supply)
• Low stock detection (< 14 days coverage OR velocity > 1 and stock < 30)

Data Volume:

• Supports unlimited products and variants
• Tracks up to 250 products per sync cycle (configurable)
• Analyzes 90 days of order history
• Handles unlimited locations

Requirements

• n8n instance (self-hosted or n8n Cloud)
• Streamline Connector account with active Shopify connection
• Google Sheets with OAuth2 credentials connected to n8n
• Shopify Store (any plan)

Get Started

1. Log into your Streamline Connector dashboard
2. Navigate to Templates > Product & Inventory Management
3. Download the n8n workflow (Add your Shop ID Details to the node)
4. Import into your n8n instance
5. Create your Google Sheets using our template
6. Connect your Google credentials
7. Test with the manual trigger
8. Activate scheduled sync

Time to value: 5 minutes from download to first sync

Support & Documentation

• Full setup guide with screenshots
• Video walkthrough showing configuration and usage
• Column reference guide explaining every field
• Update command syntax examples
• Troubleshooting common issues
• Best practices for team workflows
• Community support in Streamline Connector forums

Frequently Asked Questions

Q: Does this work with large catalogs? A: Yes. The workflow handles thousands of variants. For stores with 10,000+ SKUs, we recommend adjusting the sync frequency or batching products.

Q: Can I customize which fields sync? A: Absolutely. The workflow is fully editable. Add custom fields, change calculations, or modify sync logic to match your business.

Q: What happens if I make a mistake in Google Sheets? A: Changes only push to Shopify when you add specific commands to the notes fields. Review before the next sync cycle. You can also disable automatic syncing and use manual triggers only.

Q: Can multiple team members edit the sheet? A: Yes! Google Sheets supports real-time collaboration. Multiple users can view and edit simultaneously. Use Sheet permissions to control who can make changes.

Q: Does this affect my Shopify API limits? A: Streamline Connector handles rate limiting automatically. The workflow batches requests and respects API quotas.

Q: Can I add custom calculations? A: Yes! Add your own formulas in Google Sheets for margin analysis, ABC classification, seasonal trends, or any other metrics you need.

Q: What about product images? A: Image URLs are included in the Products tab. You can view images directly in Google Sheets or reference them in your own reports.

Q: Is my data secure? A: Your data flows directly between your n8n instance, Google Sheets, and Shopify via Streamline Connector. Nothing is stored on third-party servers. All connections use OAuth2 and API key authentication.