Bulk Invoice Generator

Bulk Invoices Generator is a powerful Google Sheets™ and Google Docs™ add-on that creates fully personalized invoices in bulk from spreadsheet data. Using dynamic merge fields and professional Google Docs™ templates, it can generate PDF or Docs invoices, send them by email, and automatically write status updates back to your sheet — all with smart filtering and automation controls.

Designed for freelancers, accountants, agencies, finance teams, and growing businesses, it transforms structured spreadsheet data into ready-to-send invoices with enterprise-safe processing and audit-friendly tracking.

Key Features

Template-Based Invoice Generation

Create invoices using a Google Docs™ template with dynamic {{mergeFields}}.

Bulk Invoices Generator can:

• Detect and extract merge fields directly from your template

• Replace fields with matching Google Sheets™ column values

• Insert content at the cursor inside Google Docs™

• Support duplicate column names safely

• Generate either:

  • Google Docs™ files

  • PDF invoices

Result: Every row in your sheet becomes a professionally formatted invoice.

PDF Export & Automatic File Management

When generating invoices as PDF:

• Automatically copies your template

• Merges data using the Google Docs™ API

• Exports clean PDF files

• Creates a timestamped output folder in Google Drive™

• Safely removes temporary files

You get organized invoice runs with one folder per execution — clean and structured.

Email Invoices with Attachments

Send invoices directly from your spreadsheet.

The add-on can:

• Generate invoice PDFs on the fly

• Send personalized emails using Gmail™

• Dynamically merge subject lines and email bodies

• Attach the generated invoice automatically

• Support TEST mode (send only to yourself first)

• Write delivery status back to the sheet

Result: Fully automated invoice distribution with built-in tracking.

Smart Row Selection & Conditional Processing

Control exactly which invoices are generated.

Supported filters include:

• All rows  

• Last row only  

• Manual row selection  

• Custom row ranges  

• Conditional logic  

Condition rules support:

• Equals / Not Equals  

• Contains  

• Is Empty / Is Not Empty  

• Greater Than / Less Than  

• AND / OR matching logic  

Example:  

“Only generate invoices where Status equals Approved and Amount is greater than 0.”

Automatic Status Columns

The add-on automatically:

• Creates dedicated status columns when needed  

• Prevents duplicate invoice generation  

• Skips rows already marked as processed  

• Writes invoice file links directly into the sheet  

This ensures safe re-runs and clear audit trails.

Long-Running Job Processing

Built for large invoice batches.

Bulk Invoices Generator includes:

• Background processing via time-based triggers  

• Safe job locking to prevent duplicate runs  

• Stop Job functionality  

• Hourly continuation for large datasets  

• Per-user job isolation  

Even thousands of invoices can be processed safely.

Multi-User & Google Workspace™ Safe

Designed for real-world collaboration:

• Per-user configuration storage  

• Protection against multi-account conflicts  

• Compatible with shared spreadsheets  

• Safe execution across Google Workspace™ domains  

Each user’s configuration is isolated and secure.

Error Handling & Diagnostics

Enterprise-ready reliability:

• Automatic error logging per row  

• Clear ERROR status written back to the sheet  

• Optional debug log submission  

• Fatal error email notifications with stack traces  

• Direct links to spreadsheet, sheet tab, and template  

You always know what happened and where.

Easy Configuration Interface

Clean sidebar configuration inside:

• Google Sheets™  

• Google Docs™  

Features include:

• Template selection  

• Spreadsheet selection  

• Merge field preview  

• Filter setup  

• Email configuration  

• Output mode selection (PDF or Docs)  

• Safe configuration reset  

Everything is guided and visual — no scripting required.

Perfect For

• Freelancers issuing monthly invoices  

• Agencies billing multiple clients  

• Subscription-based businesses  

• Accounting and bookkeeping teams  

• HR reimbursements  

• Purchase orders and payment requests  

• Educational institutions  

• Internal finance workflows