# Googlesheet name

**URL:** https://discourse.julialang.org/t/googlesheet-name/117146
**Category:** General Usage
**Tags:** package, google
**Created:** [July 17, 2024, 2:41pm UTC](https://discourse.julialang.org/t/googlesheet-name/117146 "2024-07-17T14:41:47Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![dgagnon](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/dgagnon/32/45466_2.png) [@dgagnon](https://discourse.julialang.org/u/dgagnon)
#### Post date: [July 17, 2024, 2:41pm UTC](https://discourse.julialang.org/t/googlesheet-name/117146/1 "2024-07-17T14:41:47Z")

</div>

Hello

I can open a Googlesheet and get all sheet names inside with function`sheet_names()` with a `GoogleSheetsClient` and its `id`.  
However, I never found how to get the Spreadsheet name which is displayed in the browser.

I see a function `gsheet_api_spreadsheet_get()` but I do not understand what argument I should use. I have looked at the doc of the package for the answer but somehow missed it.

Thanks for your help.

---

<div class="post-metadata">

### Author: ![abraemer](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/abraemer/32/51403_2.png) [@abraemer](https://discourse.julialang.org/u/abraemer)
#### Post date: [July 17, 2024, 3:46pm UTC](https://discourse.julialang.org/t/googlesheet-name/117146/2 "2024-07-17T15:46:11Z")

</div>

So I know nothing about this library but had a look at the docs and found the [`meta`](https://chipkent.github.io/GoogleSheets.jl/dev/#GoogleSheets.meta) function which seems to get a lot of metadata. If I understand correctly you want the name of the spreadsheet itself and I would expect this to be contained in this metadata. You don’t need to know the key I think and can just call this function with the spreadsheet to get all key-value pairs (but the docs are not explicit about this so this is my interpretation).

---

<div class="post-metadata">

### Author: ![dgagnon](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/dgagnon/32/45466_2.png) [@dgagnon](https://discourse.julialang.org/u/dgagnon)
#### Post date: [July 17, 2024, 4:35pm UTC](https://discourse.julialang.org/t/googlesheet-name/117146/3 "2024-07-17T16:35:08Z")

</div>

Indeed. The following code will get it done:

```julia
using GoogleSheets
googleclient = sheets_client(AUTH_SCOPE_READWRITE)
mysheetid = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" # have a valid id here
mysheet = Spreadsheet(mysheetid)
mydict = meta(googleclient, mysheet) # a dictionary is returned
mypropertiesdict = = get(dico, "properties", 0) # another dict inside the first dict
mytitle = get(mypropertiesdict, "title", "")

```

I was looking for something called “properties” not “meta”. Of course meta makes sense as well.