# \[10.0.0 - version 52\] GESI - Google Sheets ESI Add-On - Now an EVE Online Partner! **URL:** \ **Category:** Third Party Developers\ **Tags:** esi, tool\ **Created:** [August 3, 2017, 10:59pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406 "2017-08-03T22:59:11Z")\ **Posts on this page:** 20\ **Page:** 3
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [December 30, 2017, 5:38pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/41 "2017-12-30T17:38:06Z")
**3.3.0** December 30, 2017 * * * ### New Features - Add allianceContact function. ### Bug Fixes - Fix `Reference does not exist` bug on various endpoints again. * * * ### New Required Scopes - Reauth will be required to use related functions ``` esi-alliances.read_contacts.v1 ``` ---
**Author:** ![C-137](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/c-137/32/146166_2.png) [@C-137](https://forums.eveonline.com/u/C-137)\ **Post date:** [January 31, 2018, 1:21am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/42 "2018-01-31T01:21:31Z")
I regularly find myself using your script, so I feel obligated to help improve it. The Name Lookup functions are all currently broken and my HTML POST + JS skills are failing me. The new /universe/names/ endpoint should be added as well (basically a typeless version of the other ones you already have). Also I personally would suggest having an option to get all pages ( ‘do while page \<= x-page’) that you can trigger with some kind of option (maybe ‘page = -1’) or something. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [January 31, 2018, 1:25am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/43 "2018-01-31T01:25:56Z")
> [@C-137](#): > > The Name Lookup functions are all currently broken and my HTML POST + JS skills are failing me. I just tried the `allianceNames` and `corporationNames` endpoints and they seem to be fine? EDIT: As to the `return all pages` requests i get. I been debating this for a while. I would rather keep it to just single pages since that is how ESI does it. If the user wants to edit it to return all pages they are free to. I do not want it to have to get EVERY page every time since I am not really familiar with the request quotas/limits on google sheets. ---
**Author:** ![C-137](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/c-137/32/146166_2.png) [@C-137](https://forums.eveonline.com/u/C-137)\ **Post date:** [February 2, 2018, 12:00am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/44 "2018-02-02T00:00:38Z")
Hmm crazy. I just re-copied the script minus the auth stuff, and it worked. No idea where mine stopped working, it was a direct copy paste from only the day before hah. Thanks again. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [February 2, 2018, 3:06am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/45 "2018-02-02T03:06:24Z")
There are excellent and easily defensible reasons for your design decisions and nearly as persuasive reasons for “pull all of it.” The author calls the shots! It’s a great piece of work, either way. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [February 3, 2018, 3:33pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/46 "2018-02-03T15:33:19Z")
I’ve got four characters on two paid accounts and I’m unable to authorize just one of them. What have I overlooked? Account 1 Alt 1 / in-corp - successful authorization Alt 2 / NPC - successful authorization Alt 3 / in-corp - UNSUCCESSFUL authorization Account 2 Alt 1 - in-corp - successful authorization CHARACTERS = [ { // Account 1 character\_name: ‘Alt 1’, corporation\_id: 888888 }, { character\_name: ‘Alt 2’ }, { character\_name: ‘Alt 3’, corporation\_id: 888888 }, // Account 2 { character\_name: ‘Alt 4’,corporation\_id: 888888 } ]; AUTHING\_CHARACTER = CHARACTERS[0]; AUTHING\_CHARACTER = CHARACTERS[1]; AUTHING\_CHARACTER = CHARACTERS[2]; AUTHING\_CHARACTER = CHARACTERS[3]; ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [February 3, 2018, 3:34pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/47 "2018-02-03T15:34:44Z")
🤷‍♂️ Are there any errors or messages? ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [February 3, 2018, 3:36pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/48 "2018-02-03T15:36:33Z")
Access not granted or expired line 363 Note that when I added the NPC alt in Account 1 I did not do anything in the sheet except refresh. I do _not_ see the “reauth” menu item in Sheets. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [February 3, 2018, 3:41pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/49 "2018-02-03T15:41:50Z")
Off the top of my head i dont really know. There isn’t a reauth option. You just set `AUTHING_CHARACTER` to the one you want to auth and just click `authorize sheet` in the drop down. It will override the auth details for that char. Otherwise, make sure you added the corporation\_id field, make sure accounts are subbed. That error happens because that char you are trying to use isnt authed. Are there any error messages you get when you try to auth it? ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [February 3, 2018, 3:44pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/50 "2018-02-03T15:44:59Z")
I think you’re on to something. I no longer see the “authorize sheet” in a drop down…or I’ve forgotten where it is in the menu structure. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [February 3, 2018, 3:45pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/51 "2018-02-03T15:45:49Z")
![image](https://global.discourse-cdn.com/eveonline/original/3X/6/7/67cca6a0ba9c90a77e56eae0e31e777411c91a95.png) If you dont have that dropdown, is a good clue. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [February 3, 2018, 3:48pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/52 "2018-02-03T15:48:13Z")
Where your GESI item should be I’ve got the “GCES” “check for updates” button. ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [February 3, 2018, 3:52pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/53 "2018-02-03T15:52:48Z")
It seems his button overrides mine. I’ll do some testing to fix that. For now you can find the `onOpen` function in the GCES script and comment it out. Then refresh. ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [February 3, 2018, 4:04pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/54 "2018-02-03T16:04:49Z")
Industrialist Tip of the Hat ™ to you ---
**Author:** ![Cixi](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/cixi/32/262198_2.png) [@Cixi](https://forums.eveonline.com/u/Cixi)\ **Post date:** [February 3, 2018, 10:55pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/55 "2018-02-03T22:55:06Z")
Hello there, I found this lib and I’m fairly impressed, I didn’t know google proposed a callback url service you could configure with a script. I installed it and everything worked just fine. I had few questions : - Why do you want the corporation ID ? the “/characters/{character\_id}/” interface deliver that information - Where do you store the refresh token ? do you have to reauth your character everytime you want to use the sheet ? anyway, great work and thanks for sharing ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [February 4, 2018, 3:55am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/56 "2018-02-04T03:55:38Z")
@Cixi Thanks! Good to hear. 1. It is so that you do not have to manually add your corporation\_id to the function call. Similar to how you do not have to input your character\_id in the character endpoints. 2. AFAIK the Google OAuth2 script handles all of that, i.e. refreshing the token when expired and such. Going to have an update in next few weeks to address some issues with the auth process, so stay tuned! ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [February 11, 2018, 5:48am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/57 "2018-02-11T05:48:47Z")
**4.0.0** February 11, 2018 * * * # New Features Version 4.0.0 brings massive changes to GESI with the two major goals of making it easier to maintain while providing more functionality to the end users. This change includes a complete rewrite the script, removal of the Oauth2 Google Script as a requirement, and finally, the functions/endpoints code is now all generated from the ESI swagger.json definition file vs being manually maintained. Version 4.0.0 includes: - Includes ALL GET ESI requests and all scopes - Language support on supported ESI endpoints - Better handling of tokens, reduces external requests by a lot - Much easier to add/update endpoints resulting in faster updates - Support for non-sheet owners to auth and use the script. # BREAKING CHANGES - Function names are now snake case vs camelCase - Endpoints and functions are now in their own files - Column names are now snake case - JSON structure of each endpoint has changed - CHARACTERS array has changed again to array of character names - Will need to reauth to make use of new auth flow and for the new scopes As usual any issues please create an issue on the Github repo and let me know. Any questions feel free to get in touch or drop a comment on the EVEO forums. Smoke ---
**Author:** ![KenFlorian](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kenflorian/32/449998_2.png) [@KenFlorian](https://forums.eveonline.com/u/KenFlorian)\ **Post date:** [February 11, 2018, 10:28pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/58 "2018-02-11T22:28:15Z")
Sorry, I can’t resist, “holy Smoke.” This is great to have it all in one place! ---
**Author:** ![Francis\_Y\_Morgan](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/francis_y_morgan/32/51916_2.png) [@Francis\_Y\_Morgan](https://forums.eveonline.com/u/Francis_Y_Morgan)\ **Post date:** [February 13, 2018, 11:34am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/59 "2018-02-13T11:34:39Z")
Hello, can you please explain how I can add Corp Member to the Sheet? I added the name in the CHARACTER array and I added another AUTHING\_CHARACTER in the script. Every time my corpmate clicked on the auth link he get an error as result. Is it basically possible to add characters in this way or where is my mistake? thx Franics ---
**Author:** ![Blacksmoke16](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/blacksmoke16/32/376589_2.png) [@Blacksmoke16](https://forums.eveonline.com/u/Blacksmoke16)\ **Post date:** [February 13, 2018, 4:35pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/60 "2018-02-13T16:35:48Z")
> [@Francis\_Y\_Morgan](#): > > I added the name in the CHARACTER array and I added another AUTHING\_CHARACTER in the script. This is your issue. You should not add another `AUTHING_CHARACTER` variable into the script. What you need to do is like this: - You have the character names in the `CHARACTERS` array like `CHARACTERS = ['character1', 'character2', 'character3'];` - AUTHING\_CHARACTER is like `AUTHING_CHARACTER = CHARACTERS[0];` - When you click `Authorize Sheet` in the GESI dropdown this would generate a link and after the SSO process would auth character1. - To auth character two you would add one (1) to the number in brackets. so that AUTHING\_CHARACTER is like `AUTHING_CHARACTER = CHARACTERS[1];` - Then click `Authorize Sheet` in the GESI dropdown again to generate a link and after the SSO process would auth character2. - Repeat for same process for character3 of adding 1 to number in brackets and going thru auth flow again. After you finished authing all of your characters, it is important to know that AUTHING\_CHARCTER also acts as your ‘main’ character, meaning if you call a function like `characters_character_assets` without the name parameter, it will default to whatever `AUTHING_CHARCTER` is set to. [Previous page](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406.md?page=2) [Next page](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406.md?page=4)