r/googlecloud • u/Longjumping-Cold1389 • 7d ago

Google sheets API Key

I really just want an api key to pull info from one of my google sheets. But as i look into this there is this whole rabbit hole of AM admin, and changing the organizations default permissions, and i saw vague mentions of weekly charges. So let me ask this, is there an easier way to get an api key for google sheets, and if not how high is the risk of charges if i set up an organization and do all the steps to get the key though google cloud.

2 Upvotes

75% Upvoted

14 comments sorted by

View all comments

Show parent comments

1

u/Advanced-Ad4869 7d ago

You use the identity of the account with the Google SDK of the language you are using. The easiest way is to generate a service account key json that you download. But this is VERY important, that key is a bearer token with no restrictions so you need to safe guard it. You can't share it or commit it to git or like use it client side in a website cuz someone will steal it. You should really read the Google cloud documentation on service accounts before proceeding.

1

u/Longjumping-Cold1389 7d ago

My issue is that i cannot download the key, due to default perms of an organization. I do plan on safe guarding that key, but you mention reading the Google cloud documentation. How important is that, I only really want this 1 key for a project, and didnt read most of it and jumped to reddit. Do you recommend reading all the documentation even if im using it for just 1 thing?

2

u/Advanced-Ad4869 7d ago

Yes you need to understand what you are doing regardless of the scope of your project. If you org admin does not allow service account key creation you should talk with them about other auth strategies for the service account that meet the needs of your app.

1

u/Advanced-Ad4869 7d ago

It's quite common for orgs to disable key gen and download since it's dangerous.

1

u/Longjumping-Cold1389 7d ago

but i made the org

1

u/Advanced-Ad4869 7d ago

It's on by default now in all new orgs.

1

u/Longjumping-Cold1389 7d ago

yk what imma read the documention first ill come back if i have more questions after reading, thank you for your time