{"product_id":"send-monthly-stripe-invoice-csv-via-gmail-n8n-workflow","title":"Send Monthly Stripe Invoice CSV via Gmail (n8n Workflow)","description":"\u003ch3\u003eAutomatically Email a Monthly Stripe Invoice CSV via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow exports all \u003cstrong\u003epaid Stripe invoices from the previous month\u003c\/strong\u003e, converts them into a structured \u003cstrong\u003eCSV report\u003c\/strong\u003e, and \u003cstrong\u003eemails the CSV through Gmail\u003c\/strong\u003e—fully automated on a monthly schedule (or runnable manually anytime).\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules monthly:\u003c\/strong\u003e runs on the \u003cstrong\u003e1st day of every month at 07:00\u003c\/strong\u003e (or you can execute it manually).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds the reporting window:\u003c\/strong\u003e calculates the previous month’s start and end timestamps and generates a monthly filename like \u003ccode\u003estripe_YYYY-MM.csv\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches Stripe invoices:\u003c\/strong\u003e calls the \u003cstrong\u003eStripe Invoices API\u003c\/strong\u003e to retrieve all invoices marked \u003cstrong\u003epaid\u003c\/strong\u003e within that date range, with \u003cstrong\u003eautomatic pagination\u003c\/strong\u003e to handle all results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats invoice data for reporting:\u003c\/strong\u003e flattens the Stripe response into CSV-ready rows, including invoice, customer, address, VAT\/tax, and payment fields, while converting amounts from \u003cstrong\u003ecents to euros\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates and emails the file:\u003c\/strong\u003e generates the CSV with a header row and sends it via \u003cstrong\u003eGmail\u003c\/strong\u003e as an email attachment.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators who need a consistent monthly invoice export for accounting and reconciliation.\u003c\/li\u003e\n  \u003cli\u003eFinance teams that want a ready-to-send CSV report of \u003cem\u003epaid\u003c\/em\u003e Stripe invoices without manual downloads.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers setting up reliable Stripe reporting using n8n workflows and scheduled email delivery.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ integrations:\u003c\/strong\u003e \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003eno op\u003c\/em\u003e, \u003cem\u003ehttp request\u003c\/em\u003e, \u003cem\u003econvert to file\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, plus a \u003cem\u003esticky note\u003c\/em\u003e for workflow guidance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStripe access:\u003c\/strong\u003e uses \u003cstrong\u003eHTTP Bearer Auth\u003c\/strong\u003e with a Stripe API token that has permission to read invoices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail delivery:\u003c\/strong\u003e configure \u003cstrong\u003eGmail OAuth2\u003c\/strong\u003e credentials and set recipient email, subject, and message in the Gmail step.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003eSet up your Stripe filters and CSV columns to match your reporting needs, then let n8n send your monthly Stripe invoice CSV automatically.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46190246494387,"sku":"N8N-20613","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/mHQWlxCyDBwGQlqXYtdMR_i70r8KFx.png?v=1791451247","url":"https:\/\/buyflowscripts.com\/products\/send-monthly-stripe-invoice-csv-via-gmail-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}