How to Send Invoices Automatically from Airtable Using Gmail and ActiveMerge

You can automatically turn an Airtable invoice record into a personalized document and email it to the customer from your Gmail account with ActiveMerge.

The workflow is straightforward:

1. An invoice reaches a selected status in Airtable.
2. ActiveMerge detects the record.
3. ActiveMerge fills your invoice template with the Airtable data.
4. It generates one invoice for that record.
5. It creates a one-recipient campaign and attaches the invoice.
6. Gmail sends the personalized message through your connected Google account.
7. ActiveMerge updates the processing status in Airtable and records the email result in Campaigns.

This removes the repetitive work of exporting Airtable records, renaming PDFs, finding customer email addresses, and matching every invoice to the correct email.

What you need

Before starting, prepare:

• An Airtable base containing invoice and customer data
• An email field for the customer
• A single-select or text field that ActiveMerge can use as the automation status
• An invoice template saved in ActiveMerge
• A Gmail account connected to ActiveMerge
• A reusable email campaign template
• An active ActiveMerge plan or purchased credits for campaign delivery

ActiveMerge checks Airtable for matching records every 5, 15, 30, or 60 minutes. If you need an immediate trigger, you can also use an incoming ActiveMerge webhook from an Airtable automation, but scheduled checking is the simplest setup.

Recommended Airtable structure

Keep invoice-level data in one Invoices table. If invoices contain a variable number of products or services, keep those rows in a linked Invoice Items table.

Invoices table

Invoice Items table

The Delivery Status field is essential. ActiveMerge uses it both to find records that are ready and to mark records as processing, successful, or failed. Create this field in Airtable before saving the automation; ActiveMerge cannot create Airtable fields for you.

Step 1: Create the invoice template

Create the invoice in Microsoft Word and add placeholders where Airtable values should appear. You can create the invoice in Excel as well and save it as XLSX.

For example:

INVOICE {Invoice_Number}

Bill to: {Customer_Name}
Invoice date: {Invoice_Date}
Due date: {Due_Date}

Subtotal: {Subtotal}
Tax: {Tax}
Total due: {Total}

ActiveMerge uses {placeholders} in document templates. Airtable field names containing spaces are represented with underscores, so Customer Name becomes {Customer_Name}.

Upload the DOCX file to ActiveMerge and save it as a reusable template. During field mapping, connect each template placeholder to its matching Airtable field.

Add repeating invoice items

If each invoice has multiple products or services, place one placeholder row inside a Word table:

ActiveMerge repeats that row once for every linked item belonging to the invoice. In the field-mapping step, select the Invoice Items linked-record field as the line-item source.

Keep all {{item.*}} placeholders in the same table row. That row acts as the loop template.

Step 2: Connect Airtable to ActiveMerge

In ActiveMerge:

1. Start a new document generation job.
2. Choose Airtable as the data source.
3. Connect your Airtable account if it is not already connected.
4. Select the workspace, base, and Invoices table.
5. Select the saved invoice template.
6. Map Airtable fields to the document placeholders.
7. If applicable, select the linked Invoice Items field for repeating rows.
8. Choose PDF as the output format if customers should receive a fixed, client-ready invoice.

It is worth generating a preview with one test record before adding automatic email delivery. Check dates, currency formatting, totals, page breaks, and the line-item table carefully.

Step 3: Connect Gmail

Open Campaigns → Email Connections in ActiveMerge and choose Gmail.

Sign in to the Google account you want to send invoices from and approve the requested access. ActiveMerge uses the connected Gmail account as the sender; you do not need to create an app password or enter SMTP credentials for this route.

After connecting:

1. Confirm the expected Gmail address appears in Email Connections.
2. Send a connection test if that option is shown.
3. Set the Gmail connection as your default if it should be used for most campaigns.

Use a business address that customers recognize, such as billing@yourcompany.com. Replies will go through the connected account’s normal mailbox behavior.

Step 4: Create the invoice email template

Go to Campaigns → Email Templates and create a reusable template for invoice delivery.

Document templates and email templates use different placeholder formats:

Email placeholders must match the Airtable field names available to the automation.

Example email template

Template name: Customer invoice delivery

Subject: Invoice [Invoice Number] from Your Company

Body:

Hi [Customer Name],

Your invoice [Invoice Number] is attached.

Total due: [Total]
Due date: [Due Date]

If you have any questions, reply to this email and our billing team will help.

Thank you,
Your Company

Choose the connected Gmail account as the template’s default sending connection. ActiveMerge will validate the template fields against Airtable rows when the automation runs.

Step 5: Save the Airtable workflow as an automation

After selecting the invoice template, Airtable table, output format, and field mappings, choose Save as Automation.

Use settings such as:

The field names and status values are case-sensitive in practice, so enter them exactly as they appear in Airtable.

Why use Queued instead of Sent as the success value? The Airtable status is updated after ActiveMerge generates the invoice and creates the queued email campaign. Gmail delivery happens asynchronously after that. Use the ActiveMerge Campaigns dashboard—not the Airtable processing status—to confirm whether the recipient’s email was sent or failed.

Step 6: Test with one invoice

Do not activate the workflow on an entire invoice view first. Create a safe test record with an email address you control.

Before changing its status, verify that:

• The invoice number is unique
• The customer email is valid
• All required totals and dates are present
• Linked invoice items belong to the correct invoice
• The Gmail sender is connected and verified
• Every [Field Name] used by the email template exists in Airtable

Change Delivery Status to Ready to Send, then either wait for the configured check or run Check Now from the ActiveMerge Automations page.

The expected sequence is:

Ready to Send → Processing → Queued

