Platform: n8n · Made by OQuark
Overdue payment reminders with Pix
Reads charges from a sheet and emails reminders in 3 stages (1, 7 and 15 days late), with a Pix copy-and-paste code built by the workflow itself, for the exact amount.
The Pix code follows the Central Bank's BR Code spec and uses your own key, no intermediary, no fees; the charge id becomes the txid for reconciliation. The AI only writes the text, in each stage's tone and within Brazil's Consumer Defense Code (no threats, no shaming, no credit-bureau talk); amount, due date and payment code are built outside the AI. Each stage is sent once, and paid, negotiated or opted-out rows are skipped.
What's in the package
- n8n workflow (workflow.n8n.json) with a reminder schedule, Pix copy-and-paste generator and fallback text if the AI fails
- Prompt in PT and EN with consumer-law rules and the JSON response schema
- Sample sheet rows and the generated reminder
- README with step-by-step setup, a R$0.01 test and reconciliation tips
Files:
- README.md
- prompt.md
- workflow.n8n.json
- examples/input.json
- examples/output.json
What you need
- n8n (Cloud or self-hosted, version 1.80 or newer)
- A business Pix key
- Google Sheet with the charges (template in the README) and a Gmail account with an OAuth credential
- Anthropic or OpenAI API key
Works with
See the Agents and automation rankingTemplates are OQuark products and are kept apart from the ranking: selling a template never changes a tool's position, and the tools named here did not pay to appear.