we need python live streams and do i need to keep all python methods example list do i need to save all methods in my brain and if i search for method i 'll be bad python dev
Being somewhat familiar with Sheet scripts was super helpful as a TA I set up a grading spreadsheet for the professor and myself and then wrote a script to export a separate document for each student. It saved me hours of typing.
Although this video is about google sheets it really helped me to get started with google docs api. Thanks Tim!, by the way I recommend you make a video that focuses on docs, it took me a long time to find those on the internet, It can help a lot of people.
In these videos about Google Sheets, I never find what I'm looking for. If I work with different spreadsheets, will I have to open the app code to change the IDs?
hey Tim i gotta question. How does automation work here? is it possible to set up a schedule for the script to run on a regular basis? if so, would your device/laptop need to be on and python running in the background for it to work?
Did you ever find a solution for your problem? Going to be tackling this problem shortly and I think I'm just going to setup a timer that will run anything that needs to update in a never-ending loop until I terminate the program.
II had trouble setting up the venv for windows, so if anyone else encounters this here was my solution. Running scripts seems to be disabled by default in PowerShell, so I first ran this command: "Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser". This allowed me to then run .\venv\Scripts\activate.ps1 (where venv is the name of your virtual environment), and my venv was up and running. Otherwise great video!
Really good work! You helped me in my project like you did in the past with your content. I do have one question though. How can you actually create a new workbook from scratch in google sheets. Reading the documentation didn't really help.
Is there a way to parse dates? I am getting this error while updating a date column in the sheet: TypeError: Object of type date is not JSON serializable
ERROR: Could not find a version that satisfies the requirement google-auth-oauth-lib (from versions: none) ERROR: No matching distribution found for google-auth-oauth-lib
Q: if I have a column with a text list like genres (action, adv, comedy, etc) is there a way in the python script so that each word of text have its own hex color? (Action=red hex code, comedy=yellow hex code) Ik it’s not possible in google sheet on its own. It’s a paaain going through each cell in google sheet.
I was having trouble activating the venv on windows. had to run the following to make it work: Set-ExecutionPolicy Unrestricted -Scope Process and the script to activate it was: PS C:\> \Scripts\Activate.ps1
When importing a csv into an existing sheet, the dates are being inserted with a ‘ in the beginning. So for example in the csv the date is 2024-04-19 on the google sheet it’s turning it into ‘2024-04-19 any help?
thank you tim. great tutorial to start understanding google sheet API. anyone can give me an idea why do we need an automation instead of editing directly in google sheet? what we can't do or it will be pain in the ass to do directly?
Thank you for the tutorial. I’m curious how this could involve working with the google drive python package. Would be nice to see a tutorial that involves have a dataset in python and need to save to a particular tab on a google sheet in a specific folder in my gdrive. Also add functionality such as, if the said folder does not exist, create it, etc.
when run code, i have errors in this line: workbook = client.open_by_url(sheet_id), and the error is: gspread.exceptions.APIError: APIError: [400]: This operation is not supported for this document, how do i fix this?
Nice vid, just need to find a free weekend soon to tinker around with this, maybe a data fetcher with various apis and then making a sheets based dashboard with backlinks.
