# \[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:** 12
**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:** [April 19, 2020, 8:43pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/228 "2020-04-19T20:43:18Z")
There is not. If its not possible via [ESI](https://esi.evetech.net/ui/) then it’s not possible in GESI. ---
**Author:** ![Deollyn\_Dulcatsil](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/deollyn_dulcatsil/32/198797_2.png) [@Deollyn\_Dulcatsil](https://forums.eveonline.com/u/Deollyn_Dulcatsil)\ **Post date:** [April 20, 2020, 8:35am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/229 "2020-04-20T08:35:10Z")
Thanks, that helps a lot. Great work on this, thanks for all your work. ---
**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:** [April 21, 2020, 11:09pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/230 "2020-04-21T23:09:05Z")
**8.0.0 aka version 23** April 21, 2020 * * * > **[Blacksmoke16/GESI](https://github.com/Blacksmoke16/GESI/releases/tag/8.0.0)** > > Google Sheets ESI Add-on. Contribute to Blacksmoke16/GESI development by creating an account on GitHub. Version `8.0.0` is now released. See the Github release for details. As always feel free to stop by the Discord server to report any issues or ask for help. ---
**Author:** ![rayman500](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/rayman500/32/251850_2.png) [@rayman500](https://forums.eveonline.com/u/rayman500)\ **Post date:** [April 24, 2020, 9:16am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/231 "2020-04-24T09:16:11Z")
Hi I am unable to Authorise my character in my sheet anymore it was working fine last week. when I type a formula I get the error: Access not granted or expired (line 454) I have tried recreating new sheets an am getting the same error. have you had this problem? (also I am using a Mac if that matters?) ---
**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:** [April 24, 2020, 12:59pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/232 "2020-04-24T12:59:12Z")
Did you reauthorize your character? This release changed how auth is stored so will need to redo it. ---
**Author:** ![rayman500](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/rayman500/32/251850_2.png) [@rayman500](https://forums.eveonline.com/u/rayman500)\ **Post date:** [April 24, 2020, 3:31pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/233 "2020-04-24T15:31:56Z")
Yeah I have tried a couple of times. I also tried de-authorize and re authorising but that did not help. I can only get the Eve log in to work if I open in a new tab? ---
**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:** [April 24, 2020, 4:07pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/234 "2020-04-24T16:07:02Z")
> [@rayman500](#): > > Yeah I have tried a couple of times. And you get to the end where it says “Thank you for using GESI xxx”? Some things to try: 1. Make sure GESI library is up to date if you’re using custom functions and such in the script editor 2. The `page` param got removed, so anyplace you were including a `-1`, remove it. 3. If none of these help, stop by the discord server and we can figure it out. > [@rayman500](#): > > I can only get the Eve log in to work if I open in a new tab? If you’re using Firefox then yea, i added a note to the modal to say that. ---
**Author:** ![rayman500](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/rayman500/32/251850_2.png) [@rayman500](https://forums.eveonline.com/u/rayman500)\ **Post date:** [April 27, 2020, 8:32am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/235 "2020-04-27T08:32:45Z")
> [@Blacksmoke16](#): > > The `page` param got removed, so anyplace you were including a `-1` , remove it. this was the problem I just needed to remove the “-1” Thanks a lot you are always very helpful. love the GESI! Ray ---
**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:** [April 30, 2020, 1:15am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/236 "2020-04-30T01:15:07Z")
**8.1.0 aka version 24** April 28, 2020 * * * > **[Blacksmoke16/GESI](https://github.com/Blacksmoke16/GESI/releases/tag/8.1.0)** > > Google Sheets ESI Add-on. Contribute to Blacksmoke16/GESI development by creating an account on GitHub. Version `8.1.0` is now released. See the Github release for details. As always feel free to stop by the Discord server to report any issues or ask for help. ---
**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:** [May 10, 2020, 1:41am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/237 "2020-05-10T01:41:22Z")
**8.2.0 aka version 25** May 9, 2020 * * * > **[Blacksmoke16/GESI](https://github.com/Blacksmoke16/GESI/releases/tag/8.2.0)** > > Google Sheets ESI Add-on. Contribute to Blacksmoke16/GESI development by creating an account on GitHub. Version `8.2.0` is now released. See the Github release for details. As always feel free to stop by the [Discord](https://discordapp.com/invite/eEAH2et) server to report any issues or ask for help. ---
**Author:** ![Charismik](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/charismik/32/244389_2.png) [@Charismik](https://forums.eveonline.com/u/Charismik)\ **Post date:** [June 10, 2020, 9:08pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/238 "2020-06-10T21:08:47Z")
@Blacksmoke16 Just in case you are not aware of, oauth is broken. Do you have any plans fixing it, can’t wait to start using it! ---
**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:** [June 10, 2020, 9:17pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/239 "2020-06-10T21:17:16Z")
Broken how? If you mean that issue right after you install it see [https://github.com/Blacksmoke16/GESI/issues/70#issuecomment-639815701](https://github.com/Blacksmoke16/GESI/issues/70#issuecomment-639815701). ---
**Author:** ![Charismik](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/charismik/32/244389_2.png) [@Charismik](https://forums.eveonline.com/u/Charismik)\ **Post date:** [June 10, 2020, 9:27pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/240 "2020-06-10T21:27:37Z")
Thanks for the prompt response. Yes, this is the one. Is there a workaround? ---
**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:** [June 10, 2020, 9:28pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/241 "2020-06-10T21:28:43Z")
Did you try refreshing? Might be able to look thru the Google bug tracker for something as well. ---
**Author:** ![Charismik](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/charismik/32/244389_2.png) [@Charismik](https://forums.eveonline.com/u/Charismik)\ **Post date:** [June 10, 2020, 9:29pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/242 "2020-06-10T21:29:51Z")
just checked again and now I see several menu options that weren’t there before. Seems that is working. Great!! Thanks a lot for the response and for the effort to built it. ---
**Author:** ![Claire\_D\_Eland](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/claire_d_eland/32/228725_2.png) [@Claire\_D\_Eland](https://forums.eveonline.com/u/Claire_D_Eland)\ **Post date:** [September 8, 2020, 3:43pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/243 "2020-09-08T15:43:17Z")
Hello! First of all, thanks for providing this useful tool to the community. I have installed GESI in my Google sheets, but I am receiving an error “Result too large” when I try to use markets\_region\_orders(10000002,buy,18,TRUE) Am I missing something or is this a limit in Google Sheets? Cheers! ---
**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:** [September 8, 2020, 4:01pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/244 "2020-09-08T16:01:46Z")
This is a limit of Google Sheets. Jita just has so many orders it cannot all fit into a sheet (you hit the cell limit). Your best bet would be do some filtering in JS first, use another API that pre-aggregates the data you need (like [https://market.fuzzwork.co.uk/api/](https://market.fuzzwork.co.uk/api/)), or make your application using an actual programming language. ---
**Author:** ![Claire\_D\_Eland](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/claire_d_eland/32/228725_2.png) [@Claire\_D\_Eland](https://forums.eveonline.com/u/Claire_D_Eland)\ **Post date:** [September 11, 2020, 3:56pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/246 "2020-09-11T15:56:59Z")
Oh, I see; many thanks! I am not good enough to write my own app though 🙂 May I ask if there is a way to put the data downloaded right into an array, instead of into the cells? I think I could be able to deal with some basic scripting… Cheers! ---
**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:** [September 11, 2020, 7:02pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/247 "2020-09-11T19:02:03Z")
Yes, you would want to use the [script editor](https://github.com/Blacksmoke16/GESI#script-editor). From there you could filter it down how you’d like. However there is also a request limit in sheets. TBH you would be best off getting the pre aggregated data like from fuzz’s API. ---
**Author:** ![Vicktor\_Bout](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/vicktor_bout/32/390510_2.png) [@Vicktor\_Bout](https://forums.eveonline.com/u/Vicktor_Bout)\ **Post date:** [October 27, 2020, 2:23pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/248 "2020-10-27T14:23:46Z")
Hi. Have a question, using “universe\_ids” to resolve character IDs it works ok, but what if there two characters with the same name (1st one deleted in Doomheim corporation and 2nd one is active) It’s always return deleted character ID ☹ Any advise? [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=11) [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=13)