# \[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:** 11
**Author:** ![Tau\_Hopper](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tau_hopper/32/359920_2.png) [@Tau\_Hopper](https://forums.eveonline.com/u/Tau_Hopper)\ **Post date:** [January 29, 2020, 10:24am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/208 "2020-01-29T10:24:54Z")
Still no news? ---
**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 29, 2020, 3:14pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/209 "2020-01-29T15:14:23Z")
I been talking with them and things on my end should be resolved. So just waiting on them to actually review it now as before was mainly waiting on me to fix some things as it turns out. ---
**Author:** ![doogymoogy](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/doogymoogy/32/187867_2.png) [@doogymoogy](https://forums.eveonline.com/u/doogymoogy)\ **Post date:** [February 18, 2020, 8:09pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/210 "2020-02-18T20:09:31Z")
Hey, thank you for your work on such an awesome project. I know we are still waiting on the add-on to be verified by Google, but as I am just learning and am new to API stuff, I thought I would have a play and managed to use the older manual method. I managed to get all the way to logging in with my character, but unfortunately, I keep getting a json unexpected end of input error. I nearly got to the final hurdle. I wonder if the issue is that I am copying from old GESI.gs/endpoint.gs/funtion.gs files as they are 2 years old. If you could point me to more up to date ones if they exist that would be great. Alternatively, I’ll wait untill Google approves the App. Sorry if I am completely going about this in the wrong way but I am excited to get involved in this area. Thanks again ---
**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 19, 2020, 7:14pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/211 "2020-02-19T19:14:51Z")
You can get the latest `.gs` code from [https://script.google.com/d/1KjnRVVFr2KiHH55sqBfHcZ-yXweJ7iv89V99ubaLy4A7B\_YH8rB5u0s3/edit?usp=sharing](https://script.google.com/d/1KjnRVVFr2KiHH55sqBfHcZ-yXweJ7iv89V99ubaLy4A7B_YH8rB5u0s3/edit?usp=sharing). The main things you’ll have to do is like replace `ScriptApp.getScriptId()` with your sheet’s scriptID, `PropertiesService.getScriptProperties().getProperty('CLIENT_ID')` with your clientId, etc. ---
**Author:** ![doogymoogy](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/doogymoogy/32/187867_2.png) [@doogymoogy](https://forums.eveonline.com/u/doogymoogy)\ **Post date:** [February 20, 2020, 3:02pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/212 "2020-02-20T15:02:32Z")
Wow thank you so much. I’ll give it a try. ---
**Author:** ![doogymoogy](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/doogymoogy/32/187867_2.png) [@doogymoogy](https://forums.eveonline.com/u/doogymoogy)\ **Post date:** [February 20, 2020, 6:58pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/213 "2020-02-20T18:58:47Z")
Unfortunately, I gave it a try but I think my skills are not yet up to the task. I did make some progress though. I replaced the things you advised but got the following error: {“body”:"{“error”:“invalid\_client”,“error\_description”:“Missing or invalid client credentials.”}",“code”:401,“path”:“[https://login.eveonline.com/v2/oauth/token",“sheet\_id”:“1qYlvfULQxUT2GOFj-bkzJh2jBMbWfG1vHH3p8mM\_ImI”,"character](https://login.eveonline.com/v2/oauth/token%22,%22sheet_id%22:%221qYlvfULQxUT2GOFj-bkzJh2jBMbWfG1vHH3p8mM_ImI%22,%22character)”:null} (line 292, file “GESI”) I’m thinking: Does line 76 need to be replaced with my character name? Should I be amending lines 199 and 231 with my client id and secret id? I wonder if you accept in game ISK as a reward for helping in my new endeavour? I managed to use the google chrome postman app to extract data from Eve Swagger and am playing around with the data but I have a lot to learn still and thought your GESI app is a marvelous thing 🙂 Thanks again, Doogymoogy ---
**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 20, 2020, 7:12pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/214 "2020-02-20T19:12:41Z")
> [@doogymoogy](#): > > Does line 76 need to be replaced with my character name? No that one is fine as `MAIN_CHARACTER` just ends up being the first char you auth. > [@doogymoogy](#): > > Should I be amending lines 199 and 231 with my client id and secret id? Yes, of course. Will want to update any references of `CLIENT_ID` and `CLIENT_SECRET` to be your credentials. I’d suggest defining a variable at the top, then reference that in the code. ---
**Author:** ![doogymoogy](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/doogymoogy/32/187867_2.png) [@doogymoogy](https://forums.eveonline.com/u/doogymoogy)\ **Post date:** [February 20, 2020, 7:17pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/215 "2020-02-20T19:17:16Z")
Thanks again. I’ll give it another go soon as im just letting my brain cool down for a bit 😀 ---
**Author:** ![Kegsy](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/kegsy/32/189796_2.png) [@Kegsy](https://forums.eveonline.com/u/Kegsy)\ **Post date:** [March 2, 2020, 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/216 "2020-03-02T22:59:04Z")
Hi Blacksmoke Amazing work Thank you. ---
**Author:** ![Solomon\_Iskander](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/solomon_iskander/32/496328_2.png) [@Solomon\_Iskander](https://forums.eveonline.com/u/Solomon_Iskander)\ **Post date:** [March 5, 2020, 8:29pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/217 "2020-03-05T20:29:05Z")
> [@Blacksmoke16](#): > > I been talking with them and things on my end should be resolved. So just waiting on them to actually review it now as before was mainly waiting on me to fix some things as it turns out. I am bad at programming so I am not able to figure out the changes that need to be made to get this working again. Do you have any idea how long Google takes to review an app? ---
**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:** [March 5, 2020, 8:40pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/218 "2020-03-05T20:40:36Z")
I had to resubmit it as I was originally missing some scopes. Probably a couple more weeks. In the meantime, you can refer to > Steps I took to make this work: > > 1. Copy all the files from [https://script.google.com/d/1KjnRVVFr2KiHH55sqBfHcZ-yXweJ7iv89V99ubaLy4A7B\_YH8rB5u0s3/edit?usp=sharing](https://script.google.com/d/1KjnRVVFr2KiHH55sqBfHcZ-yXweJ7iv89V99ubaLy4A7B_YH8rB5u0s3/edit?usp=sharing) to your Google Sheets within script editor. Be sure to go to `view => show manifest file` and copy that too. > 2. Create application in [https://developers.eveonline.com/](https://developers.eveonline.com/) > 3. Callback for the app should be : [https://script.google.com/macros/d/YOUR\_SCRIPT\_EDITOR\_CODE/usercallback](https://script.google.com/macros/d/YOUR_SCRIPT_EDITOR_CODE/usercallback) > 3.1 Where `YOUR_SCRIPT_EDITOR_ID` would be the long string in the URL when you’re in the script editor. For example, `1KjnRVVFr2KiHH55sqBfHcZ-yXweJ7iv89V99ubaLy4A7B_YH8rB5u0s3` from the link above. > 4. Obtain Client ID and Secret Key > 5. Replace all `PropertiesService.getScriptProperties().getProperty('CLIENT_ID') `and `PropertiesService.getScriptProperties().getProperty('CLIENT_SECRET')` with the above values in gesi.gs > 6. Replace `PropertiesService.getScriptProperties().getProperty('BASE_URL')` with `https://esi.evetech.net/` > 7. Authenticate via Add-ons menu. > 8. You are ready to use GESI within Google Sheets. If you have any trouble feel free to join the Discord server and we can get it working. ---
**Author:** ![Solomon\_Iskander](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/solomon_iskander/32/496328_2.png) [@Solomon\_Iskander](https://forums.eveonline.com/u/Solomon_Iskander)\ **Post date:** [March 5, 2020, 9:06pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/219 "2020-03-05T21:06:22Z")
Thank you! I will try that tonight. ---
**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:** [March 7, 2020, 1:30pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/220 "2020-03-07T13:30:33Z")
![image](https://global.discourse-cdn.com/eveonline/original/3X/e/f/ef2bb54eab1d5a4f02ef751c738a84b60594a9ba.png) Should be good to go now. ---
**Author:** ![Tau\_Hopper](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/tau_hopper/32/359920_2.png) [@Tau\_Hopper](https://forums.eveonline.com/u/Tau_Hopper)\ **Post date:** [March 14, 2020, 3:01pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/221 "2020-03-14T15:01:54Z")
Indeed! 🙂 Now that I was finally able to install GESI through the G Suite Marketplace I have a small doubt, though. I’m not sure if I missed something about it in the documentation or in a previous comment, but when I use a range of cells as input to e.g. _universe\_names_, I get some incorrect outputs - although I suspect that, rather than being actually wrong, they are simply not aligned with the input values. Is it the case that the order of the outputs is not guaranteed to match that of the queried values when an array is provided? ---
**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 16, 2020, 8:08am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/222 "2020-04-16T08:08:19Z")
Hay Fist off thanks a lot for this it is so helpful and makes it possible for me to do the kind of industry I want to do!! but I am now getting a error in my sheet that has been working fine for the last year. when I use the formula: =characters\_character\_assets(,-1,-1) I get “#ERROR!” I have uploaded an image of the error. can anyone help with this? thanks, Ray ![Screenshot 2020-04-16 at 09.06.36](https://global.discourse-cdn.com/eveonline/original/3X/c/c/cc580fa6e8c7a7be74bfea735afe5ffa06360a5c.png) ---
**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 16, 2020, 12:46pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/223 "2020-04-16T12:46:55Z")
Use `"v5"` in the `version` argument. This’ll be fixed when I release the new GESI version this weekend. Until then that should do the trick. ---
**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 16, 2020, 2:44pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/224 "2020-04-16T14:44:47Z")
I used: =characters\_character\_assets(,-1,-1,“v5”) and it works perfectly. Thanks! ---
**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 17, 2020, 1:06pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/225 "2020-04-17T13:06:56Z")
Hey, thanks for this. I’m just starting out using it and I’m wondering how often data will update for various industry function calls? Is there somewhere I can see 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:** [April 19, 2020, 5:43pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/226 "2020-04-19T17:43:03Z")
There are two levels of caching involved. One on Google’s end, another on ESI’s end. You wouldn’t get new data until both of them are cleared. A common way to handle Google’s cache is adding a dummy parameter to the end of a GESI function call, to point to a cell in the sheet. Then when you change the value of this cell, it would invalidate Google’s cache, and cause the function to refetch new data. However, for ESI’s cache is time based, which you’ll just have to wait. E.x. `characters_character_assets()` as an hour long cache timer; meaning once you fetch data you wont get new data until an hour later. Or in other words, if you fetch your asset list, then move some items in game, ESI won’t reflect those changes until an hour has passed. ---
**Author:** ![Amiean](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/amiean/32/199222_2.png) [@Amiean](https://forums.eveonline.com/u/Amiean)\ **Post date:** [April 19, 2020, 8:31pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/227 "2020-04-19T20:31:44Z")
Howdy! Love the GESI, its a fantastic tool! I am just wondering if there is currently a way to use the GESI to pull a list of the reprocessing a character has done with details like date/time, item reprocessed & yields [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=10) [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=12)