# Google Sheets - Multiple Mining Ledger Imports with ESI **URL:** \ **Category:** Third Party Developers\ **Created:** [April 9, 2018, 5:43pm UTC](https://forums.eveonline.com/t/google-sheets-multiple-mining-ledger-imports-with-esi/68747 "2018-04-09T17:43:09Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Gnauty\_Gnate](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/gnauty_gnate/32/39857_2.png) [@Gnauty\_Gnate](https://forums.eveonline.com/u/Gnauty_Gnate)\ **Post date:** [April 9, 2018, 5:43pm UTC](https://forums.eveonline.com/t/google-sheets-multiple-mining-ledger-imports-with-esi/68747/1 "2018-04-09T17:43:10Z")
This morning, I googled-up an excellent blog post on using ESI with Google Sheets: [https://developers.eveonline.com/blog/article/using-esi-with-google-sheets](https://developers.eveonline.com/blog/article/using-esi-with-google-sheets) I’m not a programmer but after some careful copy-n-pasting I was able to create a Google Sheet that pulls my mining ledger data for one character on one account. All good so far and I’m feeling very self-congratulatory. So here’s my question… Is there an easy’ish way to scale this up so that I can pull mining ledgers from multiple characters and multiple accounts? Use case is a small alliance that wants to track character-level mining by date and mineral type (not moon mining or corp-level data). The solution that comes to mind involves creating a separate Google sheet for each character. The owner would then have to create a separate application at [developers.eveonline.com](http://developers.eveonline.com) using a unique Google Script ID that I provide. I would then create a Google Sheet that references all the character-level Google sheets (if that’s even possible) and aggregates the data. I’m guessing there’s a better way. Remember, I’m not a programmer. Please use small words when replying. 🙂 Thanks! o7 ---
**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, 2018, 6:15pm UTC](https://forums.eveonline.com/t/google-sheets-multiple-mining-ledger-imports-with-esi/68747/2 "2018-04-09T18:15:01Z")
Totally doable and super easy, you’re overthinking it 🙂 If you repeat the auth process, i.e. how you added your first character, but this time select a different character, it will also authorize that character. You then will be able to specify which character should be used for a function (which defaults to whatever character you set your `MAIN_CHARACTER` variable to), by doing like `characters_character_mining("Blacksmoke16")`. If you need to add another character that is on a different account; click `Cancel` when you are at the part where you need to select a character, login to other account, and select the character you want to. > [@\[9.2.1 - version 50\] GESI - Google Sheets ESI Add-On - Now an EVE Online Partner!](https://forums.eveonline.com/t/5-2-1-gesi-google-sheets-esi-library-now-with-better-corp-management-features/13406/80): > > 5.0.0 March 6, 2018 This major version release focuses on refactoring where SSO auth data (char name/id, corp/alliance id, refresh\_token) are stored as well as some QoL improvements for people using the script for corp management. Previously I was relying upon documentProperties service of Google scripts. However, #21 as well as messages from others brought to my attention that it for one reason or another it loses the data every so often. This This new method creates a new sheet Auth Data … Checkout this post in regards to how to best manage authing other accounts you do not own based on your situation. ---
**Author:** ![Gnauty\_Gnate](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/gnauty_gnate/32/39857_2.png) [@Gnauty\_Gnate](https://forums.eveonline.com/u/Gnauty_Gnate)\ **Post date:** [April 9, 2018, 7:05pm UTC](https://forums.eveonline.com/t/google-sheets-multiple-mining-ledger-imports-with-esi/68747/3 "2018-04-09T19:05:32Z")
That’s exactly what I need. Thanks very much, Smoke! ---
**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\ **Post date:** [July 8, 2018, 7:05pm UTC](https://forums.eveonline.com/t/google-sheets-multiple-mining-ledger-imports-with-esi/68747/4 "2018-07-08T19:05:37Z")
Closed on July 8, 2018, 7:05pm UTC This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.