Bot, and working with Multiple Worksheets

[jkdc2020]

Hi,

I’m starting a project and wondering if there’s any way that I might be able to get away with segmenting my data into multiple worksheet tabs within one google spreadsheet.

Is there any way for Templater Bot to run through each sub-sheet one-by-one by selecting a master sheet?

Alternatively, can bot be set up to watch many different sheets at once for changes?

Or…does all data have to be located in one massive sheet?

Thanks for any help with this question!

[Jeff]

Hello,

Templater Bot cannot watch multiple sheets simultaneously or switch between sheets once loaded. When you load the sheet data into Templater you’ll pick a worksheet from your data source. The only way to switch that is going to be to reload Templater and choose a different sheet.

When it comes to the sort of flexibility you’re describing, you may consider working with a JSON data source instead of a Google Sheet. A JSON file, hosted either locally or remotely, has a great deal of flexibility when it comes to the data in each entry and may work better than a single large spreadsheet. You can check out more information about using a JSON file as a data source here.

If there’s anything else we can help you with, please just let us know.

Thanks,

Jeff