Select Page
Google Slides Function - Template Guide
Google Slides Function - Template Guide

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. This guide is for use with the

The templates use a syntax called Handlebars. You can create Simple or Complex templates.

  • *Simple Templates: **{{template-type options....}}
  • Complex templates with inner body: {{#template-type options...}} {{inner-types}} {{/template-type}}

In this article

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
image

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”}}

image

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

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}}

{{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
image

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
image

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

image

Chart ID

image

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”}}