Skip to main content
Question

Simple Monthly Invoicing for less than 10 clients

  • Oct 4, 2026 3:40 AM UTC
  • 9 replies
  • 195 views

Kelli Maree PA
Forum|alt.badge.img

Hello,

I’m new to Airtable and still learning, but the automations I’ve set up so far have already made my life much easier.

I’m currently stuck on setting up invoicing. I have three clients—A, B, and C—and each client is assigned a different services package. For example:

  • Client A: Package 1
  • Client B: Package 2
  • Client C: Package 3

The packages and their pricing can vary by client. I’d also like to include a discount field that I can adjust manually when needed, although discounts will only be used occasionally.

At the moment, I have the client details in one table and the services and pricing in another. All invoices need to be issued monthly on the 1st.

I’d like to automate the process of creating PDF invoices and sending them out. Could someone please advise me on the best way to set this up in Airtable?

Thank you, and apologies if my explanation isn’t clear.

9 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Oct 4, 2026 4:13 AM UTC

Just an FYI that Airtable doesn’t have the ability to generate PDF files, so you would need to turn to 3rd-party apps for that.

Here are a few popular 3rd-party apps for automatically generating documents from Airtable:

  1. DocsAutomator — creates Google Docs documents or PDF files.
  2. Typeflow — creates PDF files.
  3. DocuMint — creates PDF files.
  4. Make’s integrations — which can be integrated with any document-creation app or PDF-creation app of your choosing, such as PDFFiller or CraftMyPDF. You can even integrate something as simple as custom Microsoft Word documents.

    If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one way that you can instantly trigger a Make automation from Airtable.
  5. Fillout’s advanced forms for Airtable — Fillout lets you automatically generate custom PDF files from a form submission.

    I show off this feature on this Airtable podcast episode: Using Fillout to create an eSignature approval process with PDF file creation.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


TheTimeSavingCo
Forum|alt.badge.img+32

I’ve set up something here for you to check out!

The idea is to have an ‘Invoices’ table where each record represents a single Invoice to a Client.  Then we can populate it with an automation that runs once a month that looks for all of the active Clients, and for each of them, create one Invoice record:

And here’s the automation setup:

This way if we update the pricing of one of the Services it won’t affect any of the previous Invoices, does that make sense?

The ‘Invoices’ table would also have a field to let us key in Discounts, with a ‘Total’ formula field that outputs final value


For the PDF side of things, it depends on how complicated your invoices are, really