Then open Campaigns and inspect the one-recipient campaign. Its recipient status should progress from pending or queued to sent. Also open the test mailbox and confirm:

• The sender is correct
• The subject placeholders were replaced
• The message formatting looks right
• The correct invoice is attached
• The PDF filename is clear
• The amount and due date match Airtable

Step 7: Put the automation into production

Once the test passes, move real invoices to Ready to Send only after they have been approved.

A reliable process usually separates financial approval from technical delivery:

Draft → Needs Approval → Ready to Send → Processing → Queued
                                               ↘ Failed

This keeps incomplete invoices out of the automation and makes failed records easy to filter in Airtable.

ActiveMerge marks matching records as Processing before generation, which helps prevent the same invoice from being picked up twice by overlapping checks. It also blocks invalid recipient emails, missing email-template fields, and duplicate recipient addresses within the same automation run before generating unsafe deliveries.

What happens after an invoice is queued?

ActiveMerge creates a separate one-recipient campaign for every automatically generated invoice. It then:

• Replaces email placeholders with that Airtable record’s values
• Verifies that the generated attachment belongs to the corresponding generation job
• Sends through the selected Gmail connection
• Applies sender-level rate limits
• Records the recipient as sent or failed
• Keeps already-sent recipients from being sent again during a failed-recipient retry

If an attachment is missing or cannot be verified, ActiveMerge does not send an attachment-free email. The recipient is marked as failed instead.

Handling failed invoice emails

A row can fail before or after invoice generation.

The Airtable row changes to Failed

This generally means the automation could not safely prepare the invoice or queue its campaign. Common causes include:

• Missing or invalid Customer Email
• An email template placeholder that does not exist in the source row
• Duplicate recipient email addresses in the same run
• Missing invoice template or Gmail connection
• Insufficient ActiveMerge credits
• A document-generation or Airtable API error

Correct the data, then change the Airtable record back to Ready to Send so it can be processed again.

The Airtable row says Queued, but the campaign failed

Open the campaign in ActiveMerge to see the recipient error. If the Gmail connection needs attention, reconnect or test it first. You can then retry the failed recipient from the campaign without emailing already-sent recipients again.

Do not simply change the Airtable record back to Ready to Send when the invoice was already generated and only Gmail delivery failed. That would create another document and another campaign. Use Retry failed recipients in Campaigns for a send-stage failure.

Gmail sending limits and deliverability

ActiveMerge queues and rate-limits campaign messages, but Gmail still controls the account’s daily sending limits, attachment limits, spam policies, and temporary restrictions.

For dependable invoice delivery:

• Send from a recognized business address
• Keep the subject direct and transactional
• Avoid URL shorteners and unnecessary promotional language
• Keep attachments reasonably small
• Maintain accurate customer email addresses
• Ask high-volume senders to confirm the limits of their Google Workspace account
• Monitor failed recipients in ActiveMerge

Campaigns records whether Gmail accepted the send request. It does not provide newsletter-style open or click tracking.

Manual batch sending versus automatic invoice delivery

ActiveMerge supports two useful invoice-email workflows.

Use a manual campaign when the finance team wants one final batch review. Use an Airtable automation when Ready to Send is already a trusted approval gate.

Frequently asked questions

Can Airtable send a generated invoice through Gmail by itself?

Airtable can run email automations, but it does not generate a personalized invoice from a Word template, expand linked line items into the document, safely match one generated file to one recipient, and track that attachment campaign as one built-in workflow. ActiveMerge handles those document and delivery steps while Airtable remains the source of invoice data and approval status.

Do I need Zapier or Make?

No. ActiveMerge can poll Airtable directly every 5, 15, 30, or 60 minutes and send the generated invoice through Gmail. Zapier, Make, or an Airtable webhook is optional if you want a different trigger architecture.

Can invoices include linked Airtable line items?

Yes. Link the invoice record to records in an Invoice Items table, select that linked field during mapping, and use one {{item.*}} row in the Word template. ActiveMerge expands it for the matching items.

Can I send the invoice as a PDF?

Yes. Select PDF as the automation’s output format. The generated PDF is attached to the personalized Gmail message.

Can the generated invoice be saved back to Airtable?

Yes. Select an Airtable URL or attachment field as the file destination during the source setup. ActiveMerge can write the generated file link back to the processed invoice record. You can also retain the file in ActiveMerge or save it to Dropbox.

Will customers see ActiveMerge as the sender?

The campaign is sent through the Gmail account connected to ActiveMerge. The recipient sees that account’s sender identity, subject, message, and attached invoice.

Does Queued mean Gmail delivered the email?

No. It means invoice generation succeeded and the email campaign was queued. Check the recipient status in ActiveMerge Campaigns to see whether Gmail sent the message or the send failed.

What happens if the invoice attachment is missing?

ActiveMerge does not send the email. It records the recipient as failed so you do not accidentally tell a customer that an invoice is attached when it is not.

Does ActiveMerge replace accounting software?

No. ActiveMerge generates and delivers invoices from Airtable data. It does not replace bookkeeping, tax reporting, payment reconciliation, a general ledger, or accounts-receivable accounting.

Start sending Airtable invoices through Gmail

With the initial setup complete, your team’s recurring action can be as small as changing one Airtable value to Ready to Send.

ActiveMerge handles document generation, personalized email content, attachment matching, Gmail queuing, and status reporting—while Airtable remains the place where your team prepares and approves every invoice.

CTA: Automate your Airtable invoices with ActiveMerge →

Related guides

• Automating document generation with Airtable
• Generating documents with repeating line items
• ActiveMerge Campaigns feature page
• Best automated invoice generators for Airtable