The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Related posts
I designed and developed this Shopify clothing store with a clean and modern look. I customized the store, added and organized the products, created product pages and collections, and made sure the website works well on both mobile and desktop.
Automated Shopify P&L in Google Sheets
Built a reporting workflow that brings Shopify sales data, Meta Ads spend, and COGS into one automated Google Sheets P&L.
The workflow:
🛍️ Shopify API → Sales, orders, refunds & product data
📣 Meta Ads API → Advertising spend & campaign data
📁 Google Drive → COGS file uploads
⚙️ Google Sheets + Apps Script → Data cleaning, calculations & reporting
The final P&L can track:
• Revenue
• COGS
• Gross Profit & Margin
• Ad Spend
• Net Profit
• Product-level profitability
The goal is simple: reduce manual reporting and give the business a clearer view of actual profitability.
Built by Skillytics Consulting for practical ecommerce analytics and automation.
#Shopify #GoogleSheets #AppsScript #EcommerceAnalytics #PAndL #BusinessAutomation #DataAnalytics
