Google Slides Function - Template Guide
________________

With the Google Slides Function, you can create custom templates inside Google Slides using your Airtable data. The Google Slides Function contains templates including: Tables, Text, Images, Links, YouTube Videos, Google Drive Videos, Charts from Google Sheets, and Grids. This approach allows the most flexible templating system for Airtable.

The templates use a syntax called Handlebars.

In this article

Airtable Configuration
Formatting Template Parameters

Template Types
Field Placeholder
Table
Text
Image
Link
YouTube/Video
Chart from Google Sheets
Grid

Advanced Options

_________________

Airtable Configuration

The easiest way to insert your data is to use Lookup fields in your base. Create a lookup field for each set of values you want from your base.

Example: You have a secondary table in your base called People with the primary field called Name. You have 3 records in the table. You have a record for Larry, a record for Mo, and a record for Curly. In your main table called Clients, you need to add a Lookup field that looks up the People table and the Name field. Once your template table is set up, each record will be inserted to a column.

Once you set up your Table source and a Lookup field, you can then reference any field from the secondary table in your base inside your template table in Google.

_________________

Formatting Template Parameters

To format the templates, add the template type name, then a space followed by an =. Finally, surround your data or formatting in parentheses.

Example:

{{date value="{{Airtable date field name}}" pattern="YYYY-MM-DD"}}

date - template type
value= - parameter
"{{Airtable date field name}}" - value




_________________

Templates
________________

Field Placeholder

{{Your Field Name}} - These are used to insert your data anywhere in the file. Wrap your data in 2 curly brackets.

_________________

Text

{{ text }} - add your data as text formatted inside a shape

Options:
field - your Airtable field name
value - add your Airtable field using brackets - ((Your Airtable Field Name}} or static text
keepShape - keep the shape that's used to hold the template - (i.e. - keep the box border) - "1" is default
useStyle - use the styles provided for the template text so you don't need to define the styles via parameters - "1" is default
Example: add your color, font size, and style to your Slides document - useStyle will keep these options

Example: {{text value=”{{Test.Chef1}} Here” keepShape=”1” useStyle=”1”}}



_________________

Table

You can create a table with different Airtable fields and types. Adds all data from a field or linked table and will generate a table

{{ table }}

To insert a table:
Add a shape for to contain your table
Add your parameters

Table Syntax

{{table source=" "}} - Insert your field name for the table column
{{table}} - Your table name in Airtable.

Example:

{{table source=”Template Data” fields=”Name|Age” columnWidth=”1” minRowHeight=”0.1”}}

Options:
fields="Field Name|Field Name" - your Airtable field names
columnWidths - set your column widths in inches
minRowHeight - set the minimum row height for your table



________________

Image

Insert images inside a shape

To use an image:
Create a shape in Slides
Insert the Airtable Field Name containing the Image in brackets
Example - {{Airtable Field Name}}

Example: {{Logo}}

Options:

________________

Link

This is used to insert your Airtable data as a link

{{link}}

Example:
{{link url="https://on2air.com" value="On2Air Website"}}
{{link url="https://on2air.com" value="{{Name}}"}}


Options:
url - add your static url or your Airtable field using {{ }} brackets
field - add your Airtable field name
value - add static text or your Airtable field using brackets to display your URL as text - ((Your Airtable Field Name}}

________________

YouTube/Video in Google Drive

Insert a video from YouTube or a video from your Google Drive

{{ video }}

To use a YouTube video:

- Add a shape for the size of video you want
- Add {{video value="YouTube ID"}} inside your shape
- Get your YouTube ID from the video. You can do this by getting the URL of the video and copying the data located after the v=
- Add the ID to your video value parameter



Example:` {{video value=”bTfghXpjZ5s”}}`

To use a video for Google Drive:

- Add a shape for the size of video you want
- Add {{video value="Google Drive URL or ID"}} inside your shape
- Get your Google Drive URL or ID from the URL. You can get the ID by getting the URL of the video and copying the ID as shown below
- Add the URL or ID to your video value parameter



Options:
value - insert your YouTube ID

________________

Chart from Google Sheets

Insert a dynamic or static chart from a Google Sheets document. You can have the chart automatically update when updated in Sheets or use it as a snapshot image of the chart.

{{ chart }}

To insert a chart:
Add a shape for the size of chart you want
Add {{chart sheet="Sheets file ID" value="Chart ID"}} inside your shape
Get your Google Sheets ID from your file. You can do this by getting the URL of the video and copying the ID as shown below
Get your Chart ID. You can do this by clicking the menu on the chart, choose Publish Chart, click Publish, and then click Embed
In the Embed code, copy the oid= ID
Add the ID to your value parameter
If you want the chart to be dynamic, you don't need to add any other parameters. Your chart will automatically update. If you want the chart to be static, add linked="0" to your parameters. This will automatically create a static image of your chart.

Google Sheets document ID



Chart ID



Example: {{chart sheet=”1PYIHKYmIBkJ_-a4SDsmWp7UsFCBhkvqI-Lo_qxfCSAc” value=”1076339859” linked=”0”}}
Options:
sheet - insert the ID of your Google Sheets document
value - insert the ID of the chart from your Google Sheets document
linked - determines whether to make the chart dynamic (always updated) or static (1-time snapshot)

________________

Grid

Adds all data from a field or linked table and will generate a flexible grid table

{{ grid }}

To insert a grid:
Add a shape for the size of the grid you want
Add your parameters

Options:
field - your Airtable field name
source - your Airtable table name
type - you can use text, number, image, and link. If you specify the type, you can format the cells as needed.
rowHeight - the height of your row
colWidth - the width of your column
padding - add padding to your grid
column - add padding to your columns
row - add padding to your rows
useShape - use the shape for each grid cell it creates

Example: {{grid source=”Template Data” type=”text” field=”Name” padding=”column: 0.1; row: 0.2” useShape=”1”}}

_____________________________

Advanced

Conditional Formatting

ifEq - only display when the data from this field is equal to a certain value. This parameter needs to be your Field Name in Airtable.
ifVal - only display if this value is present. This parameter needs to be a specific Value from the Field Name you chose.

Example: {{link field=”Record Link” ifEq=”Name” ifVal=”Client A”}}
Was this article helpful?
Cancel
Thank you!