gohar ayub - Business Workflow Automation | Contra
Work by gohar ayub
Sign Up
Post a job
Sign Up
Log In
gohar ayub
Data analyst
Message
Follow
New to Contra
gohar is ready for their next project!
Followed by
Salman A
and
GALLERY L
Islamabad, Pakistan
Work
Posts
Services
About
Islamabad, Pakistan
2
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
2
40
2
I automate manual reporting and build dashboards that make data easier to understand. Less copy-pasting, fewer repetitive tasks, and more time to focus on the actual work. If you’re doing the same report every week, it can probably be automated.
2
120
1
Google Forms Data Automation | Sheets, Validation & Reporting
1
89
0
Google Sheets Finance Dashboard | Financial Reporting Automation
0
35
Challenges
Lovable Challenge
Rive Halloween Challenge
The invideo Editor Challenge
Challenges
Lovable Challenge
Rive Halloween Challenge
The invideo Editor Challenge