title: Custom Sheets script for template Sheet
body: <p>I've got a worksheet that we use to store specific data for each of our events (completed jobs for the business).  After every event, we copy the Google Sheet, and create a new one. However, in making a copy, of course, it retains all the data from which it was copied. Data like how much money that Job was, it's location, etc. Therefore, I've created a simple script to clear out specific cell ranges that will receive new job specific data. </p>
  
  <p>This data clearing script/button will only be used once, just after the new Sheet copy is made.</p>
  
  <p>However, my frustration is that every time I make a copy, the sheet asks me to re-authorize the script. I created and maintain these sheets, I wrote the script, I make the copies of the sheets, it shouldn't require me to constantly say "yes this is ok"</p>
  
  <ul>
  <li>Why am I constantly being asked to authorize? It takes longer to authorize than it does to clear all the cells. (which is saying something about how long it takes to authorize. </li>
  </ul>