Automatically create invoices (or any doc) in Google Docs using Airtable data

[Hannah_Wiginton]

Hey there!

Do you use both Airtable and Google Drive?

• Yep, every single day
• Eh, sometimes
• Nope

0 voters

I wanted to show you how you can automatically create invoices (or any document) in Google Docs using data from your Airtable base.

:point_down: :point_down: :point_down: see video

This uses the On2Air Actions app - Google Docs Function. The Google Docs function allows you to automatically generate documents in Docs from any data you have in Airtable.

1. Copy the free Invoice Google Docs template and the Sales Base Airtable template
2. Set up the automation in On2Air using the settings from the article/video (you only have to do this part 1 time)
3. Click Generate Invoice in your base
4. View your newly created invoice in Google Drive and a PDF version in your attachments field in your Airtable base!

---

View all the steps in this article or watch the video -

On2Air | Accomplish Anything with Airtable – 27 Sep 21

Automated Invoice Templates in Google Docs and Airtable (+Free Template) |...

In this guide, we’ll show you how to generate invoices using Google Docs plus how your can use your customer data in Airtable to automatically generate an invoice in Google Docs.

You can do a 14-day free trial of On2Air to test this with your data.

Plus, once you generate the Doc, you can edit the actual document inside of Airtable using the On2Air Amplify app (edited) :star_struck: