Google Sheets API - Python - Creating a Sheet

Question

I am new to API's and i am trying to create a google sheet using python. I am able to create google sheet but unable to view/edit(Access issue). I am using Service Account in API's. Please help me in modifying the code to access the created sheets.

Here is the sample code i am using to create one.

service = discovery.build('sheets', 'v4', credentials=credentials)

spreadsheet_body = {
}

request = service.spreadsheets().create(body=spreadsheet_body)
response = request.execute()

What do you mean by "view it"? Which scopes do you have? Please provide your full code including authentication and service account builder. — ziganotschka
– ziganotschka, Commented May 5, 2020 at 15:36

ziganotschka · Accepted Answer · 2020-05-05 15:43:53Z

0

Most likely you are creating the sheet as the service account - by default on its Drive, this is why you have issues accessing it.
If instead you want to create a sheet on YOUR drive, you need to use impersonation:
After enabling domain-wide delegation, you need to impersonate the service account as you.
In python you can do it by specifying credentials = credentials.create_delegated(user_email) when instantiating the service object.

answered May 5, 2020 at 15:43

ziganotschka

26.9k2 gold badges18 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Akhil Chakicherla Over a year ago

Thanks for your help!

Collectives™ on Stack Overflow

Google Sheets API - Python - Creating a Sheet

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related