Send AI-written invoice emails and payment reminders with Google Sheets, Gmail, Telegram and Groq
Ready for 3.0What this workflow does
This AI workflow has 42 nodes and runs on Google Sheets events (row added) (plus 3 other triggers). Along the way it connects Google Sheets, Gmail, Telegram and Groq Chat Model. It also calls api.pdfshift.io over HTTP.
How it runs
Trigger: On Google Sheets events (row added) (plus 3 other triggers).
- Generate Invoice HTML (HTML): parses or builds HTML
- Check Paid Command (If): checks a condition and branches into true / false
- Read All Invoices (Google Sheets): uses Google Sheets
- Send Error Alert (Telegram): uses Telegram
- HTTP Request: calls api.pdfshift.io (POST)
- Extract Client Name (Code): runs custom JavaScript code
- Filter Unpaid Invoices (If): checks a condition and branches into true / false
- AI Agent: runs an AI agent, with model: Groq Chat Model
- Merge: merges the data from its input branches
- Find Client Invoice (Google Sheets): uses Google Sheets
…plus 24 more steps. See the full node list below.
Services it uses
HTTP calls to: api.pdfshift.io
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (16)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - Edit Fields (Set)
n8n-nodes-base.set - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram - HTML
n8n-nodes-base.html - Telegram Trigger
n8n-nodes-base.telegramTrigger - Error Trigger
n8n-nodes-base.errorTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge
From the author
Quick overview This workflow automates invoicing and payment follow-ups using Google Sheets, PDFShift, Groq (LLM), Gmail, and Telegram, sending initial invoices with PDF attachments, scheduling overdue reminders at 9am, and letting you mark invoices as paid…