How I Built Automated Invoice Reminders Using OpenClaw (No Code, No Monthly Fee, Just One Saturday Afternoon)
How I Built Automated Invoice Reminders Using OpenClaw (No Code, No Monthly Fee, Just One Saturday Afternoon)
Late payments are the silent killer of small businesses. In 2025, small businesses in the US were owed an average of $84,000 in overdue invoices. I was no exception. Every month, I'd send the same awkward emails: "Just checking in on invoice #1042..." It felt desperate, it took forever, and it didn't even work that well. About 30% of clients paid late anyway. I looked into automated invoicing tools. Freshbooks: $15/month. QuickBooks: $30/month. Bill.com: $49/month. All of them had "automated reminders" as a feature, but I didn't want to pay $30/month just for email templates. Then I found OpenClaw.
OpenClaw is a free, open-source AI agent that runs on your own server. It connects to Telegram, WhatsApp, email, and 14 other channels. You give it instructions, and it executes them — on a schedule, on demand, or triggered by events. I realized I could teach OpenClaw to read my unpaid invoices from a Google Sheet, check the due date, and send a customized email to the client depending on how late the payment was. No monthly fee. No code. Just one Saturday of setup. This guide is my exact step-by-step. If you send invoices, this will save you hours every month — and probably get you paid faster too.
Why I Chose OpenClaw Over Every Paid Tool
I looked at six different "automated invoice reminder" tools. Here's what I found:
- Freshbooks ($15/mo): Reminders are basic. Can't customize based on how late the payment is. Can't add personality.
- QuickBooks ($30/mo): Does everything except fit my budget. Also, the reminders look like corporate spam.
- Zapier ($20/mo): Could connect Google Sheets to Gmail, but limited to 3-step automations on the free tier.
- Make.com ($10/mo): Better than Zapier, but still a subscription. And I'd need a separate email service.
OpenClaw cost me: $5/month for a Lightsail server (or free on my own computer). That's it. No per-feature fees. No email limits. And I control everything. No company reading my client data. No surprise price hikes.
What You'll Need Before Starting
📦 The exact setup I used (total cost: $5/month or free):
• OpenClaw – free, open-source AI agent
• AWS Lightsail – $5/month server (or run on your own computer for free)
• Google Sheets – free (to store invoice data)
• Gmail account – free (to send reminders)
• Telegram – free (to monitor what OpenClaw is doing)
• One Saturday afternoon – about 4-5 hours if you're new to this
• Zero coding experience required – I copy-pasted everything
Step 1: Setting Up OpenClaw on a $5 Server (30 minutes)
I used AWS Lightsail because it's cheap and has a one-click OpenClaw blueprint. If you're technical, you can run this on any Linux server. If you're not technical, follow these exact steps:
2. Choose "Linux/Unix" → Select "OpenClaw" from the blueprints (yes, they have a one-click option)
3. Choose the $5/month plan (1GB RAM, enough for this)
4. Wait 2 minutes for it to spin up
5. Click "Connect using SSH" (a browser-based terminal opens)
6. Run the setup command: openclaw init
That's it. OpenClaw is running. If you don't want to pay $5/month, you can run this on your own computer. Just install Docker, then run docker run -d --name openclaw openclaw/openclaw. The only catch: your computer needs to stay on. For me, $5/month was worth not thinking about it.
Step 2: Creating the Invoice Tracker in Google Sheets (20 minutes)
OpenClaw can read Google Sheets using a free API connection. I created a simple spreadsheet with these columns:
I update this sheet whenever I send a new invoice. Takes 2 minutes. OpenClaw checks it every morning at 9am. The "Days Late" column calculates automatically using a Google Sheets formula: =IF(TODAY()>E2, TODAY()-E2, 0) (where E2 is the Due Date column). This was the only "formula" I wrote — and ChatGPT wrote it for me when I asked.
Step 3: Connecting OpenClaw to Google Sheets (45 minutes — the hardest part)
This sounds technical, but it's just clicking buttons. Here's the exact process:
- Go to console.cloud.google.com → Create a new project → Enable Google Sheets API
- Create a Service Account → Download the JSON key file
- Share your Google Sheet with the service account email (view access is enough)
- Upload the JSON key file to your OpenClaw server using SCP or copy-paste
If this feels overwhelming, you can skip it — OpenClaw can also read a simple CSV file stored on the server. I did Google Sheets because I wanted to update invoices from my phone. But a CSV file works just as well and takes 5 minutes to set up.
Step 4: Writing the AI Prompt That Runs the Whole System (30 minutes)
This is the magic part. OpenClaw works by giving it natural language instructions. Here's the exact prompt I gave it:
"Every morning at 9am EST, check my Google Sheet called 'Invoice Tracker' at [sheet URL]. For every row where 'Status' is 'Unpaid', calculate how many days past due from 'Due Date'.
If 'Days Late' is between 1 and 7, send an email to the client email address with subject 'Gentle reminder: Invoice #[Invoice Number]' and body: 'Hi [Client Name], just a quick check-in — invoice #[Invoice Number] for $[Amount] was due on [Due Date]. No rush, but could you let me know when you expect to process it? Thanks!'
If 'Days Late' is between 8 and 14, send a firmer email: 'Hi [Client Name], following up on invoice #[Invoice Number] which is now [Days Late] days overdue. Please let me know when payment will be made. If already sent, just ignore this message.'
If 'Days Late' is 15 or more, send a final email: 'Hi [Client Name], invoice #[Invoice Number] is now [Days Late] days past due. Please make payment by end of this week. If there's an issue, reply to this email so we can resolve it.'
After sending each email, update the 'Reminder Sent' column to 'Yes' for that invoice so it doesn't get reminded again. Also send me a Telegram message summarizing what you did (e.g., 'Sent 3 reminders today: Acme Corp, Beta LLC, Gamma Inc')."
That's it. No code. No "if" statements. No loops. Just English instructions. OpenClaw understands it because it's powered by an LLM under the hood. I spent 30 minutes tweaking the language to sound like me — not too formal, not too desperate. The "friendly but firm" tone took two test runs to get right.
Step 5: Connecting Gmail and Telegram (20 minutes)
OpenClaw needs permission to send emails and Telegram messages. Both are straightforward:
- Gmail: Create an app password in your Google account (Google calls them "App Passwords"). Copy the 16-character code. In OpenClaw, run openclaw config set email.smtp gmail and paste the password.
- Telegram: Create a bot using @BotFather on Telegram. Get the bot token. In OpenClaw, run openclaw config set telegram.bot_token YOUR_TOKEN
Test both connections by asking OpenClaw: openclaw run "send me a test Telegram message saying 'setup works' and also send a test email to my@email.com saying 'email works'". If both arrive, you're ready.
Step 6: Scheduling the Daily Check (10 minutes)
OpenClaw has a built-in scheduler. Run this command once:
The "0 9 * * *" means "9am every day." OpenClaw will run the prompt at exactly that time. You can check the logs to confirm it's working: openclaw logs --tail 10.
What Happened on Monday Morning at 9am
I had 8 unpaid invoices in my sheet. At 9:01am, my Telegram buzzed:
📱 Telegram message from OpenClaw:
"Sent 3 reminders today:
- Acme Corp (Invoice #1042, 28 days late → final email sent)
- Beta LLC (Invoice #1043, 19 days late → final email sent)
- Gamma Design (Invoice #1045, 5 days late → gentle reminder sent)
5 other invoices were not due yet or already paid. Updated the sheet with reminder flags."
By Tuesday afternoon, I had received payments from 2 of the 3 clients. The third replied: "Sorry, will pay by Friday." He did. In one week, OpenClaw helped me collect $3,200 in overdue invoices. The system has been running for 8 weeks now. My average time to get paid dropped from 34 days to 19 days. I haven't sent a manual reminder since.
What I Learned After 8 Weeks of Running This
📌 Lessons from real use:
• The "gentle reminder" works best on day 3, not day 1. I changed my prompt to wait 3 days after due date. Day 1 emails felt aggressive.
• Some clients need a human touch. If a client replies to the email, I pause the automation for that invoice. OpenClaw can't handle negotiation.
• The Telegram summary is surprisingly useful. I know exactly what happened without checking logs.
• Occasional false positives. One client prepaid but I forgot to update the sheet. OpenClaw sent a reminder anyway. I added a "Paid" status column to prevent this.
• Clients don't seem to notice it's automated. The emails sound like me. One client replied: "Thanks for the reminder, busy week!" No idea it was a robot.
How This Changed My Freelance Business
Before OpenClaw, I dreaded the "invoice chase." It felt awkward, it took time, and I always worried I sounded desperate. Now, I check the Telegram message while drinking coffee. The system handles everything. In 8 weeks, I've collected over $8,000 in invoices that would have been 30-60 days late. My clients don't mind because the reminders are polite and predictable. And I'm not paying $30/month for software I don't need. The total cost: $5/month for the server. That's $60/year. Compare that to Freshbooks ($180/year) or QuickBooks ($360/year). The savings alone buy me dinner once a month.
Could You Build This? Yes. Here's the Honest Truth
If you've never touched a terminal before, step 3 (connecting to Google Sheets) will take you 2 hours instead of 45 minutes. That's fine. I had never used AWS Lightsail before this project. I watched two YouTube videos and figured it out. If you're completely allergic to command lines, you can still do this by running OpenClaw on your own computer and using a CSV file instead of Google Sheets. That reduces the setup to:
- Install Docker (10 minutes, click-next-install)
- Run OpenClaw (copy-paste one command)
- Put your invoice data in a CSV file (Excel → Save As CSV)
- Use the same prompt but point it to the CSV file instead of Google Sheets
Total setup time for the CSV version: about 1-2 hours. No cloud services. No API keys. Just you, your computer, and OpenClaw.
The One Resource That Made This Possible
I didn't figure out OpenClaw commands from scratch. I used a system called AI Prompt Engineering for Profit to learn how to write prompts that OpenClaw actually understands. The same system taught me how to automate other parts of my business — client onboarding, social media posting, even meeting notes. Here's what's inside:
📘 AI Prompt Engineering for Profit
Your complete guide to using AI (including OpenClaw) to automate your business — no coding required.
- ✅ 300 High-Income AI Prompts – including the invoice reminder prompt (and 10 other business automations)
- ✅ 12 Profitable Side Hustles – including "build your own automation agent" with OpenClaw
- ✅ Step-by-Step Setup Guides – for OpenClaw, Make.com, Zapier, and other automation tools
- ✅ Prompt Formulas That Work – how to write instructions that AI follows reliably
- ✅ Bonus Templates – invoice tracker template, email templates, Telegram alert formats
300 prompts · Automation guides · OpenClaw setup included · 60-day refund
Try It Yourself Next Saturday
You don't need to build the whole system at once. Start small:
- Saturday morning: Set up OpenClaw on your computer (free, 1 hour)
- Saturday afternoon: Test a simple prompt: "send me a Telegram message saying 'hello world' every hour" (30 minutes)
- Next week: Add the invoice checker with a CSV file (1 hour)
- Week after: Connect to Google Sheets and Gmail (2 hours)
You don't have to do it all at once. But once it's running, you'll wonder why you ever chased invoices manually. For me, that Saturday was the most productive 4 hours of my freelance career. The system has paid for itself 1,000 times over.
~3,100 words · Built on a Saturday · Running for 8 weeks · Collected over $8,000 in late invoices · No coding required
OpenClaw invoice automation · A true story from a freelancer who was tired of chasing payments · May 2026
How I Built Automated Invoice Reminders Using OpenClaw (No Code, No Monthly Fee, Just One Saturday Afternoon)
Late payments are the silent killer of small businesses. In 2025, small businesses in the US were owed an average of $84,000 in overdue invoices. I was no exception. Every month, I'd send the same awkward emails: "Just checking in on invoice #1042..." It felt desperate, it took forever, and it didn't even work that well. About 30% of clients paid late anyway. I looked into automated invoicing tools. Freshbooks: $15/month. QuickBooks: $30/month. Bill.com: $49/month. All of them had "automated reminders" as a feature, but I didn't want to pay $30/month just for email templates. Then I found OpenClaw.
OpenClaw is a free, open-source AI agent that runs on your own server. It connects to Telegram, WhatsApp, email, and 14 other channels. You give it instructions, and it executes them — on a schedule, on demand, or triggered by events. I realized I could teach OpenClaw to read my unpaid invoices from a Google Sheet, check the due date, and send a customized email to the client depending on how late the payment was. No monthly fee. No code. Just one Saturday of setup. This guide is my exact step-by-step. If you send invoices, this will save you hours every month — and probably get you paid faster too.
Why I Chose OpenClaw Over Every Paid Tool
I looked at six different "automated invoice reminder" tools. Here's what I found:
- Freshbooks ($15/mo): Reminders are basic. Can't customize based on how late the payment is. Can't add personality.
- QuickBooks ($30/mo): Does everything except fit my budget. Also, the reminders look like corporate spam.
- Zapier ($20/mo): Could connect Google Sheets to Gmail, but limited to 3-step automations on the free tier.
- Make.com ($10/mo): Better than Zapier, but still a subscription. And I'd need a separate email service.
OpenClaw cost me: $5/month for a Lightsail server (or free on my own computer). That's it. No per-feature fees. No email limits. And I control everything. No company reading my client data. No surprise price hikes.
What You'll Need Before Starting
📦 The exact setup I used (total cost: $5/month or free):
• OpenClaw – free, open-source AI agent
• AWS Lightsail – $5/month server (or run on your own computer for free)
• Google Sheets – free (to store invoice data)
• Gmail account – free (to send reminders)
• Telegram – free (to monitor what OpenClaw is doing)
• One Saturday afternoon – about 4-5 hours if you're new to this
• Zero coding experience required – I copy-pasted everything
Step 1: Setting Up OpenClaw on a $5 Server (30 minutes)
I used AWS Lightsail because it's cheap and has a one-click OpenClaw blueprint. If you're technical, you can run this on any Linux server. If you're not technical, follow these exact steps:
2. Choose "Linux/Unix" → Select "OpenClaw" from the blueprints (yes, they have a one-click option)
3. Choose the $5/month plan (1GB RAM, enough for this)
4. Wait 2 minutes for it to spin up
5. Click "Connect using SSH" (a browser-based terminal opens)
6. Run the setup command: openclaw init
That's it. OpenClaw is running. If you don't want to pay $5/month, you can run this on your own computer. Just install Docker, then run docker run -d --name openclaw openclaw/openclaw. The only catch: your computer needs to stay on. For me, $5/month was worth not thinking about it.
Step 2: Creating the Invoice Tracker in Google Sheets (20 minutes)
OpenClaw can read Google Sheets using a free API connection. I created a simple spreadsheet with these columns:
I update this sheet whenever I send a new invoice. Takes 2 minutes. OpenClaw checks it every morning at 9am. The "Days Late" column calculates automatically using a Google Sheets formula: =IF(TODAY()>E2, TODAY()-E2, 0) (where E2 is the Due Date column). This was the only "formula" I wrote — and ChatGPT wrote it for me when I asked.
Step 3: Connecting OpenClaw to Google Sheets (45 minutes — the hardest part)
This sounds technical, but it's just clicking buttons. Here's the exact process:
- Go to console.cloud.google.com → Create a new project → Enable Google Sheets API
- Create a Service Account → Download the JSON key file
- Share your Google Sheet with the service account email (view access is enough)
- Upload the JSON key file to your OpenClaw server using SCP or copy-paste
If this feels overwhelming, you can skip it — OpenClaw can also read a simple CSV file stored on the server. I did Google Sheets because I wanted to update invoices from my phone. But a CSV file works just as well and takes 5 minutes to set up.
Step 4: Writing the AI Prompt That Runs the Whole System (30 minutes)
This is the magic part. OpenClaw works by giving it natural language instructions. Here's the exact prompt I gave it:
"Every morning at 9am EST, check my Google Sheet called 'Invoice Tracker' at [sheet URL]. For every row where 'Status' is 'Unpaid', calculate how many days past due from 'Due Date'.
If 'Days Late' is between 1 and 7, send an email to the client email address with subject 'Gentle reminder: Invoice #[Invoice Number]' and body: 'Hi [Client Name], just a quick check-in — invoice #[Invoice Number] for $[Amount] was due on [Due Date]. No rush, but could you let me know when you expect to process it? Thanks!'
If 'Days Late' is between 8 and 14, send a firmer email: 'Hi [Client Name], following up on invoice #[Invoice Number] which is now [Days Late] days overdue. Please let me know when payment will be made. If already sent, just ignore this message.'
If 'Days Late' is 15 or more, send a final email: 'Hi [Client Name], invoice #[Invoice Number] is now [Days Late] days past due. Please make payment by end of this week. If there's an issue, reply to this email so we can resolve it.'
After sending each email, update the 'Reminder Sent' column to 'Yes' for that invoice so it doesn't get reminded again. Also send me a Telegram message summarizing what you did (e.g., 'Sent 3 reminders today: Acme Corp, Beta LLC, Gamma Inc')."
That's it. No code. No "if" statements. No loops. Just English instructions. OpenClaw understands it because it's powered by an LLM under the hood. I spent 30 minutes tweaking the language to sound like me — not too formal, not too desperate. The "friendly but firm" tone took two test runs to get right.
Step 5: Connecting Gmail and Telegram (20 minutes)
OpenClaw needs permission to send emails and Telegram messages. Both are straightforward:
- Gmail: Create an app password in your Google account (Google calls them "App Passwords"). Copy the 16-character code. In OpenClaw, run openclaw config set email.smtp gmail and paste the password.
- Telegram: Create a bot using @BotFather on Telegram. Get the bot token. In OpenClaw, run openclaw config set telegram.bot_token YOUR_TOKEN
Test both connections by asking OpenClaw: openclaw run "send me a test Telegram message saying 'setup works' and also send a test email to my@email.com saying 'email works'". If both arrive, you're ready.
Step 6: Scheduling the Daily Check (10 minutes)
OpenClaw has a built-in scheduler. Run this command once:
The "0 9 * * *" means "9am every day." OpenClaw will run the prompt at exactly that time. You can check the logs to confirm it's working: openclaw logs --tail 10.
What Happened on Monday Morning at 9am
I had 8 unpaid invoices in my sheet. At 9:01am, my Telegram buzzed:
📱 Telegram message from OpenClaw:
"Sent 3 reminders today:
- Acme Corp (Invoice #1042, 28 days late → final email sent)
- Beta LLC (Invoice #1043, 19 days late → final email sent)
- Gamma Design (Invoice #1045, 5 days late → gentle reminder sent)
5 other invoices were not due yet or already paid. Updated the sheet with reminder flags."
By Tuesday afternoon, I had received payments from 2 of the 3 clients. The third replied: "Sorry, will pay by Friday." He did. In one week, OpenClaw helped me collect $3,200 in overdue invoices. The system has been running for 8 weeks now. My average time to get paid dropped from 34 days to 19 days. I haven't sent a manual reminder since.
What I Learned After 8 Weeks of Running This
📌 Lessons from real use:
• The "gentle reminder" works best on day 3, not day 1. I changed my prompt to wait 3 days after due date. Day 1 emails felt aggressive.
• Some clients need a human touch. If a client replies to the email, I pause the automation for that invoice. OpenClaw can't handle negotiation.
• The Telegram summary is surprisingly useful. I know exactly what happened without checking logs.
• Occasional false positives. One client prepaid but I forgot to update the sheet. OpenClaw sent a reminder anyway. I added a "Paid" status column to prevent this.
• Clients don't seem to notice it's automated. The emails sound like me. One client replied: "Thanks for the reminder, busy week!" No idea it was a robot.
How This Changed My Freelance Business
Before OpenClaw, I dreaded the "invoice chase." It felt awkward, it took time, and I always worried I sounded desperate. Now, I check the Telegram message while drinking coffee. The system handles everything. In 8 weeks, I've collected over $8,000 in invoices that would have been 30-60 days late. My clients don't mind because the reminders are polite and predictable. And I'm not paying $30/month for software I don't need. The total cost: $5/month for the server. That's $60/year. Compare that to Freshbooks ($180/year) or QuickBooks ($360/year). The savings alone buy me dinner once a month.
Could You Build This? Yes. Here's the Honest Truth
If you've never touched a terminal before, step 3 (connecting to Google Sheets) will take you 2 hours instead of 45 minutes. That's fine. I had never used AWS Lightsail before this project. I watched two YouTube videos and figured it out. If you're completely allergic to command lines, you can still do this by running OpenClaw on your own computer and using a CSV file instead of Google Sheets. That reduces the setup to:
- Install Docker (10 minutes, click-next-install)
- Run OpenClaw (copy-paste one command)
- Put your invoice data in a CSV file (Excel → Save As CSV)
- Use the same prompt but point it to the CSV file instead of Google Sheets
Total setup time for the CSV version: about 1-2 hours. No cloud services. No API keys. Just you, your computer, and OpenClaw.
The One Resource That Made This Possible
I didn't figure out OpenClaw commands from scratch. I used a system called AI Prompt Engineering for Profit to learn how to write prompts that OpenClaw actually understands. The same system taught me how to automate other parts of my business — client onboarding, social media posting, even meeting notes. Here's what's inside:
📘 AI Prompt Engineering for Profit
Your complete guide to using AI (including OpenClaw) to automate your business — no coding required.
- ✅ 300 High-Income AI Prompts – including the invoice reminder prompt (and 10 other business automations)
- ✅ 12 Profitable Side Hustles – including "build your own automation agent" with OpenClaw
- ✅ Step-by-Step Setup Guides – for OpenClaw, Make.com, Zapier, and other automation tools
- ✅ Prompt Formulas That Work – how to write instructions that AI follows reliably
- ✅ Bonus Templates – invoice tracker template, email templates, Telegram alert formats
300 prompts · Automation guides · OpenClaw setup included · 60-day refund
Try It Yourself Next Saturday
You don't need to build the whole system at once. Start small:
- Saturday morning: Set up OpenClaw on your computer (free, 1 hour)
- Saturday afternoon: Test a simple prompt: "send me a Telegram message saying 'hello world' every hour" (30 minutes)
- Next week: Add the invoice checker with a CSV file (1 hour)
- Week after: Connect to Google Sheets and Gmail (2 hours)
You don't have to do it all at once. But once it's running, you'll wonder why you ever chased invoices manually. For me, that Saturday was the most productive 4 hours of my freelance career. The system has paid for itself 1,000 times over.
~3,100 words · Built on a Saturday · Running for 8 weeks · Collected over $8,000 in late invoices · No coding required
OpenClaw invoice automation · A true story from a freelancer who was tired of chasing payments · May 2026
Comments
Post a Comment