{"product_id":"n8n-daily-stock-sales-report-via-google-sheets-gmail","title":"n8n Daily Stock \u0026 Sales Report via Google Sheets + Gmail","description":"\u003ch3\u003eGet an automatic daily stock update and profit recap—pulled from Google Sheets and emailed via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every day at \u003cstrong\u003e6AM\u003c\/strong\u003e to calculate yesterday’s sales and incoming goods, update your \u003cstrong\u003eStock of goods\u003c\/strong\u003e in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and email a \u003cstrong\u003edaily profit summary\u003c\/strong\u003e through \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e Executes daily at \u003cstrong\u003e6AM\u003c\/strong\u003e using an n8n schedule.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads multiple Google Sheets tabs:\u003c\/strong\u003e Pulls data from \u003cem\u003eNote\u003c\/em\u003e, \u003cem\u003eSales Details\u003c\/em\u003e, \u003cem\u003eIncoming Goods\u003c\/em\u003e, and \u003cem\u003eStock of goods\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters to yesterday:\u003c\/strong\u003e Limits rows to \u003cstrong\u003eyesterday\u003c\/strong\u003e (based on the \u003cstrong\u003eTanggal\u003c\/strong\u003e field in \u003cem\u003edd\/MM\/yyyy\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSummarizes key metrics:\u003c\/strong\u003e Computes sales quantity, incoming quantity, total sales paid, and total restock spend.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eJoins by SKU:\u003c\/strong\u003e Merges summarized sales and incoming quantities with your inventory list using \u003cstrong\u003eSKU\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates stock and status:\u003c\/strong\u003e Calculates \u003cem\u003enew stock on hand\u003c\/em\u003e and updates stock status to \u003cstrong\u003eAman\u003c\/strong\u003e, \u003cstrong\u003ePerlu Restock\u003c\/strong\u003e, or \u003cstrong\u003eHabis\u003c\/strong\u003e in the \u003cstrong\u003eStock of goods\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a financial recap via Gmail:\u003c\/strong\u003e Formats gross profit, restock expense, and net profit, then emails it to your configured recipient.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators or small teams who track sales and inventory in Google Sheets and need daily reporting without manual work.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up an n8n workflow to reconcile stock from incoming goods plus sales by SKU.\u003c\/li\u003e\n  \u003cli\u003eBusinesses that want a consistent daily email with net profit and restock spend for better inventory decisions.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e \u003cem\u003eGoogle Sheets\u003c\/em\u003e (OAuth), \u003cem\u003eGmail\u003c\/em\u003e (OAuth2), plus n8n nodes such as \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003efilter\u003c\/strong\u003e, \u003cstrong\u003esummarize\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, and \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements:\u003c\/strong\u003e Provide Google Sheets access to the tabs and ensure required fields exist (e.g., \u003cstrong\u003eTanggal\u003c\/strong\u003e, \u003cstrong\u003eSKU\u003c\/strong\u003e, \u003cstrong\u003eQty\u003c\/strong\u003e, \u003cstrong\u003eQty Masuk\u003c\/strong\u003e, \u003cstrong\u003eTotal Bayar\u003c\/strong\u003e, \u003cstrong\u003eTotal\u003c\/strong\u003e, \u003cstrong\u003eStok Saat Ini\u003c\/strong\u003e, \u003cstrong\u003eStok Minimum\u003c\/strong\u003e, \u003cstrong\u003eTotal Terjual\u003c\/strong\u003e, \u003cstrong\u003eTotal Barang Masuk\u003c\/strong\u003e, and \u003cstrong\u003erow_number\u003c\/strong\u003e for inventory updates).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45758713790643,"sku":"N8N-17804","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gy4pJ9Zdi21at7RvHt0qL_3JptQgnl.png?v=1785834028","url":"https:\/\/buyflowscripts.com\/products\/n8n-daily-stock-sales-report-via-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}