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.
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.
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.
Hi Tim, merry christmas! Great video, like all your other content. I'm also watching some of your videos about langchain, astradb and langflow, and I was wondering, is it possible consume the data in a sheet through this API in an AI app? I figured out that, in astradb, there's a section called Streaming, that allows to select Google Cloud, but I know almost nothing about cloud. If this is the correct tool for doing a stuff like this, I'd appreciate a lot a video showing how to do it. Thanks a lot, greetings from Argentina!
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.
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!
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?
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.
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
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?
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?
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
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
Secure your business effortlessly with a 3-month NordPass trial! Use ”'techwithtim”' activation code at nordpass.com/techwithtim. Limited time offer!
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.
I tried many times to work with Google api with not success. After following this guide I made it. I swear to god you are the best!
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.
Dude your video gave me ideas to slack off even more at work, awesome lol!
Tim, once again you have created a quality tutorial. Kudos!
Well let's see, thanks for sharing and uploading updated programming content, greetings from Argentina
You are welcome!
It's hilarious that you got me this when I was trying to figure out how to import csv file data into Google Sheets!! THANK YOU SO MUCH
you saved my job bro, love from India
Как же ты крут!
Видимо мой уровень чтения документации низок. Ты мне очень помог спасибо.
Great tutorial Tim!
Beautiful and concise step by step, much appreciated! 🍻
Saves me a ton of time vs doing it solo!
More google sheets! ❤
Grate tutorial man 🎉🎉, Can you please make a tutorial for google drive automation...
Good sheet Tim.
This was awesome! it would be awesome to get a similar video for the google forms API!
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?
Would love to see your tutorials start with a demo, show actual use cases - and then proceed with the tutorial
Nice tutorial!
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?
+1 I want to know that as well
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.
Thank you!!! It helped me. It's my first try using APIS. I'm trying with B4A the next part after downloading the credentials
This is the video I need, can you also make a video on Google Calendar API?
great video as always 👌
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.
This is very helpful! Can you please do more videos for automation on google sheets, excel or even a tutorial for Zipper. Thank you!
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.
Ps Side question : Do you have any productivity tips relatted to the coding domain?
Hi Tim, merry christmas! Great video, like all your other content. I'm also watching some of your videos about langchain, astradb and langflow, and I was wondering, is it possible consume the data in a sheet through this API in an AI app?
I figured out that, in astradb, there's a section called Streaming, that allows to select Google Cloud, but I know almost nothing about cloud. If this is the correct tool for doing a stuff like this, I'd appreciate a lot a video showing how to do it.
Thanks a lot, greetings from Argentina!
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.
How much can we use the api, asking for the restrictions on the free account
Hi, good tutorial. Do you know where I can find out how to automatically add new entries to a google sheet from web scraped data?
Thanks for making this super awesome video 👍
Glad you liked it!
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!
I did like 30m of research before checking the comments. You're a lifesaver bro, big asf 'Thank You' 🙏🏽🙏🏽🙏🏽
Thank you! You're a Godsent
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?
Merci beaucoup (:
You rock!!
TRIMAKASIH TEACHER
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.
Bro can you make it on Excel?
Yes I have an entire video that shows the same process for excel
@@TechWithTim ok now I need to watch it thx mate
@@TechWithTim Broo please what do you use to grow your facial bears ??
Why can't I select internal on the OAuth consent screen. Only external is available. If I select external can my spreadsheets be accessed by others?
thanks
Does that also work with excel, are google sheet and excel the same?
thanks🤩
First one,,
please make other videos about keyword planner and google drive
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
Bro, can you make some python project that connect to firebase?
i think you forgot to add the required library list to the github , can u please update that?
If you are using anaconda when you start a new environment make sure to install pip so you can install the google packages
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?
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?
I found the problem is i must convert xlsx to google drive format and the code worked like a charm
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
check your virtual env
What is use for it
Google is unnecessarily complicated. I hate doing any dev work with Google's services, but their apps are nice lol...
First
😇
Google hates their users
ㅋ
second
Not very clear for windows users
What's not clear? There's only like 2 small things that are different
Excelent video!
Small fix for windows, the activate script is in a different place
./{project_folder}/Scripts/Activate.ps1
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
Great tutorial!