Questions, answers, and discussions about using Google Sheets as a Templater data source.

An error with code [ 3 ] ocurred when requesting information from a Google: ScriptError

@RobAranter Do you have any special characters in the title of your Google Sheet?

It could also be something to do with your Google Account, or with the authorization that Templater had previously retrieved. Can you try signing back into the problematic account in the Google Sheets Setup?

read more

Questions, answers, and discussions about using a local JSON object array as a Templater data source.

Nested JSON??

@Neil-González

It’s definitely going to depend on how the data is collected and what you’re trying to achieve. You could certainly render each worksheet individually and then combine them into a final master project, but you could also merge all of the data into one large sheet to create a ‘flat’ JSON file. That may allow you to combine the scenes without having to render or replicate the project multiple times. Instead, you could theoretically create sub-comps and then use the Time Sculpting features of Templater to resize the individual sections as necessary.

After looking at the data in your JSON example, you might consider a setup where you create a series of blank videos or comps of variable durations and then load them with the ‘duration’ data point. You could then use Time Sculpting to trim the image and text to that blank placeholder’s duration as needed. Again, a lot of this will depend on your setup, so if you have any specific questions, please just let us know.

As for your question about what version you need, it sounds like your setup will be best served by either the Pro or Bot version of Templater. If your final goal is full automation, Bot will probably be the way to go, but if you’re mainly looking to replicate and iterate large numbers of videos, Pro should be fine.

read more

Questions, answers, and discussions about using URL feeds as Templater data sources.

Authorise URL feed with API access token via Shell Script

Hey Ronan,

You have the ability to write a shell script on the “Pre-Data” event. See event [ 2a ] in our table of events that Templater broadcasts. In that script, you can run any commands needed to retrieve an API access token. Does this help?

For remote URL data sources, Templater supports Basic Authentication at the moment. How are you expecting to use the API access token once you retrieve it? Are you wanting to send it with request Templater makes? If so, I’m not sure that’s possible out of the box even with scripting. However, you should be able to get the API token via a shell script by registering it to the “Pre-Data” event.

Thanks,
Arie

read more

Questions, answers, and discussions about using Tabbed Separated Value files as a Templater data source.

Using Microsoft Excel

If your data is stored in Microsoft Excel, you will need to export it as a Tabbed Separated Value file—known as a TSV file.

With all the various Microsoft Excel releases, the steps to convert a worksheet to a TSV file vary between versions and operating systems.

Also, don’t forget that you may need to enable the “Tab delimited file exported from Excel or Numbers” checkbox within the Templater Preferences dialog to work with TSV data exported or saved from Microsoft Excel.

read more