1

I'm creating an add-on for Google Spreadsheets which has custom formulas (functions) that require the user's API keys to run. I'm wondering what is the best way to store the user's API keys everytime they use the add-on in a new spreadsheet.

This is an example workflow:

  1. User installs add-on in spreadsheet for the first time
  2. Prompt user for API key
  3. Store API key
  4. User can now use custom formula that calls the API with the stored API key
  5. User creates a new spreadsheet, and installs the add-on again.
  6. User can still use the custom formula that calls the API because the API key is stored in the add-on's storage

According to this https://developers.google.com/apps-script/guides/properties, it seems like the correct Properties Serivce is getUserProperties() but from testing, it doesn't seem like anything I add into the Properties Service persists across different spreadsheets.

Or should I be storing these API keys in an external database?

Rubén
  • 34,714
  • 9
  • 70
  • 166
Dave Sottimano
  • 1,324
  • 2
  • 10
  • 15
  • Userproperties do persist data for every user. Can we have snippet of your code so we can provide you more inputs. – Darpan Sanghavi Mar 30 '18 at 04:53
  • Related: [Handling persistent user-specific values in Gmail Add-ons](https://stackoverflow.com/q/48561117/1595451) – Rubén Mar 30 '18 at 05:56

0 Answers0