How Should an AI Agent Draft a Follow-Up for Each Late Invoice?
Build an AI agent in Gumloop that reads your sheet's days-past-due column and drafts one Gmail note per late invoice, in the tone you wrote for its band.
An AI agent in Gumloop reads the days-past-due column in your invoice sheet and drafts one Gmail note for each unpaid invoice, in the tone you wrote for the band it falls in. You set where each band starts. The block tells the AI agent not to send or do date arithmetic. You read and send each note yourself.
The column of due dates in your invoice sheet is one you've stopped scrolling to since the invoices went out.
Some of those dates have gone by. The note to the client is awkward to write, and how firm it should sound depends on how late the invoice is.
You write a ladder once: a first note, a firmer note and a note that asks for a call, each with the day it starts and a sentence of tone. The AI agent reads your sheet's days-past-due column, puts each unpaid invoice in its band and drafts one Gmail email in that band's tone.
What does each band on the ladder hold?
A band holds a name, the days past due where it starts, and one sentence of tone. A tone sentence is one plain line: "Friendly, and assuming it slipped past them." "Brief, and asking for a time to talk by phone." Replace those with your own.
The block tells the AI agent not to work out days past due. An invoice lands in the band with the highest start that the column's value has reached, and a row below the first band gets no draft.
How do you build the late invoice drafter in Gumloop?
- 01
Decide where each band starts and how it sounds.
Write the bands on paper. Then check your sheet has a column each for the invoice, the client, the client's email, whether it's paid, and the days past due. If it holds due dates but no days-past-due column, add one. The AI agent reads each invoice's days past due from that column.
- 02
Open Gumloop and add the sheet and your inbox.
Open Gumloop and start a new AI agent. On the tab named Agent, expand Connectors, click Add, and pick Google Sheets and then Gmail, signing in to each if Gumloop asks. Connecting an app in Settings alone doesn't attach it, so confirm both appear on the AI agent. Checked on 2026-11-10 against Gumloop's help page on giving an AI agent a connector, which names Google Sheets and Gmail among the built-in connectors.
- 03
Set Gmail and Google Sheets to ask before they write.
Gumloop's default for a connector is Always allow. Click the approval icon next to Gmail in the Connectors list, choose Ask for writes/deletes, and do the same for Google Sheets. Checked on 2026-11-10 against Human in the loop.
- 04
Find your draft tool in Gmail's Tool Management.
Open Gmail's detail view and read the Tool Management panel, which sorts tools into Read-only tools and Write/delete tools. Gumloop's pages don't list Gmail's tools, so look in your own account for the tool that creates a draft and for any that sends. Turn off each one that sends. Set your draft tool to Ask each time so each draft stops at an approval card. Checked on 2026-11-10 against Gumloop's AI agent builder page and the help page above. How Do You Control What an AI Agent Can Do in Your Gmail? shows that screen.
- 05
Write your bands into the block.
On the tab named Agent, paste the block below into the instructions box with your columns, bands and tone sentences written in. Then turn off Edit Own Instructions, right under the box, and press Save. Checked on 2026-11-10 against the self-improving instructions section of Gumloop's AI agent builder page.
- 06
Compare the drafts with bands you placed by hand.
On a copy of the sheet, write the band you expect beside a few invoices. Start a task, ask the AI agent for the column names it can read and the first row's days past due value, and compare them with the sheet. Then send "Draft the late invoice notes" and check each draft against the band and tone you wrote. Rename the days-past-due column on the copy and run it again: the AI agent should say the column isn't there and draft nothing. If Gmail doesn't have a draft tool, ask for each note in the chat and paste it into a Gmail draft yourself.
I am an ambassador for Gumloop. Code SMBIZ takes 20% off your first month.
What do you paste into the instructions for the late invoice notes?
You draft follow-up emails for late invoices at [BUSINESS NAME]. Read only the sheet named [SHEET NAME]. Its columns are invoice [INVOICE COLUMN], client [CLIENT COLUMN], email [EMAIL COLUMN], status [STATUS COLUMN], days past due [DAYS PAST DUE COLUMN] and amount [AMOUNT COLUMN, or the word none]. Work on rows where the status column says [UNPAID WORD]. Do no date arithmetic. If the days past due column isn't in the sheet, write "No days past due column" and draft nothing. My bands: [BAND ONE NAME] starts at [DAYS] days past due. Tone: [ONE SENTENCE]. [BAND TWO NAME] starts at [DAYS] days past due. Tone: [ONE SENTENCE]. [BAND THREE NAME] starts at [DAYS] days past due. Tone: [ONE SENTENCE]. Put each row in the band with the highest start its days past due value has reached. A row below the first band, or with that cell blank, gets no draft: list it under "No band". For each row in a band, make one Gmail draft to the client's email in that band's tone, naming the invoice. State an amount only if the amount column names a column and the cell holds one, copied as printed. Add no late fee, interest, deadline or payment link the sheet doesn't hold. You draft only. Send, reply to and forward nothing.
How do you tell a draft is in the right band?
Set a few drafts beside their sheet rows. The days past due value should be at or past the start of the band the draft is in, and short of the start of the next. If it isn't, check the starts in your block against the bands you wrote.
A figure in a draft that isn't in the amount cell for that row means the AI agent didn't follow the block's rule on amounts. Then open Gmail and check that the notes are in the drafts folder and that none of them appears in the sent folder.
When your payment terms change, the bands change with them. For follow-ups to leads, use How Do I Build an AI Agent That Follows Up With My Leads?.
Frequently asked questions
Can it forecast what I'll collect?
Not with this block. No Gumloop page cited here describes a path from a sheet to a forecast, and the AI agent places invoices by one column and drafts notes.
What if my sheet has due dates but no days-past-due column?
Your instructions tell the AI agent to do no date arithmetic, so it writes that the column isn't in the sheet and drafts nothing. Add the column in the sheet and run it again.
What if one client has two unpaid invoices?
Each invoice is its own row, so each gets its own draft, possibly in different bands. Read both before you send either, and fold them into one email by hand if you'd write it that way.