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

Utilize multiple sheets within 1 Google sheet?

@dwalters Definitely watch out for the formulas in Sheets when using Bot. Also, you can use a local JSON formatted file to avoid that issue and to gain some flexibility in how your data is structured. In a JSON file, each “object” can have different properties so you’re not locked down to a two-dimensional data structure like an array. You can use the aep property to have Templater load the correct project file for that asset. So the JSON source might look something like:

[ { "aep" : "C:\\templates\\summary.aep" , "score": "43" , "time": "1 hour" }, { "aep": "C:\\templates\\team-stats.aep" ,"player-count": "22" ,"team-name": "Longhorns" ,"city": "Austin, Texas" } ]

So you can see there are two “jobs” in the data souce, but from job-to-job there are different properties. Google Sheets is easy, but you do gain some flexibility using JSON.

read more

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

Dynamic Color through json

@Jon Thanks that was very helpful. Appreciate!

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