An AI-powered invoice management system built using three interconnected Zapier workflows. It automates invoice intake, duplicate detection, AI invoice analysis, payment status verification, confirmation emails, overdue payment reminders, CRM updates, and Slack notifications.
01 / Project Overview
Invoice operations connected through one database.
Airtable acts as the centralized invoice database. Three interconnected Zapier workflows handle invoice processing, stored payment-status updates, and overdue payment follow-ups.
02 / Business Challenge
Manual tracking makes follow-up difficult.
Manual invoice management requires repetitive data entry, payment tracking, status verification, and follow-up communication.
Duplicate invoice records
Inconsistent invoice review processes
Manual monitoring of payment statuses
Delayed payment follow-ups
Difficulty tracking reminder history
Limited visibility into invoice operations
Automation Solution
Three workflows for the invoice lifecycle.
The intake workflow checks duplicates and prepares AI analysis for review. The payment workflow processes Paid, manually Verified Airtable records. The reminder workflow checks overdue eligibility, sends AI-generated reminders, and updates tracking.
Payment verification uses stored CRM status. The system does not independently verify bank or payment processor transactions or process payments.
03 / Workflow Architecture
Intake, payment status, and reminders.
Each Zap has a separate trigger and responsibility. The screenshots preserve every visible node and the intake workflow’s two conditional paths.
Zap 1 / Architecture
Workflow 1 — Invoice Intake & Processing
11 configured steps across new-invoice and duplicate-invoice paths. Intake records are checked, analyzed, and routed before CRM updates and Slack review notifications.
Zap 2 / Architecture
Workflow 2 — Payment Status Tracking
Processes invoices marked Paid and manually Verified in Airtable. Stored CRM status controls confirmation emails and notifications; bank or payment processor transactions are not independently verified.
Zap 3 / Architecture
Workflow 3 — Automated Payment Reminders
A daily schedule retrieves eligible invoices, loops through them, rechecks current state, generates and sends AI reminders, and updates counts and timestamps. Airtable formulas evaluate overdue status, reminder counts, and a 72-hour cooldown.
Integration / Test Output
Invoice Database
Airtable centralizes invoice records, including client information, amounts, due dates, payment status, verification status, and reminder tracking.
Integration / Test Output
AI Invoice Review
AI-generated invoice summaries, risk indicators, missing information, and recommended actions are delivered to Slack for internal review.
Integration / Test Output
Client Communication
Personalized payment reminders reference invoice details and payment deadlines. The provided example is a simulated reminder generated during workflow testing.
Reminder Eligibility
Check the current invoice before each reminder.
Airtable formula fields calculate eligibility from overdue status, reminder counts, and a 72-hour cooldown. Zapier retrieves eligible records, loops through invoices, rechecks current state, and filters eligibility before generating and sending a reminder. Reminder counts and timestamps are updated after sending.
Stack / Tools
Tools connecting records, AI, and communication.
Zapier
AI by Zapier
Airtable
Gmail
Slack
Schedule by Zapier
Looping by Zapier
Formatter by Zapier
Paths by Zapier
Filter by Zapier
04 / Workflow Breakdown / Zap 1
Invoice Intake & Processing
11 configured steps across new-invoice and duplicate-invoice paths. Intake records are checked, analyzed, and routed before CRM updates and Slack review notifications.
Shared intake & duplicate check
01Airtable — New Invoice Intake Trigger
02Airtable — Check Duplicate Invoice
03Paths by Zapier — Invoice Deduplication
New invoice path
04New Invoice Conditions
05AI by Zapier — Analyze Invoice Details
06Airtable — Create Invoice Record
07Airtable — Update Invoice Intake Tracking
08Slack — Notify Invoice Review
Duplicate invoice path
09Duplicate Invoice Conditions
10Airtable — Flag Duplicate Invoice
11Slack — Send Duplicate Alert
04 / Workflow Breakdown / Zap 2
Payment Status Tracking
Processes invoices marked Paid and manually Verified in Airtable. Stored CRM status controls confirmation emails and notifications; bank or payment processor transactions are not independently verified.
01Airtable — Invoice Payment Status Updated
02Filter by Zapier — Verify Payment Status
03Gmail — Send Payment Confirmation
04Slack — Notify Payment Received
05Airtable — Mark Payment Notification Sent
04 / Workflow Breakdown / Zap 3
Automated Payment Reminders
A daily schedule retrieves eligible invoices, loops through them, rechecks current state, generates and sends AI reminders, and updates counts and timestamps. Airtable formulas evaluate overdue status, reminder counts, and a 72-hour cooldown.
01Schedule by Zapier — Daily Trigger
02Airtable — Retrieve Eligible Invoices
03Looping by Zapier — Process Each Invoice
04Airtable — Recheck Current Invoice
05Filter by Zapier — Check Reminder Eligibility
06AI by Zapier — Generate Payment Reminder
07Gmail — Send Payment Reminder
08Formatter by Zapier — Increment Reminder Count
09Airtable — Update Reminder Tracking
10Formatter by Zapier — Format Reminder Timestamp
11Slack — Notify Payment Reminder Sent
05 / Key Capabilities
Invoice visibility and controlled follow-up.
Automated invoice intake
Duplicate invoice detection
AI-assisted invoice analysis
Centralized Airtable invoice database
Payment status and manual verification checks
Automated payment confirmation emails
Scheduled overdue invoice reminders
Multi-invoice looping
Reminder eligibility calculated through Airtable formulas
72-hour reminder cooldown
Reminder count and timestamp tracking
Slack review and payment notifications
06 / Verified Demonstration Outcomes
Tested with simulated invoices and payment information.
The documented workflow tests covered the following outcomes. These are portfolio demonstration results; no actual payment processing, independent payment verification, revenue improvements, collection rates, or time-saving statistics are claimed.
Successful invoice intake and duplicate routing tests
AI invoice analysis generated
Airtable invoice records created and updated
Payment confirmation notifications tested
Overdue reminder emails generated and sent
Reminder counts and timestamps updated
Slack notifications delivered
Multiple eligible invoices processed during reminder tests