Most small businesses don't have a cash problem so much as a chasing problem. The work is done, the invoice went out, and the money sits in someone else's account because nobody has had the hour it takes to write five polite reminders. I'd build this agent for any business that sends invoices and dreads that hour: a bakery supplying cafés, a bookkeeper, a studio, a trades business on 14-day terms.
This is the first plug-and-play agent from the HackrLife Agent Lab. Every weekday at 8am it reads your invoice sheet, picks out the unpaid invoices that are overdue, and writes a reminder for each one in a tone that suits the delay. Each reminder waits in your Gmail drafts. You read it, and you press send. The agent itself never sends anything.

The Invoice Chaser in the Agent Lab, with a live version you can try on sample invoices.
What it does, and what it refuses to do
The rules are deliberately simple, because a reminder that goes out at the wrong time or with the wrong number costs more goodwill than it recovers money.
Friendly from 3 days late: it assumes the invoice slipped through and asks when it will be paid.
Firm from 14 days late: it says the invoice is overdue and asks for payment this week, or a reply if something is wrong with it.
Final notice from 30 days late: it says clearly that this is the last reminder and asks for payment within 7 days, without threats of debt collectors, fees or legal action.
Just as important is what it won't do. It never sends an email. It never changes an amount, a due date or a status. It never chases the same invoice twice within 7 days, and after one final notice it stops and leaves a note for the owner, because what happens next is a business decision rather than a writing job. If a row has no client email, it doesn't guess; it writes a note asking you to add one.
On time saved: if writing and checking a reminder takes about 10 minutes, five overdue invoices a week is close to an hour, and reading five drafts takes perhaps ten. That is my estimate rather than a measured result, but it is the right order of magnitude for a small business.
What you need
n8n, either the free self-hosted Community Edition or n8n Cloud, whose Starter plan is $20 a month billed annually with 2,500 executions (as of 21 November 2026). This agent uses about 22 executions a month, one per weekday.
A Google Sheet of your invoices, and a Gmail account for the drafts.
An Anthropic API key for Claude Sonnet, which writes the reminders. Sonnet is $3 per million input tokens and $15 per million output tokens (as of 21 November 2026). A reminder uses roughly 500 input and 250 output tokens, so by my estimate each one costs well under a cent. Any other chat model in n8n works too.
The flow at a glance

Illustration of the n8n canvas, drawn from the built and tested workflow.
Six steps do the work. A schedule starts the run, the sheet is read, a short piece of code decides which invoices to chase and in what tone, Claude writes the reminder, a second check makes sure the invoice number and amount survived the writing untouched, and Gmail saves the draft before the sheet records the date. A side branch handles the invoices the agent won't chase, by leaving a note for the owner in the sheet.
The invoice sheet
The agent reads one row per invoice, with these column headers in row 1, spelled exactly like this:
invoice_no,client,business,email,amount,due_date,statuslast_chased,last_tone,agent_note: leave these empty; the agent fills them in.
To test it, use the eight fictional invoices from a made-up wholesale bakery in the repo. They come as a CSV you can import into Google Sheets, with a table of what the agent should do with each.

