NetSuite and Stripe: Overdue Invoice Reminder Template
A scheduled Spojit workflow that finds overdue NetSuite invoices each day, matches each one to its Stripe customer, and emails a polite payment reminder with the outstanding balance and a pay link.
What It Builds
A Schedule trigger runs the workflow once a day. A NetSuite Connector node pulls invoices that are past their due date, a Loop walks each one, and a Stripe Connector node looks up the matching customer and pay link. A Condition flags the most overdue accounts for escalation, then a Send Email node delivers a reminder with the balance and due date.
The Prompt
Paste this into Miraxa and it builds the workflow, connecting the tools for you:
Every morning at 9am, find all overdue invoices in NetSuite, match each invoice to its Stripe customer to get their email and a payment link, and send a polite reminder email with the customer name, invoice number, outstanding balance, due date, and the pay link. For invoices more than 30 days overdue, mark the message as a final notice and copy our accounts team.Connectors Used
- Schedule trigger - runs the workflow once a day at your chosen time and timezone.
- NetSuite - lists overdue invoices and their balances and due dates.
- Stripe - matches each invoice to its customer and supplies a hosted pay link.
- Send Email - delivers the reminder via Spojit's built-in mail service.
Customize It
Adjust the run time in the prompt, change the 30-day escalation threshold, or add tiers (for example a gentle nudge at 7 days). Swap the copied recipient, tweak the email tone, or add fields like the original invoice amount. To send from your own domain, ask Miraxa to use a Resend or SMTP connection instead.
Tips
- Give the NetSuite and Stripe connections read access to invoices and customers so lookups never stall mid-run.
- Use Direct mode on the NetSuite and Stripe nodes for predictable, no-AI-cost calls; reserve Agent mode for fuzzy customer matching.
- Send-from addresses must be on your email allowlist before the first run.