# \[10.0.0 - version 52\] GESI - Google Sheets ESI Add-On - Now an EVE Online Partner!

**URL:** <https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406>\
**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:** 14

<div class="post-metadata">

**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 9, 2021, 12:50am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/270 "2021-04-09T00:50:45Z")

</div>

FWIW the data is cached on both Google’s and ESI’s end. You can add another argument after all the GESI arguments that points to a cell. Then when you change that cell it’ll break Google’s cache, resulting in new data to be fetched (assuming ESI’s cache has expired as well).

---

<div class="post-metadata">

**Author:** ![Mystic\_Dealer](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/mystic_dealer/32/390508_2.png) [@Mystic\_Dealer](https://forums.eveonline.com/u/Mystic_Dealer)\
**Post date:** [April 9, 2021, 8:05am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/271 "2021-04-09T08:05:05Z")

</div>

Im added IF in all formulas which using GESI fetched data, like this (=IF(characters!$C$1=TRUE;A14;A14))  
and now im just wait GESI load the data and clicking on C1 so it changing from true to false and back, and then all data calculated. But 2-3 weeks ago all was working without this trick.  
Im repeat - GESI works fine, it’s google issue, i think they just change some formula calculation wait time.

---

<div class="post-metadata">

**Author:** ![Bill\_Ramen\_REDUX](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/bill_ramen_redux/32/252319_2.png) [@Bill\_Ramen\_REDUX](https://forums.eveonline.com/u/Bill_Ramen_REDUX)\
**Post date:** [April 15, 2021, 10:17am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/272 "2021-04-15T10:17:13Z")

</div>

@Blacksmoke16 sorry to randomly post on the thread but would you be available at some point to answer a few questions in private that I have regarding a google spreadsheet I made? I’m trying to expand upon my idea but I’m not sure how to do what it is I’m wanting to do. So yeah, can I pick your brain? I’ll mail you in game as well, but wanted to ask when you might be available for a chat. Thanks!

---

<div class="post-metadata">

**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 15, 2021, 12:45pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/273 "2021-04-15T12:45:38Z")

</div>

Sure, best bet would be to message me on Discord. `Blacksmoke16#0016`.

---

<div class="post-metadata">

**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, 2021, 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/274 "2021-05-30T15:14:39Z")

</div>

**8.4.0 aka version 37** March 30, 2021

* * *

## ESI Updates

