Using Templater > Data Source > Google Sheets Documents > Setting up a Google Sheet as a Data Source

Setting up a Google Sheets Document as a Data Source

Follow these steps to set up a Google Sheets spreadsheet for use as a Templater data source.

  1. Create a spreadsheet using Google Sheets.
  2. When setting up your spreadsheet, ensure that the name of each dynamic layer within the project file corresponds to a column name in your spreadsheet.

    WARNING  For Google Sheets documents, Templater does not currently support column names that begin with a numeral, contain spaces, or contain underscores. Avoid these characters to ensure spreadsheet data will map to your layers.

    WARNING  There are reserved column names that you should avoid using when naming dynamic layers in your compositions.  Using reserved column names can cause errors when Templater processes your data source. See Reserved Column Names to learn which labels to avoid.

  3. Depending on the dynamic layer's type, enter text, paths or URLs to footage sources, or hex color values into rows under corresponding columns. Local footage references should be relative to the path specified in the Footage folder field in the Templater panel under Batch Assets.

NOTE   Due to changes in Google Sheets API, Templater Bot only supports Google Sheets documents created in 2014 or later.