Phoenix - Your AI AssistantAuto-sync Shopify inventory and sales to Google Sheets
Delivery in
3 days
- Views 4
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
What you get:
Orders and inventory synced into a clean, organised Google Sheet
Columns for SKU, variant, location, units sold and stock on hand
A summary tab with sales by day and best sellers
Automatic refresh on a schedule (for example every 15 to 60 minutes)
A short how-to so you can manage it yourself
No monthly tool fees: I build the sync with Google Apps Script, which is built into Google Sheets. You don't need to pay for Zapier, Make or a connector app. If you'd rather use one of those tools, I can set that up instead, and they charge their own fee.
How it works: You create a read-only app in your Shopify account (I'll guide you step by step), and I connect it to your Sheet. I only pull order and stock data, never your Shopify login. The connection may need a small update if Shopify changes its API rules.
Best for stores up to about 500 SKUs. For bigger catalogues, message me first.
My background is in business operations, inventory management and sales tracking, so the sheet is built for how sellers actually work.
Orders and inventory synced into a clean, organised Google Sheet
Columns for SKU, variant, location, units sold and stock on hand
A summary tab with sales by day and best sellers
Automatic refresh on a schedule (for example every 15 to 60 minutes)
A short how-to so you can manage it yourself
No monthly tool fees: I build the sync with Google Apps Script, which is built into Google Sheets. You don't need to pay for Zapier, Make or a connector app. If you'd rather use one of those tools, I can set that up instead, and they charge their own fee.
How it works: You create a read-only app in your Shopify account (I'll guide you step by step), and I connect it to your Sheet. I only pull order and stock data, never your Shopify login. The connection may need a small update if Shopify changes its API rules.
Best for stores up to about 500 SKUs. For bigger catalogues, message me first.
My background is in business operations, inventory management and sales tracking, so the sheet is built for how sellers actually work.
What the Freelancer needs to start the work
To get started, I need:
1. Your Shopify store URL (yourstore.myshopify.com).
2. A read-only connection to your store. Either add me as a staff or collaborator user with permission to manage apps, or I'll guide you step by step through creating the app yourself. Please never send me your Shopify login or password.
3. A blank Google Sheet shared with me as an editor, or your Google account email so I can create one and share it with you.
4. What you want to see: orders, stock levels, best sellers, and any extra columns you need.
5. Roughly how many products (SKUs), stores and stock locations you have.
6. How often you'd like the sheet to refresh (for example every 15 minutes or hourly).