I'm trying to hack together a paperless data-entry solution for my company using Google Sheets. Basically, our employees are required to fill out daily logs on paper. Needless to say, this is extremely wasteful and inefficient. I'd like to automate the process by doing the following:
- Manually create a Master Sheet with proper formatting, etc.
- Run a script that duplicates the said master sheet and places an editable copy in a separate folder on Google Drive once a day (at a specific time).
Ideally, each copy would have a timestamp of its creation in a cell somewhere, although this isn't absolutely needed.
I've looked all over the place and haven't found any scripts that do exactly this (the closest thing I found was a messy Zapier hack).
Does anyone know how I would go about doing this?
Any scripts laying around that do this?
If not, are there any resources you could point to that would allow me do figure it out myself?