An automated financial assistant for Indian freelancers that tracks invoices, calculates GST, and manages multi-channel payment follow-ups.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install freelance-invoice-tracker
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install freelance-invoice-tracker using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Freelance Invoice Tracker?
The Freelance Invoice Tracker is a specialized tool designed to handle the end-to-end invoicing lifecycle for independent professionals. By leveraging Openclaw Skills, this agent connects directly to your Google Sheets to monitor payment statuses and automate the tedious process of chasing clients for outstanding dues. It is specifically localized for the Indian market, incorporating GST calculation logic and localized payment methods like UPI.
This skill transforms a standard spreadsheet into an active financial operations hub. It doesn't just store data; it acts on it by sending tiered reminders through email and WhatsApp, ensuring that freelancers can focus on their core work while the AI manages their receivables and tax preparation summaries.
Freelance Invoice Tracker Use Cases
- Automating polite payment reminders for overdue client invoices.
- Sending localized WhatsApp follow-ups for a higher response rate in the Indian market.
- Tracking GST collections across different projects for quarterly tax filing.
- Generating monthly income reports to visualize cash flow and client performance.
- Managing partial payments and tracking remaining balances automatically.
How Freelance Invoice Tracker Works
- The skill initializes by connecting to the Google Sheets API using provided service account credentials.
- It performs a daily scan of the Invoices sheet at 9 AM IST to identify payments that are due or overdue.
- Based on predefined overdue tiers (1-7 days, 8-14 days, etc.), it selects the appropriate communication template and channel.
- It sends automated notifications via Gmail or SMTP and optionally triggers WhatsApp messages for firm reminders.
- The skill processes incoming commands from the freelancer to update invoice statuses, add new records, or generate on-demand financial summaries.
Freelance Invoice Tracker Setup
To get started with this skill, follow these installation steps:
- Prepare a Google Sheet with the required Invoices and Settings tabs.
- Create a Google Cloud Service Account, enable the Sheets API, and download the JSON key.
- Share your Google Sheet with the Service Account email address.
- Configure your environment variables within the Openclaw Skills framework:
export GOOGLE_SHEETS_CREDENTIALS='{"type": "service_account", ...}'
export INVOICE_SHEET_ID='your_google_sheet_id_here'
export EMAIL_PROVIDER='gmail'
- Run the daily-check command to verify the connection and start the automated tracking cycle.
Freelance Invoice Tracker Data Schema & Taxonomy
The skill organizes data across two main tabs in Google Sheets to maintain a clear metadata taxonomy:
Invoices Tab
- Invoice ID: Unique identifier for tracking.
- Client Details: Name, Email, and WhatsApp contact information.
- Financials: Amount excluding GST, GST percentage, and total calculated amount.
- Status: Current state of the invoice (paid, unpaid, or partial).
Settings Tab
- Freelancer Info: GSTIN, Bank Name, Account Number, and IFSC.
- Payment Links: UPI ID for quick client transfers.
- Communication: Custom email signatures and freelancer name.
Freelance Invoice Tracker Advanced Features
- Multi-channel escalation logic using both Email and WhatsApp for overdue payments.
- Automatic GST summary generation for GSTR-1 filing preparation.
- Cron-based scheduling for daily invoice checks and monthly revenue reporting.
- Manual override commands to trigger instant reminders or record partial payments.
- Client behavior analytics identifying fastest and slowest paying clients.
SKILL.md
Loading
Related Openclaw Skills
Flipkart Seller Dashboard
A professional e-commerce intelligence assistant that automates Flipkart and Amazon India seller operations, providing daily morning reports and real-time inventory alerts via WhatsApp.
Video Organizer
A robust CLI tool for batch renaming and organizing video libraries by date, format, and resolution.
Photo Organizer
A powerful CLI tool for batch organizing photos based on EXIF metadata like timestamps and GPS coordinates.
Music Tagger
A high-performance CLI utility for batch editing music metadata and programmatically organizing audio files into structured directories.
India Market Pulse
An AI-powered financial assistant providing real-time Indian stock market updates and automated price alerts through Openclaw Skills.
Razorpay Monitor
An autonomous monitoring assistant that tracks Razorpay payment flows, alerts you of failures, and delivers revenue summaries via WhatsApp or Telegram.
Featured*
