Authorizing Access to Your Google Sheets Documents

Once you have authorized Templater to access your Google Sheets documents, Templater remains signed into your Google Drive account. If your After Effects preferences are reset, you will need to grant Templater access to your account again.

WARNING  As of October 3, 2022, versions of Templater prior to 3.1.0 will no longer function with Google Sheets due to Google retiring an deprecated user authorization flow. You will need to reauthorize Templater to access your Google data after updating to the latest version.

Follow these steps to let Templater access your Google Sheets:

1. In the Templater panel, under Batch Assets, click the Google Drive icon.
2. In the Google Spreadsheet Setup dialog, click Sign In.
3. In the browser window that appears, log in to your desired Google Drive account.
4. To permit Templater to access your Google Sheets, click Allow. The browser will be redirected to a confirmation screen.
5. Switch back to Templater and click Authorize.
6. Ensure that a list of Google Sheets associated with your accounts loads in the Google Spreadsheet Setup dialog.
7. To link your After Effects project to a specific worksheet, see Linking a Google Sheets Document to Your AE Project.