The sample invoices on GitHub. Every name, business and amount is invented, and every email uses example.com.
Set it up in 10 minutes
Import the workflow. Copy the JSON at the end of this post, open a new workflow in n8n and paste it onto the canvas (or use Import from File).
Connect three accounts. Open each Google Sheets node and choose your Google Sheets account, open the Gmail node and choose your Gmail account, and open the Claude Sonnet node and add your Anthropic credential.
Point it at your sheet. In all three Google Sheets nodes, replace
YOUR_SHEET_IDwith your sheet's ID (the long string in its URL between/d/and/edit) and set the tab name.Make it yours. At the top of the "Decide which invoices to chase" step, change
SENDER,SIGN_OFFandZONEto your business name, your sign-off and your time zone.Test, then switch on. Press Execute workflow, read the drafts in Gmail, and only then activate it.
Build it step by step
1. Every weekday at 8am
A Schedule Trigger starts the run each morning from Monday to Friday.
Node: Schedule Trigger
Rule: Cron expression
0 0 8 * * 1-5(second, minute, hour, day of month, month, weekday)The time follows your n8n instance's time zone, so check it under Settings.
2. Read invoice sheet
A Google Sheets node reads every row of the invoice tab and passes each one on as an item.
Resource: Sheet · Operation: Read
Document: by ID,
YOUR_SHEET_ID· Sheet: your tab nameCredential: your Google Sheets account
3. Decide which invoices to chase
This Code node holds all the rules, which is why the model never has to make a decision about money or timing. It skips paid and not-yet-due invoices, holds anything chased in the last 7 days, picks the tone from the days overdue, and turns a missing email or a second final notice into a note for the owner. It also formats the amount once, as text, so every later step quotes the same string.
Mode: Run Once for All Items · Language: JavaScript
const SENDER = 'Acme Bakery';
const SIGN_OFF = 'Priya, Acme Bakery accounts';
const ZONE = 'Australia/Sydney';
const GRACE = 3, FIRM = 14, FINAL = 30, REPEAT = 7;
const today = DateTime.now().setZone(ZONE).startOf('day');
function toDate(v) {
if (v === undefined || v === null || v === '') return null;
if (typeof v === 'number') return DateTime.fromObject({ year: 1899, month: 12, day: 30 }, { zone: ZONE }).plus({ days: Math.floor(v) });
const s = String(v).trim();
for (const f of ['yyyy-MM-dd', 'd/M/yyyy', 'dd/MM/yyyy', 'M/d/yyyy']) { const d = DateTime.fromFormat(s, f, { zone: ZONE }); if (d.isValid) return d.startOf('day'); }
const iso = DateTime.fromISO(s, { zone: ZONE });
return iso.isValid ? iso.startOf('day') : null;
}
function money(n) { return 'A$' + Number(n).toLocaleString('en-AU', { minimumFractionDigits: 2, maximumFractionDigits: 2 }); }
const out = [];
function flag(r, note) { if (String(r.agent_note || '').trim() !== note) out.push({ json: { action: 'flag', invoice_no: r.invoice_no, agent_note: note } }); }
for (const item of $input.all()) {
const r = item.json;
if (!r.invoice_no) continue;
if (String(r.status || '').trim().toLowerCase() === 'paid') continue;
const due = toDate(r.due_date);
const amount = Number(String(r.amount).replace(/[^0-9.]/g, ''));
if (!due || !amount) { flag(r, 'Check the due date and amount: the agent could not read them'); continue; }
const daysOverdue = Math.floor(today.diff(due, 'days').days);
if (daysOverdue < GRACE) continue;
const last = toDate(r.last_chased);
if (last && today.diff(last, 'days').days < REPEAT) continue;
if (!String(r.email || '').includes('@')) { flag(r, 'Add a client email so this invoice can be chased'); continue; }
const tone = daysOverdue >= FINAL ? 'Final notice' : daysOverdue >= FIRM ? 'Firm' : 'Friendly';
if (tone === 'Final notice' && String(r.last_tone || '').toLowerCase() === 'final notice') { flag(r, 'Still unpaid after a final notice: owner to decide the next step'); continue; }
out.push({ json: { action: 'chase', invoice_no: String(r.invoice_no), client: r.client, first_name: String(r.client || '').split(' ')[0], business: r.business, email: String(r.email).trim(), amount_text: money(amount), due_text: due.toFormat('d LLLL yyyy'), days_overdue: daysOverdue, tone, sender: SENDER, sign_off: SIGN_OFF, today_text: today.toFormat('yyyy-MM-dd') } });
}
return out;A few lines are worth reading closely. toDate accepts the date formats people actually type into sheets, and Google's serial numbers, so a date column formatted as a date doesn't break the run. flag writes an owner note only when the note has changed, so the sheet isn't rewritten every morning. And the final-notice check reads last_tone, which is how the agent knows it has already sent one.
4. Chase or flag to owner
A Switch node splits the items into two paths.
Mode: Rules · Output 1 "chase" when
{{ $json.action }}equalschaseOutput 2 "flag" when
{{ $json.action }}equalsflag
5. Leave a note for the owner in the sheet
On the flag path, a Google Sheets node updates the row's agent_note column.
Operation: Update · Column to match on:
invoice_noValues:
invoice_no={{ $json.invoice_no }},agent_note={{ $json.agent_note }}Options: Cell format RAW
6. Write reminder in the right tone
A Basic LLM Chain node with Claude Sonnet attached as its chat model and a Structured Output Parser, so the reply always comes back as a subject and a body. The system message carries the tone rules and, more importantly, the instruction to copy the invoice number and amount character for character.
Prompt: Define below, with "Require specific output format" on
Chat model: Anthropic,
claude-sonnet-4-6, temperature 0.3, max tokens 800Output parser: Structured, from a JSON example
{ "subject": "...", "body": "Hi Alex, ..." }
The prompt:
=Write a payment reminder email.
From: {{ $json.sender }}
Sign off as: {{ $json.sign_off }}
To: {{ $json.first_name }} at {{ $json.business }}
Invoice number: {{ $json.invoice_no }}
Amount: {{ $json.amount_text }}
Due date: {{ $json.due_text }}
Days overdue: {{ $json.days_overdue }}
Tone: {{ $json.tone }}The system message:
You write short payment reminder emails for a small business. Use plain, polite British English, under 110 words, no emoji, no exclamation marks and no bullet points. Quote the invoice number and the amount exactly as given, character for character; never round, convert or change them. Tone rules: Friendly means assume it slipped through and ask when it will be paid. Firm means state it is overdue and ask for payment this week, or a reply if something is wrong with the invoice. Final notice means say clearly this is the final reminder and ask for payment within 7 days; do not threaten legal action, debt collectors or fees. Never invent bank details, links, attachments, discounts or deadlines beyond these rules. Return a subject line and a body; the body starts with 'Hi' and the first name and ends with the sign-off.7. Check amount and invoice number
This is the step I would never leave out. A model that writes well can still change A$1,240.00 into $1,240 or drop a digit, and a reminder with the wrong amount is worse than no reminder. So the code checks that the draft contains the invoice number and the exact amount text. If it doesn't, the agent throws the model's draft away and uses a plain template instead, and it says so in the sheet.
Mode: Run Once for Each Item · Language: JavaScript
const src = $('Chase or flag to owner').item.json;
const out = $json.output || {};
let subject = String(out.subject || '').trim();
let body = String(out.body || '').trim();
const ok = body.includes(src.invoice_no) && body.includes(src.amount_text) && subject.length > 0;
if (!ok) {
subject = 'Invoice ' + src.invoice_no + ' (' + src.amount_text + ') is overdue';
body = 'Hi ' + src.first_name + ',\n\nInvoice ' + src.invoice_no + ' for ' + src.amount_text + ' was due on ' + src.due_text + ' and is now ' + src.days_overdue + ' days overdue. Could you let us know when it will be paid?\n\n' + src.sign_off;
}
return { json: { ...src, subject, body, checked: ok ? 'model draft passed' : 'model draft failed the amount check; template used' } };8. Save reminder as Gmail draft
Resource: Draft · Operation: Create · Email type: Text
Subject:
{{ $json.subject }}· Message:{{ $json.body }}Options: Send to
{{ $json.email }}Credential: your Gmail account
There is no Send operation anywhere in this workflow, so the agent can only ever leave a draft. Leaving that operation out is what makes it safe to switch on.
9. Write draft date to sheet
A last Google Sheets update records what happened, which is what stops tomorrow's run chasing the same invoice again.
Operation: Update · Column to match on:
invoice_no· Cell format RAWlast_chased= today's date,last_tone= the tone used,agent_note= "Drafted on date (tone); model draft passed"
Test cases
The workflow ran on the eight sample invoices on 21 November 2026. Each one is a case the agent has to get right, and it handled all eight as the README says it should:
INV-1042, 5 days late: friendly draft.
INV-1038, 16 days late: firm draft.
INV-1029, 40 days late: final notice draft.
INV-1035, paid and INV-1045, not yet due: skipped.
INV-1031, chased 4 days ago: held until the 7 days have passed.
INV-1027, no email: owner note "Add a client email so this invoice can be chased".
INV-1022, unpaid after a final notice: owner note "Still unpaid after a final notice: owner to decide the next step".
All three drafts passed the amount check. This is the firm one, exactly as it landed in Gmail:
Overdue Invoice INV-1038 – A$860.00
Hi Sam,
I am writing to let you know that invoice INV-1038 for A$860.00, which was due on 5 November 2026, is now 16 days overdue.
Could you please arrange payment this week. If there is anything wrong with the invoice or you have a query, do reply and we will be happy to help.
Thank you for your attention to this matter.
Kind regards,
Priya, Acme Bakery accounts
And the final notice:
Final Notice: Invoice INV-1029 – A$975.00 Now 40 Days Overdue
Hi Morgan,
This is a final reminder regarding invoice INV-1029 for A$975.00, which was due on 12 October 2026 and is now 40 days overdue.
We kindly ask that you arrange payment in full within 7 days of receiving this email. If you have already done so, please do accept our thanks and disregard this message.
Should you have any queries regarding the invoice, please do get in touch and we will be happy to help.
Kind regards,
Priya, Acme Bakery accounts
The more telling test came straight afterwards. Running the workflow a second time produced nothing at all: every chased invoice now had today's date in last_chased, and both owner notes were already written. That matters, because a retried or doubled run can't send a client two reminders.
Common problems and fixes
Nothing happens, though invoices are overdue. The column headers don't match. They must be lower case with underscores, exactly as listed above.
Days overdue are off by one. The time zone is wrong. Set
ZONEin the decision step and the n8n instance time zone to the same place.Every row gets "Check the due date and amount". The amount column holds text such as "A$1,240 inc GST". The code strips symbols and commas, but words confuse it, so keep the column to numbers.
The sheet update fails. The update steps match on
invoice_no, so each invoice number must appear once. Duplicates stop the update.A note says "model draft failed the amount check". The safety net worked: the model changed the number, so the plain template was used. Read that draft with extra care, and consider a lower temperature.
Make it yours
A morning summary. Add a final step that sends you one message listing the drafts waiting and the owner notes, so you know before you open Gmail. Telegram or Slack both work well for this.
Your accounting system instead of a sheet. Swap the first Google Sheets node for an export from Xero or QuickBooks, and keep the sheet only as the log of who was chased.
The next level up. Once you trust the drafts, a level-2 version can send a reminder after you approve it with one click, and watch the thread for a reply. I'd only take that step after a month of reading drafts.
Try it, or download it
You can run the real agent on a sample invoice on the Invoice Chaser page and have the reminder emailed to you (never to the client on the invoice). The page also has a step-by-step simulation and the full workflow schematic. The catalogue page and sample data are in the Agent Lab repository.
Here is the whole workflow, ready to import. Credentials, IDs and personal details have been removed; add your own in the steps above.
{
"name": "Draft reminders for overdue unpaid invoices every weekday morning",
"nodes": [
{
"name": "Every weekday at 8am",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.3,
"position": [
0,
256
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 0 8 * * 1-5"
}
]
}
}
},
{
"name": "Read invoice sheet",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
224,
256
],
"parameters": {
"resource": "sheet",
"operation": "read",
"authentication": "oAuth2",
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet1"
}
}
},
{
"name": "Decide which invoices to chase",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
448,
256
],
"parameters": {
"mode": "runOnceForAllItems",
"language": "javaScript",
"jsCode": "const SENDER = 'Acme Bakery';\nconst SIGN_OFF = 'Priya, Acme Bakery accounts';\nconst ZONE = 'Australia/Sydney';\nconst GRACE = 3, FIRM = 14, FINAL = 30, REPEAT = 7;\nconst today = DateTime.now().setZone(ZONE).startOf('day');\nfunction toDate(v) {\n if (v === undefined || v === null || v === '') return null;\n if (typeof v === 'number') return DateTime.fromObject({ year: 1899, month: 12, day: 30 }, { zone: ZONE }).plus({ days: Math.floor(v) });\n const s = String(v).trim();\n for (const f of ['yyyy-MM-dd', 'd/M/yyyy', 'dd/MM/yyyy', 'M/d/yyyy']) { const d = DateTime.fromFormat(s, f, { zone: ZONE }); if (d.isValid) return d.startOf('day'); }\n const iso = DateTime.fromISO(s, { zone: ZONE });\n return iso.isValid ? iso.startOf('day') : null;\n}\nfunction money(n) { return 'A$' + Number(n).toLocaleString('en-AU', { minimumFractionDigits: 2, maximumFractionDigits: 2 }); }\nconst out = [];\nfunction flag(r, note) { if (String(r.agent_note || '').trim() !== note) out.push({ json: { action: 'flag', invoice_no: r.invoice_no, agent_note: note } }); }\nfor (const item of $input.all()) {\n const r = item.json;\n if (!r.invoice_no) continue;\n if (String(r.status || '').trim().toLowerCase() === 'paid') continue;\n const due = toDate(r.due_date);\n const amount = Number(String(r.amount).replace(/[^0-9.]/g, ''));\n if (!due || !amount) { flag(r, 'Check the due date and amount: the agent could not read them'); continue; }\n const daysOverdue = Math.floor(today.diff(due, 'days').days);\n if (daysOverdue < GRACE) continue;\n const last = toDate(r.last_chased);\n if (last && today.diff(last, 'days').days < REPEAT) continue;\n if (!String(r.email || '').includes('@')) { flag(r, 'Add a client email so this invoice can be chased'); continue; }\n const tone = daysOverdue >= FINAL ? 'Final notice' : daysOverdue >= FIRM ? 'Firm' : 'Friendly';\n if (tone === 'Final notice' && String(r.last_tone || '').toLowerCase() === 'final notice') { flag(r, 'Still unpaid after a final notice: owner to decide the next step'); continue; }\n out.push({ json: { action: 'chase', invoice_no: String(r.invoice_no), client: r.client, first_name: String(r.client || '').split(' ')[0], business: r.business, email: String(r.email).trim(), amount_text: money(amount), due_text: due.toFormat('d LLLL yyyy'), days_overdue: daysOverdue, tone, sender: SENDER, sign_off: SIGN_OFF, today_text: today.toFormat('yyyy-MM-dd') } });\n}\nreturn out;\n"
}
},
{
"name": "Chase or flag to owner",
"type": "n8n-nodes-base.switch",
"typeVersion": 3.4,
"position": [
672,
256
],
"parameters": {
"mode": "rules",
"rules": {
"values": [
{
"renameOutput": true,
"outputKey": "chase",
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"leftValue": "={{ $json.action }}",
"operator": {
"type": "string",
"operation": "equals"
},
"rightValue": "chase"
}
],
"combinator": "and"
}
},
{
"renameOutput": true,
"outputKey": "flag",
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict"
},
"conditions": [
{
"leftValue": "={{ $json.action }}",
"operator": {
"type": "string",
"operation": "equals"
},
"rightValue": "flag"
}
],
"combinator": "and"
}
}
]
}
}
},
{
"name": "Write reminder in the right tone",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"typeVersion": 1.9,
"position": [
896,
0
],
"parameters": {
"promptType": "define",
"text": "=Write a payment reminder email.\n\nFrom: {{ $json.sender }}\nSign off as: {{ $json.sign_off }}\nTo: {{ $json.first_name }} at {{ $json.business }}\nInvoice number: {{ $json.invoice_no }}\nAmount: {{ $json.amount_text }}\nDue date: {{ $json.due_text }}\nDays overdue: {{ $json.days_overdue }}\nTone: {{ $json.tone }}",
"hasOutputParser": true,
"messages": {
"messageValues": [
{
"type": "SystemMessagePromptTemplate",
"message": "You write short payment reminder emails for a small business. Use plain, polite British English, under 110 words, no emoji, no exclamation marks and no bullet points. Quote the invoice number and the amount exactly as given, character for character; never round, convert or change them. Tone rules: Friendly means assume it slipped through and ask when it will be paid. Firm means state it is overdue and ask for payment this week, or a reply if something is wrong with the invoice. Final notice means say clearly this is the final reminder and ask for payment within 7 days; do not threaten legal action, debt collectors or fees. Never invent bank details, links, attachments, discounts or deadlines beyond these rules. Return a subject line and a body; the body starts with 'Hi' and the first name and ends with the sign-off."
}
]
}
}
},
{
"name": "Claude Sonnet",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"typeVersion": 1.5,
"position": [
912,
224
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-sonnet-4-6"
},
"options": {
"temperature": 0.3,
"maxTokensToSample": 800
}
}
},
{
"name": "Subject and body",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"typeVersion": 1.3,
"position": [
1040,
224
],
"parameters": {
"schemaType": "fromJson",
"jsonSchemaExample": "{ \"subject\": \"Invoice INV-1042 is now overdue\", \"body\": \"Hi Alex, ...\" }"
}
},
{
"name": "Check amount and invoice number",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1248,
112
],
"parameters": {
"mode": "runOnceForEachItem",
"language": "javaScript",
"jsCode": "const src = $('Chase or flag to owner').item.json;\nconst out = $json.output || {};\nlet subject = String(out.subject || '').trim();\nlet body = String(out.body || '').trim();\nconst ok = body.includes(src.invoice_no) && body.includes(src.amount_text) && subject.length > 0;\nif (!ok) {\n subject = 'Invoice ' + src.invoice_no + ' (' + src.amount_text + ') is overdue';\n body = 'Hi ' + src.first_name + ',\\n\\nInvoice ' + src.invoice_no + ' for ' + src.amount_text + ' was due on ' + src.due_text + ' and is now ' + src.days_overdue + ' days overdue. Could you let us know when it will be paid?\\n\\n' + src.sign_off;\n}\nreturn { json: { ...src, subject, body, checked: ok ? 'model draft passed' : 'model draft failed the amount check; template used' } };\n"
}
},
{
"name": "Save reminder as Gmail draft",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [
1472,
112
],
"parameters": {
"resource": "draft",
"operation": "create",
"authentication": "oAuth2",
"subject": "={{ $json.subject }}",
"emailType": "text",
"message": "={{ $json.body }}",
"options": {
"sendTo": "={{ $json.email }}"
}
}
},
{
"name": "Write draft date to sheet",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1696,
112
],
"parameters": {
"resource": "sheet",
"operation": "update",
"authentication": "oAuth2",
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet1"
},
"columns": {
"mappingMode": "defineBelow",
"matchingColumns": [
"invoice_no"
],
"value": {
"invoice_no": "={{ $('Check amount and invoice number').item.json.invoice_no }}",
"last_chased": "={{ $('Check amount and invoice number').item.json.today_text }}",
"last_tone": "={{ $('Check amount and invoice number').item.json.tone }}",
"agent_note": "=Drafted on {{ $('Check amount and invoice number').item.json.today_text }} ({{ $('Check amount and invoice number').item.json.tone.toLowerCase() }}); {{ $('Check amount and invoice number').item.json.checked }}"
}
},
"options": {
"cellFormat": "RAW"
}
}
},
{
"name": "Leave a note for the owner in the sheet",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
960,
400
],
"parameters": {
"resource": "sheet",
"operation": "update",
"authentication": "oAuth2",
"documentId": {
"__rl": true,
"mode": "id",
"value": "YOUR_SHEET_ID"
},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Sheet1"
},
"columns": {
"mappingMode": "defineBelow",
"matchingColumns": [
"invoice_no"
],
"value": {
"invoice_no": "={{ $json.invoice_no }}",
"agent_note": "={{ $json.agent_note }}"
}
},
"options": {
"cellFormat": "RAW"
}
}
}
],
"connections": {
"Every weekday at 8am": {
"main": [
[
{
"node": "Read invoice sheet",
"type": "main",
"index": 0
}
]
]
},
"Read invoice sheet": {
"main": [
[
{
"node": "Decide which invoices to chase",
"type": "main",
"index": 0
}
]
]
},
"Decide which invoices to chase": {
"main": [
[
{
"node": "Chase or flag to owner",
"type": "main",
"index": 0
}
]
]
},
"Chase or flag to owner": {
"main": [
[
{
"node": "Write reminder in the right tone",
"type": "main",
"index": 0
}
],
[
{
"node": "Leave a note for the owner in the sheet",
"type": "main",
"index": 0
}
]
]
},
"Write reminder in the right tone": {
"main": [
[
{
"node": "Check amount and invoice number",
"type": "main",
"index": 0
}
]
]
},
"Claude Sonnet": {
"ai_languageModel": [
[
{
"node": "Write reminder in the right tone",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Subject and body": {
"ai_outputParser": [
[
{
"node": "Write reminder in the right tone",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Check amount and invoice number": {
"main": [
[
{
"node": "Save reminder as Gmail draft",
"type": "main",
"index": 0
}
]
]
},
"Save reminder as Gmail draft": {
"main": [
[
{
"node": "Write draft date to sheet",
"type": "main",
"index": 0
}
]
]
}
},
"settings": {
"executionOrder": "v1"
}
}
