Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

New On2Air Update: Airtable & Google Docs Templating Together at Last!

cancel
Showing results for 
Search instead for 
Did you mean: 
openside
10 - Mercury
10 - Mercury

Here’s the big Google/On2Air/Airtable update you’ve been waiting for!

We now have multiple Google Functions in On2Air Actions to bring Airtable & Google Docs together at last!

With the functions, you can now automatically create new or templated files in Google Docs, Google Slides, and Google Sheets using your Airtable data!!

PLUS, if needed, you can create custom, dynamic tables inside Google Docs, Sheets, and Slides. A table will be generated each time based on the exact size needed to fit your Airtable data.

e817c5fb84d9c509fd7ee22759a81de25d68f424.gif

0d3f0015a4f7eaf75565621ea45e5cae06b0d8e8.png

Here are the big updates:

  1. You can automatically create files in Google Docs, Google Sheets, or Google Slides using the data you have stored in your Airtable records with our new Google Functions.

2. You can now generate custom templates and tables in your documents that expand with your data in Airtable. The table is dynamically generated based on the exact size you need to fit your data. (See our Google Table Template Guide)

3. You can create new folders in Drive and store the URL of the folder or the file in an Airtable field.

4. You can send entire Airtable tables to a table in Google Sheets with our Google Table Sync Function.

5. Generate any file into a PDF, Image, Word document, Excel file, or PowerPoint file, then save it back into an Attachment field in Airtable. (This allows you to replace alternatives such as Page Designer, Formstack, Docupilot, and more!)

  1. When you combine these new Google Functions with our On2Air: Amplify app, your new file (the actual Doc, Sheet, or Slide) will be automatically displayed inside your Airtable base for editing and viewing.

0543497fcd188e924f308f19d1f9ba0505fefb02.gif

Start a free 14-day trial of Google Functions

:boom: You can use these new features for a variety of use-cases!

  • Generate sales invoices and legal contracts

  • Sync data and generate dynamic charts in Sheets

  • Copy a template folder with all template files for each new account or client

  • Create marketing materials

  • Design templated or custom proposals for potential new clients

  • Create presentations to kickstart new projects

  • Distribute Quarterly reports using a combination of Sheets, Slides, and Docs

  • Turn any record(s) in Airtable into a custom document

  • Ensure company-wide branding assets to maintain consistency

  • Dynamically personalize every document created

This is a game-changer for collaborating in Google Drive and Airtable. You don’t have to bounce between Drive and Airtable anymore.

It’s a Complete Document Management System. Manage your entire Google Docs environment inside of Airtable.

a366a239577e2c8c56ea78546b5a739769717d37.gif

783bd23d6a3b7ba152abf01bf49aba80abbc934d.gif

Google Function features:

  • Create new or templated files in Google Docs, Sheets, or Slides
  • Automatically generate custom tables in your documents that fit your data
  • Create new folders in Google Drive
  • Send entire Airtable tables to a Google Sheets table
  • Insert data from your Airtable records directly into any file
  • Create dynamic files based on unique values in your records (ex: single-select options)
  • Save newly created files all in one folder or in various folder based on unique values
  • Generate PDF, Image, Word, Excel, or PowerPoint files and save back to Airtable
  • Save the URL of newly created merged file in a field in your Airtable base
  • Export the file and save in an Attachments field in your base
  • Use the basic or shared Google Drive accounts
  • If you have Amplify, you can edit and view any Google file inside of Airtable

:timer_clock: We also added a new Scheduler feature to all our Functions

With the Scheduler, you can choose how often you want your Function to run. Choose instant updates or specific minutes, hours, days of the week, days of the month, and time zone.

With the scheduler, you no longer have to rely on Zapier or other service to process your Function on a pre-set schedule.

db457acc63f46c1f72c8675f73da0bdbd7476a24.gif

What are Functions?

Functions are no-code pre-made tasks for your bases, tables, and records in Airtable

046541a1f88e396abc8a79d761c2e257c257fd28.jpeg

With pre-made functions, you can perform a variety of tasks on your Airtable data. You can convert URLs into Attachments to store in your Attachment field, copy fields automatically, create default values for any field, import data from a URL into a table, calculate simple and complex financial equations, and much more.

You can see all the available Functions on our website.

How to Get Google Functions

New users start with a 14-day free trial, so go create a Google Doc, Sheet, Slide, or Drive folder today!

If you’re a current On2Air customer on a bundled plan, you have Functions already! Log in to your On2Air account.

3 Comments
Bill_French
17 - Neptune
17 - Neptune

Curious - there’s a long-standing bug in Airtable documented here and here . that affect lots of automated processes from reliably uploading attachments into Airtable using the API. Is this not an issue and if not, care to provide the secret that manages to sustain a reliable process?

openside
10 - Mercury
10 - Mercury

7ff086dbe9b34da68b3a7d1ef9e8531b53229d13.gif

openside
10 - Mercury
10 - Mercury

Hey Bill - on serious note - we actually haven’t run into it yet, but something we’ll keep our eyes out for.