We currently have a google sheets script add-on to help us prepare shipping addresses every month for our membership. It takes a CSV the divides the shipping addresses into tabs based on the membership type. It works great but we want to make a few small updates to to it:
1. add two new tabs based on two new plan types
2. add two fields to the add-on so it populates two columns in the spreadsheet based on the field before running
3. Currently the app requires authentication before each use, not sure if its possible but ideally it saves teh same authentication after authentication for google sheets access after the first time.
You will be asked to answer the following questions when submitting a proposal:
Do you have experience writing a google sheets add-on script? If so, briefly describe what it did.