Google Sheets API in Python | Getting Started

Hi,
When I code in the vscode, there is no code autocomplete for Google sheet API. Anyone can help with this? Thanks.

where i can found secret_client.json jie? thank you

dir(service) isnt wokring gettting this error


him@HJ-Mac Jie Jenn % dir(service)
zsh: missing end of string

Hey


ModuleNotFoundError: No module named 'Google'

I cannot access to the sheet

Hey thank you for video its really helpful.

I got one error could you please help me out

oauthlib.oauth2.rfc6749.errors.MismatchingStateError: (mismatching_state) CSRF Warning! State not equal in request and response.

Hiii i can't access create_servie it's showing error no module as create_servie

Hey Jie, I had my app on testing mode and now I keep getting a Token has been expired or revoked error, I changed the app to publish mode like some users suggested, however I get the same error. Could you please help?

When I run the service = Create_Service() line I get the following traceback error,
raise JSONDecodeError("Expecting value", s, err.value) from None
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)
From what I've read it looks like something isn't being returned in JSON format, my traceback says that it's line 355, in raw_decode

hi, I've been following your tutorial but got an error 'redirect uri mismatch' when a chrome is opened for authorization. Any help on this? thanks, I appreciate your answer so much

OSError: [Errno 98] Address already in use

I seem to be sharing a port or something? - Anyway I can get around this?

ANY HELP !
[Errno 2] No such file or directory: 'Client_Secret.json'

Thanks

Hey there,
Everything's fine (except for Line 1 but that's ok) but what is not is I don't get the browser to open to authenticate once I run the last line (Create_Service) in VSCode. No error message nothing...any help please.

Hi and thanks for the video. When I run the code I have : Client secrets must be for a web or installed app. Any clue on how to clear this ?
Thanks !

Hi! Thanks, for videos! I have a little problem: when I importing 'from google.auth.transport.requests import Request' i have errors: 1. No name 'auth' in 1module 'google', 2. Unable to import 'google.auth.transport.requests'. Maybe you know where is the problem?

Hi Jay! Thanks a lot for this awesome series. I have followed everything you have demonstrated, but getting a weird error:

from Google import Create_Service
ModuleNotFoundError: No module named 'Google'

could you please suggest what I have been doing wrong? Many Thanks

for me, it's waiting for the localhost very long, Once after I gave allow to my account and sheets & Drives.
Can you please help me? that would be really helpful for me :)

Hello, i'm trying to call the google homegraph api however when i run the code with the scope changed for the homegraph api it says error 400: authorization error, do you know how to fix this?