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
Back to feedPost
Created an Excel IF Function project using conditional formulas to classify sales as High or Low based on sales amount.
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
"Working on standardizing Excel formatting and running basic data checks to keep spreadsheets clear and presentation-ready."
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