- Various ESI version updates not yet currently listed on the changelog
  - See [this](https://github.com/Blacksmoke16/GESI/commit/a9cc0d7e27ca97a7b519d13b6f621f722bc1bb2a#diff-2cb1430690215101f0c063486abd96fa9d402bea7fdb88c4f10449a5d1bc1346) commit for the full list of changes

---

<div class="post-metadata">

**Author:** ![Casey\_Boirelle](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/casey_boirelle/32/274917_2.png) [@Casey\_Boirelle](https://forums.eveonline.com/u/Casey_Boirelle)\
**Post date:** [July 10, 2021, 9:53pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/275 "2021-07-10T21:53:54Z")

</div>

Hi,  
This sounds amazing. Just read as far back as 2018 checking out the updates and features this allows. Here’s the thing, I just discovered computers really, sheets and tools. All that. How bad of a time will I have trying to figure this out. I’ve been using and screwing up computers since Windows 95 but last year tried and failed miserably at building these contraptions. How do I get this going. Download is where? And how do I get this rolling on excel or sheets. Add ons?

---

<div class="post-metadata">

**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 11, 2021, 1:29am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/276 "2021-07-11T01:29:49Z")

</div>

> **[Blacksmoke16/GESI](https://github.com/Blacksmoke16/GESI#setup)**
>
> Google Sheets ESI Add-on. Contribute to Blacksmoke16/GESI development by creating an account on GitHub.

---

<div class="post-metadata">

**Author:** ![Joe\_Coal\_Jr](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/joe_coal_jr/32/284773_2.png) [@Joe\_Coal\_Jr](https://forums.eveonline.com/u/Joe_Coal_Jr)\
**Post date:** [August 17, 2021, 10:03pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/277 "2021-08-17T22:03:23Z")

</div>

so ive been enjoying this alot getting things to work.

Our corp uses titles to grant roles and im unable to get the corporations assets with titles.

Is this possible or do i need the actual director roll?

Thanks

Joe

---

<div class="post-metadata">

**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:** [August 17, 2021, 10:23pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/278 "2021-08-17T22:23:41Z")

</div>

> [@Joe\_Coal\_Jr](#):
>
> do i need the actual director roll?

Yes. That’s a requirement to fetch assets.

---

<div class="post-metadata">

**Author:** ![Joe\_Coal\_Jr](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/joe_coal_jr/32/284773_2.png) [@Joe\_Coal\_Jr](https://forums.eveonline.com/u/Joe_Coal_Jr)\
**Post date:** [August 19, 2021, 1:14am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/279 "2021-08-19T01:14:20Z")

</div>

thanks ill work on something else to try and get it then

---

<div class="post-metadata">

**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:** [August 19, 2021, 1:31am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/280 "2021-08-19T01:31:14Z")

</div>

I mean to be clear, the only way you can use the corp assets function is by being a director. It’s not something you can “work around”. If what information you need is only available in the corp’s asset list then your CEO will need to make you a director, otherwise you’re just out of luck.

---

<div class="post-metadata">

**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:** [August 25, 2021, 11:12pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/281 "2021-08-25T23:12:01Z")

</div>

**8.4.1 aka version 38** August 25, 2021

* * *

## Fixes

- Better support for passing standard 1D arrays to GESI parameters expecting arrays when using them in custom functions

---

<div class="post-metadata">

**Author:** ![Ducky\_the\_Pilot](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/ducky_the_pilot/32/286330_2.png) [@Ducky\_the\_Pilot](https://forums.eveonline.com/u/Ducky_the_Pilot)\
**Post date:** [September 1, 2021, 1:43am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/282 "2021-09-01T01:43:35Z")

</div>

Is there some way to force the sheet to run when I’m not actively checking it every day? I’ve tried a couple things via scripts but even having a timer set to refesh things seems to result in a stuck “Loading…” error in the cells if im not accessing the page when it happens

---

<div class="post-metadata">

**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 1, 2021, 2:01am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/283 "2021-09-01T02:01:42Z")

</div>

I’d advise not doing this because you’re just going to be wasting requests for data you’re never going to see anyway. Just set things up to refresh when a specific cell is changed, then change it when you want to see new data.

However, keep in mind both Google and ESI cache the data and that technique would only handle cases where Google is caching it and _NOT_ when ESI is caching the data.

---

<div class="post-metadata">

**Author:** ![Highfly\_Chastot](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/highfly_chastot/32/377320_2.png) [@Highfly\_Chastot](https://forums.eveonline.com/u/Highfly_Chastot)\
**Post date:** [September 5, 2021, 9:12pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/284 "2021-09-05T21:12:06Z")

</div>

Here’s a script you can attach to a couple cells to refresh static and dynamic data. Then attach the functions you want refreshed to the cells being changed by the script.

Just remember to create a space in your spreadsheet to have the cells in, maybe a seperate page called Utilities 😉

```auto

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.
  ui.createMenu('Custom Tools')
      .addItem('Refresh All Data','refreshData')
      .addToUi();
} 

// Function to refresh data

function refreshData() {
    refreshData1()
    refreshData2()
    refreshData3()
}
  
function refreshData1 () {

// Load sheet with variable
    
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Utility');
  var cell = sheet.getRange('Utility!B3');
  var cell2 = sheet.getRange('Utility!C3');
  
//Change Value To 0
    
    cell.setValue(0);
    cell2.setValue(0);

}

function refreshData2(){

//Load sheet with variable

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Utility');
  var cell = sheet.getRange('Utility!B3');

//Time delay before changing back
  
    Utilities.sleep(2000)
  
//Set Value Back to 1
  
    cell.setValue(1);
  
}

function refreshData3(){

//Load sheet with variable

  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Utility');
  var cell2 = sheet.getRange('Utility!C3');

//Time delay before changing back
  
    Utilities.sleep(2000)
  
//Set Value Back to 1
  
    cell2.setValue(1);
  
} 

```

---

<div class="post-metadata">

**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 15, 2021, 12:35pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/285 "2021-09-15T12:35:50Z")

</div>

**8.5.0 aka version 39** September 15, 2021

* * *

## ESI Updates

- Remove `ancestry_id` from `characters/{character_id}`
  - See: [esi-issues/changelog.md at master · esi/esi-issues · GitHub](https://github.com/esi/esi-issues/blob/master/changelog.md#2021-09-15)

---

<div class="post-metadata">

**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:** [October 10, 2021, 7:32pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/286 "2021-10-10T19:32:23Z")

</div>

I’m excited to announce that GESI is now an official EVE Online Partner!

Because of this, I’m going to be starting a bug bounty program that will reward anyone reporting a valid bug with free skins. Bugs can be reported via GESI’s discord server, or by creating an issue on the GitHub repo.

However, because ideally there will be no bugs, I’m also going to be giving some out to those who are active/helpful within the GESI discord server as well as anyone contributing meaningful to GESI, as it is open source. Depending on how this goes, a random drawing may also be needed.

Shoutout to all of those who use GESI as this wouldn’t have been possible without you.

---

<div class="post-metadata">

**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:** [December 10, 2021, 8:55am UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/287 "2021-12-10T08:55:32Z")

</div>

GESI disappeared from googleapps for some reason

---

<div class="post-metadata">

**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 10, 2021, 2:05pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/288 "2021-12-10T14:05:00Z")

</div>

See [GESI is missing from Google Sheets Add-Ons · Issue #90 · Blacksmoke16/GESI · GitHub](https://github.com/Blacksmoke16/GESI/issues/90).

---

<div class="post-metadata">

**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 15, 2021, 5:29pm UTC](https://forums.eveonline.com/t/10-0-0-version-52-gesi-google-sheets-esi-add-on-now-an-eve-online-partner/13406/289 "2021-12-15T17:29:16Z")

</div>

It’s back.

[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=13)

[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=15)