# \[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:** 7
**Author:** ![Plaguies](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/plaguies/32/427774_2.png) [@Plaguies](https://forums.eveonline.com/u/Plaguies)\ **Post date:** [May 26, 2018, 7:42am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/124 "2018-05-26T07:42:19Z")
Ok working now. When i use as example your command =characters\_character\_skillqueu() it shows me a fully list of every skill i am training in the future (like finish\_date, finish\_level, skill\_id etc all of it . But i only want to extract the finish date and only of the last skill is that possilbe ? i tried it with opt\_headers command and finish\_date but it dont works. As to clarify for what i wan to use this, i an overview over 9 chars when SkillTree ends. When there are open industry jobs etc. Im very new to this GESI and to read from eve data. sry. ---
**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 26, 2018, 11:10am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/125 "2018-05-26T11:10:54Z")
See [https://github.com/Blacksmoke16/GESI#changing-order-of-column-headers](https://github.com/Blacksmoke16/GESI#changing-order-of-column-headers). However instead of just reordering the array, just remove the ones you dont want returned. GESI is just an method of getting ESI data into sheets, you will of course have to customize/edit it to fit your needs. ---
**Author:** ![Plaguies](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/plaguies/32/427774_2.png) [@Plaguies](https://forums.eveonline.com/u/Plaguies)\ **Post date:** [May 26, 2018, 9:10pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/126 "2018-05-26T21:10:50Z")
Thx it worked. My problem is to learn more from the google sheets commands to combine the commands. thx for your help! ---
**Author:** ![Mandu\_LEE](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mandu_lee/32/65790_2.png) [@Mandu\_LEE](https://forums.eveonline.com/u/Mandu_LEE)\ **Post date:** [May 27, 2018, 7:04am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/127 "2018-05-27T07:04:18Z")
Hi, I just installed your script on google sheet, and tried to authorize it but just getting this message. ESI response error: {“error”:“This software has exceeded the error limit for ESI. If you are a user, please contact the maintainer of this software. If you are a developer/maintainer, please make a greater effort in the future to receive valid responses. For tips on how, come have a chat with us in #esi on tweetfleet slack. If you’re not on tweetfleet slack yet, you can get an invite here -\> [https://www.fuzzwork.co.uk/tweetfleet-slack-invites/","code](https://www.fuzzwork.co.uk/tweetfleet-slack-invites/%22,%22code)”:420}(‘GESI’ file, 202line) can I get some help with this? ---
**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 27, 2018, 1:53pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/128 "2018-05-27T13:53:45Z")
Can you give me some details of what you did to produce this? ---
**Author:** ![Mandu\_LEE](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mandu_lee/32/65790_2.png) [@Mandu\_LEE](https://forums.eveonline.com/u/Mandu_LEE)\ **Post date:** [May 28, 2018, 2:32am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/129 "2018-05-28T02:32:40Z")
Nevermind. Don’t know why but it’s working after a day 😛 ---
**Author:** ![Nowoczesna\_Kasia](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/nowoczesna_kasia/32/75305_2.png) [@Nowoczesna\_Kasia](https://forums.eveonline.com/u/Nowoczesna_Kasia)\ **Post date:** [May 28, 2018, 5:50pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/130 "2018-05-28T17:50:46Z")
Ok, i was trying to figure it out two days but it beat me. Im pretty lame when it comes to programming. Im trying to get lowest sell price and highest buy price from jita on lets say veldspar that id is “1230”. Was trying to use > =markets\_region\_orders but didnt work out as i wanted to ---
**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 28, 2018, 6:16pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/131 "2018-05-28T18:16:02Z")
Market stuff in ESI is not super easy as you need to parse all the orders for a given type in a given region to figure out max buy and min sell. I would suggest creating a custom function to get price data off one of the market aggregate sites, such as [https://market.fuzzwork.co.uk/api/](https://market.fuzzwork.co.uk/api/) so that you do not have to do the processing of the raw data yourself. ---
**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 30, 2018, 3:21am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/132 "2018-05-30T03:21:06Z")
**5.7.0** May 29, 2018 * * * ## Additions - Add `dogma_dynamic_items_type_item` ## Changes - Add `is_blueprint_copy` attribute to `characters_character_assets`. - Add `is_blueprint_copy` attribute to `corporations_corporations_assets`. ---
**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 9, 2018, 12:24am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/133 "2018-06-09T00:24:59Z")
There is a bug with GESI in that it can’t display array of single values atm. As such I am going to dely yesterday’s ESI changes to version 6.0.0. Progress is going well but could use some testers for it. I also made a Discord server for users to chill in, get help, and request new features etc. > **[Discord - Free voice and text chat for gamers](https://discordapp.com/invite/eEAH2et)** > > Step up your game with a modern voice & text chat app. Crystal clear voice, multiple server and channel support, mobile apps, and more. Get your free server now! Feel free to message to be a v6.0.0 tester 🙂 ---
**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 23, 2018, 3:46am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/134 "2018-06-23T03:46:58Z")
**6.0.0** June 23, 2018 This major version release focuses on refactoring the backend tooling, the code that generates the GESI files, as well as open sourcing that code. * * * # Breaking Changes Overall there shouldn’t be _that_ many breaking changes in terms of having to reauth characters or something like that. The main breaking change would be: - Order of columns for each endpoint are now in ABC order. # GESI Source Files The source code for GESI, i.e. the code that generates the `functions.gs` and `endpoints.gs` files is written in [Crystal](https://crystal-lang.org/). The code can be found under the `src` directory and is commented with some info to help guide users if they wish to edit the source to accomplish their own goals. Such as generating the files based on a different version of ESI. the `bin` directory contains a statically linked binary (compiled version of `GESI.cr`) that should be able to be ran on any 64-bit Linux machine (only testing on Debian 9) without installing any dependencies. The benefit of this, for example, is to generate the files yourself versus waiting on me to update them on GitHub. The binary has a few optional arguments that can be seen [HERE](https://github.com/Blacksmoke16/GESI/blob/master/src/GESI.cr#L4-L14), or by doing `./GESI-linux-x86_64 -h` For now there is no Mac/Windows binary as I don’t have an easy way of testing/creating those, and because Crystal doesn’t have full Windows support as of now. As usual, if i missed anything or something doesn’t work as it did before, please make an issue on the GitHub and I will deal with it ASAP. PS: Join the [discord server](https://discordapp.com/invite/eEAH2et)! B ---
**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 26, 2018, 3:38am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/135 "2018-06-26T03:38:48Z")
**6.1.0** June 26, 2018 This endpoint brings about support for a select few POST endpoints that are info only; meaning they return data like a GET endpoint, vs causing an action to happen in game. This was needed as a [replacement](https://developers.eveonline.com/blog/article/breaking-changes-to-characters-names-and-corporation-names) of the `*_names` functions. The replacement for all three is now `universe_names(ids)` * * * ## Additions - `characters_affiliation` - `characters_character_assets_names` - `corporations_corporation_assets_names` - `universe_ids` - `characters_character_assets_locations` - `corporations_corporation_assets_locations` - `universe_names` ---
**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 27, 2018, 8:47pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/136 "2018-06-27T20:47:53Z")
**6.2.0** June 27, 2018 * * * ## Changes - `fw_systems` [v1 =\> v2](https://esi.evetech.net/diff/v1/v2/#GET-/fw/systems/) ---
**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 28, 2018, 12:23am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/137 "2018-06-28T00:23:51Z")
**6.3.0** June 28, 2018 `endpoints.gs` and `functions.gs` are now generated for all ESI version (legacy, latest, and dev). The user can pick which they wish to use. ---
**Author:** ![Zymex](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/zymex/32/379368_2.png) [@Zymex](https://forums.eveonline.com/u/Zymex)\ **Post date:** [July 3, 2018, 8:59pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/138 "2018-07-03T20:59:24Z")
Can you add a function to get the market price of an item? Parameters could be itemid, region, buy/sell ---
**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:** [July 4, 2018, 12:48am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/139 "2018-07-04T00:48:37Z")
That is outside of the scope of GESI. You have all the tools needed to implement one yourself however. EDIT: I would also be open if someone wants to build a more market specific script built on top of GESI. ---
**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:** [July 9, 2018, 4:45pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/140 "2018-07-09T16:45:35Z")
**6.4.0** July 9, 2018 As a reminder this changelog is only representative of the `latest` version of ESI. * * * ## Changes - `universe_structures_structure` [v1 =\> v2](https://esi.evetech.net/diff/v1/v2/#GET-/universe/structures/%7Bstructure_id%7D/) - `universe_systems_system` [v3 =\> v4](https://esi.evetech.net/diff/v3/v4/#GET-/universe/systems/%7Bsystem_id%7D/) - `corporations_corporation_orders_history` [v1 =\> v2](https://esi.evetech.net/diff/v1/v2/#GET-/corporations/%7Bcorporation_id%7D/orders/history/) - `corporations_corporation_orders` [v1 =\> v2](https://esi.evetech.net/diff/v2/v3/#GET-/corporations/%7Bcorporation_id%7D/orders/) ## Removed - `corporations_corporation_outposts` - `corporations_corporation_outposts_outpost` ---
**Author:** ![Chani\_El\_zrya](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/chani_el_zrya/32/320962_2.png) [@Chani\_El\_zrya](https://forums.eveonline.com/u/Chani_El_zrya)\ **Post date:** [July 14, 2018, 8:26am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/141 "2018-07-14T08:26:17Z")
Hi Blacksmoke, I did a bit of testing with the function =markets\_region\_orders. It seems i can’t make it work properly. For instance try : =markets\_region\_orders(buy,10000002,1,1230,TRUE) Veldspar in Forge region only buy order, 1 page. I get as output sell order for any Type id items. There is no filtering by type ID and type of order 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:** [July 14, 2018, 12:58pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/142 "2018-07-14T12:58:02Z")
@Chani_El_zrya Yes, you are specifically requesting only page 1 and only buy orders. If you wanted all pages and both buy/sell you would do `=markets_region_orders("all",10000002,-1,1230)` ---
**Author:** ![Chani\_El\_zrya](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/chani_el_zrya/32/320962_2.png) [@Chani\_El\_zrya](https://forums.eveonline.com/u/Chani_El_zrya)\ **Post date:** [July 15, 2018, 7:00pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/143 "2018-07-15T19:00:38Z")
Oups you misunderstood my previous message. I wanted to say that the function =markets\_region\_orders is not working properly. I dont get what i’m requesting e.g. Veldspar + forge region + buy order Instead i get as results : random items ID + both buy and sell order ( from the forge region at least) [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=6) [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=8)