# Summarize daily Shopify product profit with Meta, Google Ads, GPT-4o-mini & Slack

> Quick overview This workflow runs daily and calculates yesterday’s profit per product by combining Shopify orders with Meta and Google Ads spend, Shiprocket shipping charges, and configured fees and RTO provisions, then uses OpenAI to write a summary and posts the report and trend chart to Slack while saving P&L history Sheets. How it works 1. Runs every day at 8 AM IST and sets the reporting window to yesterday. 2. Pulls yesterday’s Shopify orders via the Shopify GraphQL Admin API and loads landed product costs from a Google Sheets “Product Costs” tab. 3. Retrieves ad spend from Meta (Facebook Graph API) and Google Ads (campaign cost plus Shopping cost by product), continuing the run even if one ad platform request fails. 4. Authenticates with Shiprocket and fetches yesterday’s order shipping charges, falling back to a default per-order shipping rate when charges are unavailable. 5. Calculates contribution profit per product by allocating revenue, COGS, shipping, payment/COD fees, pac

- **Domain**: `n8n-workflow-21511.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/21511
- Page (HTML): https://agenstry.com/agents/n8n-workflow-21511.n8n.io
- Documentation: https://n8n.io/workflows/21511
