Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

491 0
Showing results for 
Search instead for 
Did you mean: 

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 -

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:

0 Replies 0