Back to Use Cases
Automate payment receipts: Email, archive, and track with Stripe and Google Workspace
invoice-processingfinance-opsstripegmailgoogle-drivegoogle-sheetsaudit-trail•
Fetch invoices
Validate response
Keep paid invoices
Download invoice PDF
Send receipt email
Upload PDF
Log errors
Append ledger row
Overview
This workflow automates receipt delivery and audit-ready storage for Stripe billing. It ensures customers receive receipts and your team has a searchable ledger.
Product Specs
- Retrieves recent Stripe invoices
- Filters to paid invoices and skips already processed invoices
- Downloads Stripe-hosted invoice PDFs
- Emails receipts through Gmail with PDF attachments
- Uploads PDFs to Google Drive and appends metadata to Google Sheets
- Logs errors to a dedicated Google Sheet
Pipeline Description
The workflow fetches invoices from Stripe, validates the response, expands invoices for processing, filters to paid items, downloads PDFs, emails the customer via Gmail, stores the PDF in Drive, writes ledger rows in Sheets, and records failures in an error sheet.