Templates / Chase overdue invoice payments from Google Sheets with OpenAI and Gmail

Chase overdue invoice payments from Google Sheets with OpenAI and Gmail

Needs changes

by Jupi Labs · 2 views · created 2026-09-24 · Invoice Processing, AI Summarization

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: OpenAI (legacy). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This workflow has 6 nodes and runs on a schedule (every day at 09:00). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: On a schedule (every day at 09:00).

Read invoices (Google Sheets): read
Pick invoices to chase (Code): runs custom JavaScript code
Draft the reminder (OpenAI): complete (chat)
Create Gmail draft (Gmail): work with draft
Log the chase (Google Sheets): update

Services it uses

Google Sheets Gmail

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

OpenAI (legacy) in Draft the reminder: replace with OpenAI node (AI section).

Removed in 3.0	Replace with
OpenAI (legacy) Draft the reminder	OpenAI node (AI section)

Nodes used (5)

Schedule Triggern8n-nodes-base.scheduleTrigger
Google Sheetsn8n-nodes-base.googleSheets
Coden8n-nodes-base.code
OpenAIn8n-nodes-base.openAi
Gmailn8n-nodes-base.gmail

From the author

Quick overview This workflow runs daily at 9am, reads invoices from Google Sheets, uses OpenAI to draft an overdue-payment reminder with escalating tone based on days overdue, creates a Gmail draft to the client, and updates the sheet with the latest chase…
Excerpt from Jupi Labs's description on n8n.io.

View the original on n8n.io → Check your own copy

Chase overdue invoice payments from Google Sheets with OpenAI and Gmail

What this workflow does

How it runs

Services it uses

Before you upgrade to n8n 3.0

Nodes used (5)

From the author

Get the weekly “what broke” email