I'm trying to figure out how to automatically create a templated Google sheets worksheet when a new entry is made in a different sheet.So the flow would be:Person's name is added into Google sheet A, along with data point XThis automatically creates a new Google sheet BGoogle sheet B is already pre-populated from a template with a few data points. It is automatically also populated with Person's name and data point XI haven't been able to find solutions that include the pre-population. Any examples I could draw on? Is Google add-ons a good approach here?
How to automatically create a templated Google sheet?
google spreadsheets;google apps script;google sheets addons