New: E-Signature is now available →
← All Airtable templates

Airtable Ad Campaign Invoice Template

An invoice template for advertising campaigns: one line per deliverable with dates, unit cost and quantity, and your terms and conditions at the bottom. Filled from Airtable, generated as a PDF.

20 free documents · No credit card

Invoice with legal conditions template preview - Google Docs invoice template including terms and conditions from Airtable

The variables in this template

One table for invoices, one linked table for the deliverables. Map each variable to one of your fields in TypeFlow, or rename it in the Doc to your field name.

Invoice record

HoldsVariable in the template
Invoice numberInvoice_id #
Campaign nameCampaign Name
Client and contactclient, Contact, first Name, full_name
Vendor and activation ownerVendor, Activation Owner
QuarterQuarter
Datesdate, Date Generated
Booked totalbooked total
Accounts payable contactaccounts payable team

Deliverables (linked records)

HoldsVariable in the template
Deliverable and IDitem, DeliverableID Short
Flight datesStart, endt
Unit type, cost, quantityunit type, unit cost, unit qty
Currency and line pricecurrency, price

Each linked deliverable becomes one row of the invoice.

How it works

  1. 1

    Copy the template

    It opens in your Google Drive. Change the layout, fonts and logo like any document.

  2. 2

    Map your Airtable fields

    Pick your base and table in TypeFlow, then match each {{variable}} to a field.

  3. 3

    Generate from Airtable

    Click a button on the record or let an Airtable automation run it. The PDF lands in an attachment field.

Questions

Do I need a Google account?
Yes. The template is a Google Doc: you copy it to your Drive and edit it there. TypeFlow also has its own template builder if you prefer not to use Google.
How do the line items get into the table?
From a linked table in Airtable. TypeFlow repeats the table row once per linked record.
Can I change the terms and conditions?
Yes. They are plain text in the Google Doc: edit them once and every invoice uses the new version.

Full walkthrough: Airtable invoice automation

Generate your first campaign invoice from Airtable

20 free documents · No credit card

Airtable Ad Campaign Invoice Template | TypeFlow