The following code can be used to get data from google sheets to your jupyter notebook.
Please ensure you have downloaded your credential file from google console first and rename it to "credentials.json" Ensure the credential json is in the same directory as the ipbyn file attached.
Ensure you have added the email in your credential file to the google sheet you'll be pulling from.
Enjoy!