LOW / CODEBlueprints
finance

Auto-Generate Invoices from Stripe Events

Automatically generate and send invoices when Stripe payment events occur. Logs each invoice to Google Sheets for bookkeeping and emails a PDF copy to the customer via Gmail.

Intermediate~25 minn8nMake.com 566 downloads 1050 views

Setup Instructions

1. Create a Stripe webhook endpoint that listens for `invoice.payment_succeeded` events. 2. In your automation platform, add a Stripe trigger node and paste your webhook signing secret. 3. Add a Set/Function node to extract invoice ID, customer email, amount, and line items from the event payload. 4. Connect a Google Sheets node — create a spreadsheet named "Stripe Invoices" with columns: Date, Invoice ID, Customer Email, Amount, Status. 5. Add a Router/IF node to check if the invoice amount exceeds your notification threshold (e.g., $100). 6. For invoices above the threshold, add a Gmail node that sends the Stripe-hosted invoice PDF link to the customer email. 7. Add a final Google Sheets update node to mark the row status as "Sent". 8. Test with a Stripe test-mode payment and verify the sheet populates and the email arrives.
Troubleshooting
**Webhook events not arriving:** Verify the webhook URL is publicly accessible and the signing secret matches. Check Stripe Dashboard > Developers > Webhooks for failed delivery attempts. **Google Sheets authentication expired:** Re-authorize the Google Sheets connection in your automation platform. OAuth tokens expire — use a service account for long-running automations. **Gmail sending limits hit:** Gmail has a daily send limit of 500 emails (2,000 for Workspace). If you exceed this, queue emails or switch to a transactional email service like SendGrid. **Duplicate invoices logged:** Add a deduplication check — query the sheet for the Stripe Invoice ID before inserting. Stripe may retry webhook delivery on timeouts.

Need a custom version?

We can build a tailored automation workflow for your specific needs.

New blueprints weekly

Get notified when we publish new automation workflows.