Google Sheets - Python API, Read & Write Data



Learn how to use Python and Google Sheets API to read and write data to a spreadsheet with a service account.

Resources:
https://console.developers.google.com
https://developers.google.com/sheets/api/quickstart/python
https://developers.google.com/identity/protocols/oauth2/service-account#python
https://www.python.org/
https://code.visualstudio.com/
https://developers.google.com/sheets/api/reference/rest

#Python #api #google #sheets #read #write

source

29 thoughts on “Google Sheets – Python API, Read & Write Data”
  1. Thanks for making this, I have a problem with while reading the data(can able to read the data, but the data is not formated) from google spread sheet

    Sample data
    1;03.05.2022 00:12:14;1,04992;1,05079;

    Column separator is ;

    but the problem is data's are reading in different format,
    existing output:
    1;03.05.2022 00:12:14;1, 04992;1, 05079;

    expected output
    1 03.05.2022 00:12:14 1,04992 1,05079

  2. Hi, could you please make a tutorial about how to implement the validation "List from a range" , I would appreciate it, thanks

  3. I have a simpler way like this:

    We create a sheet, importrange data on to this sheet then use protection (only me) on it. then other people can use this data on other sheets

  4. Really appreciate for creating this video. Was following the Google API docs and went into error loops. Following exactly what you mentioned worked. Thanks a ton. Cheers!

  5. Thank you for explaining it so good. You should continue publishing your easy way of explaining more often.

  6. Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

  7. Hello, I was wondering how you would format cells. Such as background color, text size, text color, merging cells ect.

  8. ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1131) i followed the video and this error occured. How to resolve this? please reply

  9. Thank you! I'm trying now to connect to slides with the spreadsheet data and write to slides from within a single project. Seems like i will have 2 scopes and 2 services and 2 keys? But there's no where I can find that clearly shows how those connect in a single project. I send examples of 2 scopes, and I've tried creating the 2 services just like you've created the one for spreadsheet. But I don't see how to manage the 2 separate keys and I'm getting token errors. Thanks for any advice , example out there in the universe…:)

  10. I cannot tell you how great this video is. Literally so much easier to follow than googles documentation. Thank you so much.

  11. Thank you so much! I have spent a while trying to learn this api and you made it incredibly easy and well explained! +1 sub :))

Leave a Reply

Your email address will not be published.

Captcha loading...