Automate Payment Receipts: Email, Archive, and Track with Stripe and Google Workspace

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