Is it possible import Gsheet data into notebook without public

I prefert to import Gsheet data into notebook and build a custom dashboard, many charts like that.

I know this is possbile by https://observablehq.com/@bryangingechen/importing-data-from-google-spreadsheets-into-a-notebook-we

But I don’t want to publish Gsheet.

Is it possible import Gsheet data into notebook without public Gsheet ???

Is it possible import by Gsheet api ?