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

2

u/Longjumping-Cold1389 7d ago

by adding the email you mean sharing the sheet with that email? I am super new to all of this sorry if its a stupid question.

2

u/Advanced-Ad4869 7d ago

Yes. Each service account has an email address.

1

u/Longjumping-Cold1389 7d ago

I shared the sheet with the email, and the api is enabled. Do i need to create a key? or is that all i need?

1

u/Longjumping-Cold1389 7d ago

when ever i go to download my json key, so i can use my sheet in python, it says my organization, has blocked my ability to do so. am i over complicating this?