# Google Sheet by Crest

**URL:** <https://forums.eveonline.com/t/google-sheet-by-crest/75301>\
**Category:** Third Party Developers\
**Created:** [May 9, 2018, 7:57pm UTC](https://forums.eveonline.com/t/google-sheet-by-crest/75301 "2018-05-09T19:57:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Elenoire\_Doissetep](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elenoire_doissetep/32/42292_2.png) [@Elenoire\_Doissetep](https://forums.eveonline.com/u/Elenoire_Doissetep)\
**Post date:** [May 9, 2018, 7:57pm UTC](https://forums.eveonline.com/t/google-sheet-by-crest/75301/1 "2018-05-09T19:57:03Z")

</div>

Hi,  
I have several Google sheets that get market prices from ccp CREST; this system stopped Yesterday with the API Death

how could I update my sheet to ESI (should be public data and not sso reserved)?

thansk for ny help

bye

eric

---

<div class="post-metadata">

**Author:** ![Obil\_Que](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/obil_que/32/171329_2.png) [@Obil\_Que](https://forums.eveonline.com/u/Obil_Que)\
**Post date:** [May 9, 2018, 8:08pm UTC](https://forums.eveonline.com/t/google-sheet-by-crest/75301/2 "2018-05-09T20:08:55Z")

</div>

> **[Using ESI with Google Sheets - Fuzzwork Enterprises](https://www.fuzzwork.co.uk/2017/03/14/using-esi-google-sheets/)**
>
> I’ve been meaning to write this post for a while now, so here it finally is; How to use ESI, with google sheets. Now, the unauthenticated endpoints are relatively easy. You’ll still need to write a little code for them, or steal it from somewhere...

---

<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 9, 2018, 8:46pm UTC](https://forums.eveonline.com/t/google-sheet-by-crest/75301/3 "2018-05-09T20:46:37Z")

</div>

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

However you might be better off with writing a function to get data from [https://market.fuzzwork.co.uk/api/](https://market.fuzzwork.co.uk/api/) for the market data. So you do not have to parse and aggregate massive amounts of data.

---

<div class="post-metadata">

**Author:** ![Elenoire\_Doissetep](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elenoire_doissetep/32/42292_2.png) [@Elenoire\_Doissetep](https://forums.eveonline.com/u/Elenoire_Doissetep)\
**Post date:** [May 10, 2018, 12:17pm UTC](https://forums.eveonline.com/t/google-sheet-by-crest/75301/4 "2018-05-10T12:17:18Z")

</div>

I try fuzzwork

We ll see

---

<div class="post-metadata">

**Author:** ![Elenoire\_Doissetep](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/elenoire_doissetep/32/42292_2.png) [@Elenoire\_Doissetep](https://forums.eveonline.com/u/Elenoire_Doissetep)\
**Post date:** [May 10, 2018, 12:20pm UTC](https://forums.eveonline.com/t/google-sheet-by-crest/75301/5 "2018-05-10T12:20:13Z")

</div>

Fuzz doesnt have daily volume right?

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [August 8, 2018, 12:20pm UTC](https://forums.eveonline.com/t/google-sheet-by-crest/75301/6 "2018-08-08T12:20:17Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.