So I am trying to setup something for our community in order to track any potential Covid exposures.
Each week we have an unknown number of events (1+N), I am currently able to create a spreadsheet from a template for each event using the X number of Days before event start in google calendar.
What I would like to do instead, is create a single spreadsheet with 1+N workbooks, named for the event in question, per week.
As I understand it right now, I dont see a way to:
- name the workbooks
- pull ALL events in a given week (I can pull the first one that matches a search criteria, but then the system stops there)
Open to any suggestions but more or less the only tools I have access to is GSheets and GCal for this :(