If the PDF has dynamic line items, then I’d recommend trying out DocsAutomator (https://www.docsautomator.co/) which costs $29 a month for 100 docs

If it’s a fairly simple PDF that doesn’t have dynamic line items, then I’ve actually had good results with using a Make scenario to create a Google Doc via a template and upload it as a PDF into the triggering record.  With <=10 Clients I think that’d fall within the free tier of Make too and so would cost you nothing

If you’re okay with a manual process of creating the PDFs then you could also try Fillout (https://www.fillout.com/) which generates PDFs for you.  If your workflow involves checking each invoice before finalizing it to be sent out this could work fine too, it’d involve you opening the form, ticking a checkbox and hitting submit to indicate that it’s finalized, and the PDF would then get created and uploaded into that Invoice automatically

 

 


Forum|alt.badge.img
  • Oct 5, 2026 7:02 PM UTC

Hey! You're closer than you think.

I'd set it up with three tables: Clients, Packages/Services, and Invoices. Each invoice record links to a client, and you use lookup fields to pull in their package and pricing. Add a Discount field you just leave blank unless you need it, then a formula field for the total, something like Subtotal minus Discount. Since the discount is usually empty it won't mess anything up.

 

For the actual invoice, use the Page Designer extension. You build the layout once with your logo, client info, line items, discount and total, and it fills in from whichever invoice record you pick, then you export it as a PDF. It's what I use for our packing slips and it works great.

https://support.airtable.com/articles/4670048293-page-designer-extension-overview

 

For the 1st of the month part, an Airtable automation with a scheduled trigger can create the invoice records for you. As far as I know Page Designer is still click-to-export though, so you'd select the records and export the PDFs yourself. If you want the PDF generated and emailed with zero clicks you'd need something like Zapier or Make on top of Airtable. I'd start with the manual export since it already saves a ton of time, and you can automate that last step later.

Happy to help with any piece of it!


Forum|alt.badge.img+12
  • Known Participant
  • Oct 10, 2026 7:49 AM UTC

Hi Kelli,

One thing nobody has covered: generating the PDF and sending it are two separate steps in most setups. The tool creates the file and drops it in an attachment field, then a second Airtable automation picks it up and emails the client. You asked about both halves and the replies so far only cover the first one, so it is worth checking how your chosen tool handles the send before you commit.

TypeFlow can generate the document and send it by email natively, in one step.
 


e2laurel
Forum|alt.badge.img+9
  • Known Participant
  • Oct 16, 2026 12:54 PM UTC

Hello! We do our client invoicing out of Airtable. We generate all our data in our base, then use Make to generate a PDF using a Google Spreadsheet template. You can then have it draft an email for you to review before sending, or it can send if immediately. Would be happy to help assist with this.


imvalerian
Forum|alt.badge.img
  • New Participant
  • Oct 18, 2026 7:12 AM UTC

Adding the piece that ties both halves together, since you want it fully hands off on the 1st:

  1. Keep Adam's setup: a scheduled automation on the 1st creates one Invoice record per active client. Copy the package price into the invoice instead of only looking it up, so old invoices never change when you edit pricing later.
  2. Send each new invoice record to Make (a webhook step, or Make's Airtable watch module). Make maps the invoice fields (client, package, price, discount, total, invoice number, due date) into a PDF template, gets the file back and writes it into an attachment field on that invoice.
  3. A second automation triggers when that attachment field is filled, emails the client with the PDF attached, then ticks a Sent checkbox so nothing goes out twice.

If you want to get the layout right first, the thirds.ai invoice generator is free and needs no sign up, and thirds.ai also has a Make integration for the monthly run.

(Disclosure: I'm connected to thirds.ai.)


chelij
Forum|alt.badge.img
  • Participating Frequently
  • Oct 21, 2026 2:29 PM UTC

Hi Kelli, for fewer than ten clients, I’d recommend Airtable + Make + Google Docs + Gmail. After setup, the monthly PDF generation and emailing can run automatically.

Here’s what each tool would do:

  1. Airtable — store clients, packages and invoices. Keep your Clients and Packages tables, then add an Invoices table with fields for invoice number, billing month, client, subtotal, discount, total and sent status.

  2. Google Docs — design the invoice template once. Create your layout with placeholders such as {{client_name}}, {{invoice_number}}, {{package}}, {{discount}} and {{total}}.

  3. Make + Airtable — prepare invoices automatically on the 1st. Schedule Make to find active clients and create one invoice per client and billing month. Copy the agreed price into the invoice so later price changes don’t affect older invoices. Check for an existing invoice first and skip any already sent. Here’s Make’s scheduling guide.

  4. Make + Google Docs — generate each PDF automatically. Make fills a copy of your Google Docs template using the Airtable invoice data, then exports the completed document as a PDF.

  5. Make + Gmail — email each invoice automatically. Make sends the PDF as an attachment to the client’s billing email address.

  6. Make + Google Drive + Airtable — save and track the invoice. Make saves the PDF in Google Drive, then records its link and sent date in Airtable.

For occasional discounts, you could add a “Next invoice discount” field to the client record. Make copies that value into the invoice and clears it after successful processing.

Make already has an Airtable → Google Docs → PDF email template you can adapt as a starting point.

At your volume, the free plan may be sufficient, depending on your workflow’s usage. Make pricing

Test with your own email address before enabling the monthly schedule.

Hope this helps!


billgrid
  • New Participant
  • Oct 22, 2026 3:57 AM UTC

Because you sometimes adjust discounts manually, I’d keep a review step in Adam’s setup: create the monthly invoice records, check the price and discount, then tick a ‘Ready to send’ checkbox. Require that checkbox, a PDF and ‘Sent’ unchecked before emailing, and mark it sent after the email succeeds.

 

That gives you a chance to enter the discount before the invoice goes out. I’d test with your own address first: one normal invoice, one discounted invoice, and regenerating an already-sent PDF. If sending must be fully automatic on the 1st, enter the discounts before that run.

 

Would a brief review of those three invoices work for you, or does sending need to be completely hands off?


shulhi
  • New Participant
  • Oct 23, 2026 11:12 AM UTC

Hi Kelli, one detail I’d add to Adam’s setup: because package prices can vary by client, keep the agreed rate with that client’s package assignment, then copy it into each monthly invoice. A lookup to the current package price could otherwise change older invoices when you update your rates.

For occasional discounts, you could use a ‘Next invoice discount’ field on the client record. Copy it into the new invoice and clear it only after that invoice is created successfully, so it doesn’t accidentally carry over to the following month.

For the PDF step, ShipPDF is another option: you can map Airtable fields and linked line items into a reusable template and attach the generated PDF back to the invoice record. I work on ShipPDF, for transparency. Its native Airtable action is run manually; for fully automatic generation and emailing on the 1st, you’d use a workflow through Make.

With three clients, I’d test one normal invoice and one discounted invoice using your own email address before switching on the monthly schedule.