I will apps script automate ecommerce reporting in google sheets with shopify meta api
About this Gig
Stop copying numbers between Shopify, Meta Ads Manager and spreadsheets. I'll build a fully automated Google Sheets system that pulls your store and ad data together, so you see real performance at a glance.
What I'll build for you:
- Meta Ads import at campaign, ad set and ad level
- Shopify orders, products and revenue sync
- Combined reports: ROAS, CPA, spend vs sales and profit
- Breakdowns per store, market and product
- Scheduled auto refresh with error handling and logging
- Rule based ad automation: pause weak ads, adjust budgets
- Manual approval step before any change goes live
Why work with me:
Everything runs inside Google Sheets with Google Apps Script. No extra software, no monthly tool fees, and your data stays in your own account. I handle API rate limits, retries and logging so the system keeps running reliably.
What I need from you:
Access to your Google Sheet, a Shopify custom app token for each store, and a Meta System User token from your Business Manager. Don't worry if you're unsure how to set these up, I'll guide you step by step.
Multiple stores or ad accounts? Message me before ordering and I'll send a custom offer that fits your setup.
Technology:
Excel
•
Google Sheets
•
Java
•
Python
•
Zapier
