Templater Pro extends Templater Rig by offering desktop automation, allowing you to render or replicate batches of versioned compositions using your data source. A recurring monthly subscription plan is available as well. Activating Templater Pro requires that Templater Rig already be installed and licensed.
https://aescripts.com/templater-pro-upfront/
Arron,
Unfortunately, the Google API doesn't give us the flexibility at the moment to swap between Google Sheets on the fly without manually switching between them in the Templater interface. However, there are a few methods that might be helpful when it comes to working with multiple Sheets simultaneously.
The first would be to perform a data merge within the Sheets to collate any entries from the various sheets into one "master" sheet that Templater could access. This would require some scripting work on the Google Sheets side but would, by far, be the most straightforward solution to the issue at hand.
Another potential solution would involve running Templater Bot through the command line interface (CLI) and swapping between Sheets using the templater-options.json files. Each time Templater is run through the CLI, it accesses a file called templater-options.json that contains configuration information that includes which Google Sheet to access. Although it would require a bit more work, it should be possible to write a script that would swap between sheets in the options file whenever Templater is run. You can find more information about running Templater through the command line interface in this article from our support website.
I'd recommend starting by taking a look at the data merge option since it's much more straightforward, but if you have any questions or if we can help in any way, let us know, and we'll do whatever we can to help get you up and running.
Thanks, and happy rendering!