gohar ayub - Business Workflow Automation | ContraWork by gohar ayub
gohar ayub

gohar ayub

Data analyst

New to Contra

gohar is ready for their next project!

Followed by Salman A and GALLERY L

Islamabad, Pakistan

WorkPostsServicesAbout

Islamabad, Pakistan

Cover image for Automated Shopify P&L in Google
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
Cover image for I automate manual reporting and
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
Cover image for Google Forms Data Automation |
Google Forms Data Automation | Sheets, Validation & Reporting
1
89
Cover image for Google Sheets Finance Dashboard | Financial Reporting Automa...
Google Sheets Finance Dashboard | Financial Reporting Automation
0
35