Description
Description This workflow automates the process of retrieving Stripe invoices, validating API responses, generating payment receipts, sending them via email, storing PDFs in Google Drive, and appending details to a Google Sheet ledger. It also includes an error logging system to capture and record workflow issues, ensuring financial operations are both automated and reliable. What This Template Does (Step-by-Step) 📋 Manual Trigger – Start the workflow manually by clicking Execute workflow. 🔗 Fetch Invoices – Authenticates with Stripe and retrieves the 5 most recent invoices (includes customer info, amounts, statuses, and invoice URLs). ✅ Check API Response – Ensures the Stripe API response contains a valid data[] array. If not, errors are logged. 📂 Expand List – Splits Stripe’s bundled invoice list into individual invoice records for independent processing. 💳 IF (Paid?) – Routes invoices based on payment status; only paid invoices move forward. 📧 IF (Already Receipted?) – Skips invoices where a receipt has already been generated (receipt_sent = true). 📑 Download File – Downloads the hosted invoice PDF from Stripe for use in emails and archiving. ✉️ Send Receipt Email – Emails the customer a payment receipt with the PDF attached, using invoice details (number, amount, customer name). ☁️ Upload Invoice PDF – Uploads the invoice PDF to a specific Google Drive folder, named by invoice number. 📊 Append to Ledger – Updates a Google Sheet with invoice metadata (date, invoice number, Drive file ID, link, size). ⚠️ Error Logging – Logs workflow issues (failed API calls, missing data, etc.) into a dedicated error tracking sheet. Prerequisites Stripe API key (with invoice read permissions) Google Drive (destination folder for invoices) Google Sheets with: Receipts Ledger Sheet Error Logging Sheet Gmail OAuth2 account for sending receipts Key Benefits ✅ Automates customer receipt delivery with attached PDFs ✅ Builds a permanent ledger in Google Sheets for finance ✅ Archives invoices in Google Drive for easy retrieval ✅ Prevents duplicates by checking receipt_sent metadata ✅ Includes error logging for smooth monitoring and debugging Perfect For Finance/accounting teams needing automated receipt handling SaaS businesses managing recurring Stripe invoices Operations teams requiring error-proof automation Any business needing audit-ready receipts + logs. An n8n automation workflow template by Rahul Joshi.
Rahul Joshi
web
free
Others in the same category, ranked by how often they are opened.
