I'm trying to set up an automation that creates a new record in Airtable when an invoice is paid in Wave. I understand that Zapier provides a "New Invoice" trigger, but I'm having trouble figuring out how to trigger an automation when the payment is made, especially in cases where the invoice is created but paid at a later date.
Here’s my challenge:
- Sometimes the invoice is created and paid at the same time (like with recurring invoices).
- Other times, the invoice is created but paid days or weeks later.
How can I account for cases where the invoice is created first and then paid at a later date? How can I trigger my automation when the payment occurs, regardless of whether the invoice was paid immediately or after a delay?
Any advice on how to set this up (or workarounds if necessary) would be greatly appreciated!