{"product_id":"n8n-workflow-on-demand-csv-report-via-google-sheets-gmail","title":"n8n Workflow: On-Demand CSV Report via Google Sheets \u0026 Gmail","description":"\u003ch3\u003eInstant on-demand CSV reports—request them once, get an emailed summary automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow delivers on-demand CSV reports by turning an \u003cstrong\u003en8n Form\u003c\/strong\u003e request into a \u003cstrong\u003eGoogle Sheets–powered\u003c\/strong\u003e HTML summary plus a \u003cstrong\u003eCSV attachment\u003c\/strong\u003e sent to your requester via \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\u003eCollects report requests\u003c\/strong\u003e from an \u003cstrong\u003en8n Form submission\u003c\/strong\u003e, including report type, start\/end dates, and the requester’s email address.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and maps inputs\u003c\/strong\u003e in a validation step by checking the date range and mapping the selected report type to the correct \u003cstrong\u003eGoogle Sheets tab\u003c\/strong\u003e and the configured date\/grouping\/sum columns (via the \u003cstrong\u003eREPORTS\u003c\/strong\u003e mapping).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads all rows\u003c\/strong\u003e from the selected tab using the \u003cstrong\u003eGoogle Sheets read\u003c\/strong\u003e step.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters, groups, and totals\u003c\/strong\u003e rows to the requested date range, then aggregates results by the configured grouping column and sums the configured numeric column.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates outputs\u003c\/strong\u003e when results exist: creates a \u003cstrong\u003eCSV\u003c\/strong\u003e from the aggregated data and builds an \u003cstrong\u003eHTML email\u003c\/strong\u003e including a preview table and totals.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends via Gmail\u003c\/strong\u003e to the requester with the CSV attached; if no rows match, it sends a plain-text \u003cstrong\u003e“no data”\u003c\/strong\u003e notice instead.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators generating recurring operational reports (date-range based) for internal teams.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers providing self-serve exports: users request a report and receive a CSV instantly by email.\u003c\/li\u003e\n  \u003cli\u003eTeams standardizing reporting so the same Google Sheets structure powers multiple report types.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tools used:\u003c\/strong\u003e if, code, gmail, sticky note, form trigger, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003en8n Form trigger\u003c\/strong\u003e → \u003cstrong\u003eGoogle Sheets read\u003c\/strong\u003e → \u003cstrong\u003eGmail send\u003c\/strong\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup highlights:\u003c\/strong\u003e add Google Sheets credentials, add Gmail credentials for both send steps, and update the \u003cstrong\u003eREPORTS mapping\u003c\/strong\u003e so each report type matches your sheet tab name and header column names exactly.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eGet started\u003c\/strong\u003e: activate the workflow and share the n8n Form production URL so teammates can submit report requests.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46010434715827,"sku":"N8N-19527","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/gEsBXP0HZ4-zt6InEXuNp_HhyI3tl0.png?v=1789290134","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-on-demand-csv-report-via-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}