Question

Stripe subscription invoices - How to be notified via email if the invoice has not been paid on time

  • 4 April 2022
  • 5 replies
  • 165 views

I have just set up some subscription via Stripe. 

Right now my customers don’t have payment methods on file, so I need to wait for them to pay their first invoice to make it automatic.

However, I would like to be notified if they received an invoice and didn’t pay it before the deadline. I have set up another zap that removes them from membership on the external platform if subscription is cancelled, but that happens 30 days after non payment.

Is there a way to trigger an email if the invoice has not been paid on time in Zapier? Which event should I use for this?

I’m not very technical, so if there is an easy way to set it up without having to use webhooks that would be great.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Userlevel 7
Badge +14

Hi @dariascrummastered 

Good question.

 

You may want to consider logging sent invoices and updating the paid invoices in an Airtable Base: https://zapier.com/apps/airtable/integrations

Airtable has Views

Views have Filters. (e.g. Date = Yesterday)

Views can be used to trigger Zaps.

 

Otherwise, you’ll likely have to explore using Stripe Webhooks to see if there is an event you can be notified about for your desired use case.

https://stripe.com/docs/webhooks

I already use Airtable and it’s definitely an awesome tool. So do you mean basically taking data from every new invoice generated since there is a New invoice event as trigger (or maybe Invoice updated?), and storing it in Airtable then using views to see if invoice is overdue?

Userlevel 7
Badge +14

@dariascrummastered 

Yes, that’s the idea.

You can try using the Stripe New Payment trigger to see if that covers paid invoices, to then find/update the Invoice record in Airtable.

 

 

Or you can use this Stripe Webhook event: Invoice Paid

 

I want it for unpaid invoices though. I am trying the invoice.updated right now. We’ll see how it works

Userlevel 7
Badge +14

@dariascrummastered 

You can use the Stripe Webhook Invoice Paid to find/update the Airtable Record, thus giving you a View of only unpaid invoices.