{"product_id":"n8n-workflow-google-sheets-sales-report-slides-w-claude","title":"n8n Workflow: Google Sheets Sales Report Slides w\/ Claude","description":"\u003ch3\u003eTurn your Google Sheets sales data into a branded Google Slides report—automatically, with n8n + Claude\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives a monthly sales report request, reads the relevant data from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, uses \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e to interpret the requested month and generate a short summary, then fills a copied \u003cstrong\u003eGoogle Slides\u003c\/strong\u003e template (including a chart sourced from Sheets). The result: a ready-to-share Slides link—no manual reporting.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives requests\u003c\/strong\u003e from either an \u003cstrong\u003en8n Form submission\u003c\/strong\u003e or a \u003cstrong\u003eGoogle Chat webhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates Google Chat senders\u003c\/strong\u003e against an allowlist, returning a help\/denial response when invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches and parses sales rows\u003c\/strong\u003e from a configured Google Sheets tab into normalized records (date, group, value, and an optional distinct key).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts the requested month with Anthropic Claude\u003c\/strong\u003e, then verifies the month is valid, not in the future, and actually has matching rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes reporting outputs\u003c\/strong\u003e including totals, month-over-month change (or month-to-date when applicable), counts, optional averages\/distinct counts, and top groups.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites a comparison table to a “Report” tab\u003c\/strong\u003e to drive a Google Sheets chart.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a 3-line Claude summary\u003c\/strong\u003e based on computed facts, with a safe fallback if any numbers don’t match the calculated dataset.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds the final Slides deck\u003c\/strong\u003e by copying a Google Slides template, replacing \u003ccode\u003e{{placeholders}}\u003c\/code\u003e, embedding the Sheets chart image at \u003ccode\u003e{{chart}}\u003c\/code\u003e, and returning the Slides link.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate monthly sales reporting for SaaS teams using n8n and Google Sheets data.\u003c\/li\u003e\n  \u003cli\u003eGenerate a consistent executive summary deck from a single request sent via Google Chat.\u003c\/li\u003e\n  \u003cli\u003eReduce manual slide updates by using a template + computed chart from the “Report” tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: reads source data, writes comparison results to a “Report” tab (chart source).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Slides\u003c\/strong\u003e: copies a template and replaces placeholders with computed values.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e: interprets the requested month and drafts a 3-line summary from verified facts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/logic\u003c\/strong\u003e: if, set, code, form, switch, webhook.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46254508179635,"sku":"N8N-21365","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/AFtuMuTOsRClIj2yvUshg_mE5BeV9C.png?v=1792573403","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-google-sheets-sales-report-slides-w-claude","provider":"N8N Commerce","version":"1.0","type":"link"}