The Google Sheets Function in On2Air Actions allows you to automatically create a new Google Sheets file and PDF document using data from your Airtable record. You can generate single page and multi-page documents that display a single record or list of records from your Airtable base. It will also upload the newly created file back into your Airtable base in an Attachment file.

**🔴 On2Air Docs has been shutdown to focus on our On2Air Backups Airtable app

Learn more about automated Airtable backups - on2air.com**

Function Type: Record Processing Functions - Google Functions

About the Google Sheets Function

With the Google Sheets Function in On2Air Actions, you can automatically generate Google Sheets files that contain your Airtable data.

You can create single page documents, multi-page documents, create documents with an entire list of Airtable records, or with a single Airtable record!

The basic way to set up your Google Sheets template is to use the {{Airtable Field Name}} placeholder in any cell you want your data displayed.

• The {{Airtable Field Name}} placeholder ****setup is most useful for creating a spreadsheet document per each Airtable record, where the spreadsheet will display field data from your Airtable records. This is useful whether you need a single file generated or multiple documents generated at one time that each contain data from their respective Airtable record.
• If you need to include multiple records on a single spreadsheet and/or you want to customize the formatting, you can use the {{table}} placeholder

The Google Sheets Function contains templates including: Tables, Formulas, Currency, Percent, Numbers, Dates, Images, Links, and Grids. This approach allows the most flexible templating system for Airtable. Use your data inside Google Sheets and customize it with dynamic formatting.