2 year ago I knew nothing about coding and found this video fascinating and confusing. Today I needed to manipulate Google Sheets via code and found yet again this amazing video, it's pretty cool to see how things change.
Are you a comp sci major? I am a freshman in college as a general engineer and I want to do comp sci because I see how useful it is but I have almost ZERO coding experience... Idk if I should risk it
Absolutely perfect youtube video. Superb voice and video quality. No flashy long intros. Short and to the point whilst explaining everything perfectly. Needless to say, I'm in love with this channel now! Good stuff man!
Accessing data on the cloud without messing around with databases or ssh and using python? I've been looking for something like this for years, thank you!
Will Bobson gotta take into account cost. Aws May have free trials but isn’t free forever. For an enterprise solution awe is the clear answer, but for a fun side project this is a great workaround
This video is inspiring, but it’s missing something. A CRUD application like this might be possible, you have first to mess around with OAuth and try to handle multiple accounts that can access to a doc
This is fucking amazing. Thank you! This will be great to teach my students because installing postgresql is a difficult process & most students get lost in just the installation process let alone trying to understand how databases work. Spreadsheets are WAY more intuitive and you already have a nice "GUI" to play around with the data.
Quick question, I'm trying to make a very basic flask todo list app with crud functionality using this gspread idea. Would it be so slow that it would render it useless or you think it'll still work?
Easily the best how to coding video I think I've ever seen. Clarity, completeness, pace, accessible for a beginner but not condescending to an expert. Massive kudos - you have a knack for this.
In my experience, now you have to add the Google Sheets API in addition to the Google Drive API to the project to have access to the sheets with python
I built an API in python to do my work in exell and I still got paid at the end of the month for 4 months before I got bored of playing games in my cubical and maintaining my API and adapting it to new work requirements... I did post it on my GitHub but no one wanted it since you do need to configure it to do your specific work, but I didn't have any documentation so.... Basically what my work was: check growth margin from the last hour, day, week, month, year and run a formula which will give me the expected growth in the next year... It was a bit hard since my company works with many articles so I had to do that for as many articles as I can in one day so I just built an API, gave it the data it needs and it gave me the finished product, I entered it in the Excell and I was done for the day.... 30 minutes and I am done for the next 7:30 hrs I could have spilled the truth and gave my API to my co-workers but then I'd run the risk of being fired because once the boss finds out he doesn't need 3 workers, he is going to fire 2 and keep 1 to do all of the work....
Honestly, if you made something like that. Boss probably would have kept you as the one worker and given you a raise. But then you just got your two coworkers fired and that's not too good
@@carsoncase223 This has not been my experience. I once made the mistake of streamlining a process that used to take 8 hours a day and made it take 20 minutes through some API work. Showed my boss that I had saved the company 8 hours of labour weekly (Was only run on Mondays) and the result was that I was given a stack of processes to streamline in a addition to the now 32 hours of work a week plus 8 more hours to round it out. I should also note that my job has nothing to do with programming, its data analysis and projections. But showing my boss that I had some very modest programming skills from hobby work had him shoving impossible tasks my way because, "You can get 8 hours of work done in 30".
@@Adaephonable Damn. That's pretty brutal. Should've started a company and sold the tech to your boss. No way he'll know it's made by a modest programer as opposed to a pro. Although, that's probably more effort than it's worth I guess
🔥 WATCH NEXT: Build an Animal Crossing price lookup bot with Google Sheets and WhatsApp ua-cam.com/video/eqtQ76X_owQ/v-deo.html If you're running into insufficient permission errors, update the scope in the code to: scope = ['spreadsheets.google.com/feeds', 'www.googleapis.com/auth/drive']
The best programming tutorial on UA-cam by far. Clear, concise, to the point, and never once succumbing to the familiar social media urge to "mix things up." Thank you.
Where can we easily get help with things like this? Is there any one place you'd recommend to help troubleshoot? I have a fairly simple question but I know it's frowned upon to ask it in the comments section. :)
That is a thing of beauty. I am a Google Sheets maniac. I learned some Python a while ago but thought I'd need Javascript to write scripts for Sheets. This video is a real eye-opener.
Great video. I had a permission issue but i changed the url based on your description and enabled both google drive and google spreadsheets and it worked like charm. Thanks again!
Really handy for smaller applications where you don't need any headers or relational links. You can get both of those with a little bit of workarounds, but if you needed those, you might as well have put the stuff in a more conventional database anyway.
The best part about this is that you can easily create charts & snippets from the database which you can embed in your website (with real time updates!) That is truly a great option. My only concern is concureent access and throughput, which probably isn't that great. But for many applications, ut'a definitely sufficient.
Great video, I've been meaning to do something like this ever since I saw Travis from DevTips use the google sheets as a data base for his email inputs.
I think it will be next to impossible to set our rules for such a thing. Sometimes when I watch certain channels I have to watch the same intro again and again ... it is not that they aren't impressive, but it does get tedious after a while. I guess was just pleasantly surprise when I watched your video. The no nonsense, the speed of progress, the voiceover and the idea. Great job ^_^
Thanks Twilio. What is the performance of gspread compared to google-apps-script? Also can you use gspread in the web app (by django) to extract/write data from/to google sheets at the same time as the data gets extracted/written from/to database?
Wonderful video! Very clear, a pleasure to watch... and super useful! The only thing missing for me so that I can do what I want would be a simple way to trigger the code from a button inside the google sheet. The code would be running on amazon aws for instance. Do you see a simple way of doing this? Thanks!
Twilio, will you make a video that uses a service from AWS or Microsoft that puts your python function on a timer automating it to update your google sheets?
Thanks for this. Stumbled on this completely by chance and I'll be able to use it. One question: is there any way to look at a sheet "revision" to see if it's been changed recently? I'd prefer a subscriber concept where I'm alerted of a change but will settle for poking the sheet to look for changes. Thinking of using this for a distributed system where one person puts in information and another can use it in (somewhat) real time.
Great video! I want to ask if speed is not my concern for my application when accessing the data, can I combine multiple spreadsheet to make an large scale (~100,000 row) actual database? Then i'll have an free mysql lying around for me to use
Is there any way to find a specific value in the spreadsheet within the API without having to get all of the records? BTW loved the video I hope you upload more of these kind of videos.
when i do "pip install gspread oath2client" on my mac I keep getting "No matching distribution found for gspread" when i run pip2, and "No matching distribution found for oath2client" when i run it with pip3
7 років тому
Congratulations, You Just earnt my subscription, Awesome, simple, and lot's of Ideas Just came to mind. Thanks. simple, readable, even not in full screen, easy explained, direct instructions. and etc.
Hi, can you give a list of the software you used in the tutorial? I'm interested in the terminal. Also, did you record every app in full screen or you edited the borders out? Thank you for the great video!
Well... is there anyway you could add to this the web interface? I am trying to research how to interface to googlesheets via browser... and you just made me smile. Could you do a small web interface to maybe add a to a sheet from a web form?
This is cool, but can it do more advanced things like setting formulas or style in a cell? I once had a jython project where I used the apache-poi java library in conjunction with hibernate from python to generate excel sheets for another service and it worked but startup was really slow compared to pure java code. But it was cool nevertheless. IMO apache-poi is the most comprehensive library for manipulating spreadsheets. Can that gspread lib use local files as well?
I got to about 2:40 in the video and when I try to print out the data from the spreadsheet i get permission errors (error 403). Did i set up something wrong? edit: I just had to enable google sheets API in my settings googleapi settings to fix this
I'm definitely a beginner to this, when you type in the console, what console are you typing into? Python console? Terminal (Mac), the console on windows. Help im lost.
this is really intresting. but i have a question ( i did not do any digging ): i m working on a node js app so is it possible to do this in javascript ? or is it possible to use python like you did and somehow integrate it in the node app ? And thanks :)
Hi, Is there any way to handle 2nd or 3rd google spreadsheet? When I wrote sheet 2 or sheet 3 instead of sheet 1, I faced an error. Thank you so much for an awesome video.
I did exactly what was in the video and it worked perfectly. However after a couple days it gave me an Invalid Credentials error when I leave my program running and I'm not sure what that happened
You may want to try the code listed in this GitHub issues answer if you have long running code. You may need to use a refresh token: github.com/burnash/gspread/issues/333#issuecomment-166398290
I am trying to do the same thing in my organization, but while inserting the client_email in Google sheets for sharing it says i cannot share this document with anyone outside the organization. Any immediate help on this would really be appreciated. Thanks.
2 year ago I knew nothing about coding and found this video fascinating and confusing.
Today I needed to manipulate Google Sheets via code and found yet again this amazing video, it's pretty cool to see how things change.
I’m so happy to hear this! Glad we could help :)
Even I'm bit confused. I have just started with python. I want to try this but I have to know a lot more about what's Google API, Spreadsheet,....
i want to do a project with this but im not sure what yet
@@siddietrich5652Let me give you a challenge, try making a game, any game, as simple as it is, it may be pretty fun to code something like that.
Are you a comp sci major? I am a freshman in college as a general engineer and I want to do comp sci because I see how useful it is but I have almost ZERO coding experience... Idk if I should risk it
Absolutely perfect youtube video. Superb voice and video quality. No flashy long intros. Short and to the point whilst explaining everything perfectly. Needless to say, I'm in love with this channel now! Good stuff man!
Harrison If I had to quibble, I'd recommend adding a description.
Well said
Accessing data on the cloud without messing around with databases or ssh and using python? I've been looking for something like this for years, thank you!
How about RESTful post or put? How about AWS s3 bucket, Google drive or Dropbox API?
Will Bobson gotta take into account cost. Aws May have free trials but isn’t free forever. For an enterprise solution awe is the clear answer, but for a fun side project this is a great workaround
@@huckthatdish actually a lot of free tier is permanent now.
This video is inspiring, but it’s missing something. A CRUD application like this might be possible, you have first to mess around with OAuth and try to handle multiple accounts that can access to a doc
This is fucking amazing. Thank you! This will be great to teach my students because installing postgresql is a difficult process & most students get lost in just the installation process let alone trying to understand how databases work. Spreadsheets are WAY more intuitive and you already have a nice "GUI" to play around with the data.
Yeah, that's what I meant! Start with this so they can understand how databases work & then move them on to real databases.
Quick question, I'm trying to make a very basic flask todo list app with crud functionality using this gspread idea. Would it be so slow that it would render it useless or you think it'll still work?
immature swearing
You really should just be teaching them to use SQLite for early database lessons in Python.
Hey clever programmer bro i watch your videos of python, you teach me enough that my prof. cant teach
Easily the best how to coding video I think I've ever seen. Clarity, completeness, pace, accessible for a beginner but not condescending to an expert. Massive kudos - you have a knack for this.
I’ve got no idea what any of this means but I liked this video
Haha same
In my experience, now you have to add the Google Sheets API in addition to the Google Drive API to the project to have access to the sheets with python
Lifesaver, thanks. You just saved me at least an hour of head-scratching.
I built an API in python to do my work in exell and I still got paid at the end of the month for 4 months before I got bored of playing games in my cubical and maintaining my API and adapting it to new work requirements... I did post it on my GitHub but no one wanted it since you do need to configure it to do your specific work, but I didn't have any documentation so....
Basically what my work was: check growth margin from the last hour, day, week, month, year and run a formula which will give me the expected growth in the next year... It was a bit hard since my company works with many articles so I had to do that for as many articles as I can in one day so I just built an API, gave it the data it needs and it gave me the finished product, I entered it in the Excell and I was done for the day.... 30 minutes and I am done for the next 7:30 hrs
I could have spilled the truth and gave my API to my co-workers but then I'd run the risk of being fired because once the boss finds out he doesn't need 3 workers, he is going to fire 2 and keep 1 to do all of the work....
What's your github, looks like a interesting api to tweak around with
Honestly, if you made something like that. Boss probably would have kept you as the one worker and given you a raise. But then you just got your two coworkers fired and that's not too good
@@carsoncase223 This has not been my experience. I once made the mistake of streamlining a process that used to take 8 hours a day and made it take 20 minutes through some API work. Showed my boss that I had saved the company 8 hours of labour weekly (Was only run on Mondays) and the result was that I was given a stack of processes to streamline in a addition to the now 32 hours of work a week plus 8 more hours to round it out. I should also note that my job has nothing to do with programming, its data analysis and projections. But showing my boss that I had some very modest programming skills from hobby work had him shoving impossible tasks my way because, "You can get 8 hours of work done in 30".
@@Adaephonable Damn. That's pretty brutal. Should've started a company and sold the tech to your boss. No way he'll know it's made by a modest programer as opposed to a pro. Although, that's probably more effort than it's worth I guess
@@Adaephonable its because youre a little twit and you dont dare to ask for a raise for doing more work
Not sure why Twilio made this video, but I am thankful.
Great vid.
it's called content marketing :)
Twilio thanks for doing this, these videos are super helpful and you have no reason to make them other than the fact you’re a good company!
@@escherlies the only kind of marketing i am down with
🔥 WATCH NEXT: Build an Animal Crossing price lookup bot with Google Sheets and WhatsApp ua-cam.com/video/eqtQ76X_owQ/v-deo.html
If you're running into insufficient permission errors, update the scope in the code to:
scope = ['spreadsheets.google.com/feeds', 'www.googleapis.com/auth/drive']
Thanks! I also had to enable Google Sheets API on my project.
Thanks! Solves my issue as well.
can you please explain why this is? just wanted to learn the reasoning :)
Thank you!!!!!, your revised scope worked!
Twilio *****
I think I now know what it feels like to be an old person listening to young people talk about computers
✋ ✋ ✋
The best programming tutorial on UA-cam by far. Clear, concise, to the point, and never once succumbing to the familiar social media urge to "mix things up." Thank you.
I'm glad this came up in my recommended. This is brilliant instead of buying a server/hosting off your own machine for a basic in-house project
Thank god, someone can explain something simply!!!!!! Google's own python quick start guide left me with errors and no idea what was going wrong.
Never really comment on videos, but I must say that this is a great video, straight to the point, fast and just really great.
This is a perfect tutorial, no messing just so well done well scripted and well edited.
Where can we easily get help with things like this? Is there any one place you'd recommend to help troubleshoot?
I have a fairly simple question but I know it's frowned upon to ask it in the comments section. :)
I'm learning to write neural nets so seeing normal code for a change helps to keep me sane.
>2017
>not using Jupyter and Pandas :)
But seriously: good video! Not many programming yt-videos have such a nice paced explanation
That is a thing of beauty. I am a Google Sheets maniac. I learned some Python a while ago but thought I'd need Javascript to write scripts for Sheets. This video is a real eye-opener.
It's stupid how difficult it is to find a nice tutorial with decent planning in the video by someone that speaks at least decent English. Thanks!
Thanks for watching and you’re welcome!
Great video. I had a permission issue but i changed the url based on your description and enabled both google drive and google spreadsheets and it worked like charm. Thanks again!
Thanks for watching!
this is so freaking cool!!!
This video was amazing. Simple and easy to follow if you have had any experience with python. Great work
Interesting indeed. But I still prefer SQLite hahaha.
Can you update this? I am getting import errors since it seems that ServiceAccountCredentials is no longer in use
That's cool and all, but can it run doom?
Coloured Spreadsheets would allow a Multiplayer experience. Just imagine how great this would be!
Interesting Idea, I wonder what the latency is like.
I don't know coding but I loved it
Yeah. It just feels satisfying seeing how nicely it works. :)
I actually never thought about doing this even though I use google's javascript API all the time in spreadsheets.
It's pretty powerful especially when teams are already collaborating inside of Google Sheets.
If the spreadsheet updates quick enough, cant you make animations by coloring the cells?
Just tested, seems like its too slow :/
Man, and I thought I stumbled on something ridiculously delightful :D
darn would have been really funny to see a video playing in sheets with the cells as pixels.
I'm definitely going to try that and make it work somehow
Did you make it work somehow?
I don't even know how to create a graph in exel but the way this video us made it remains easily interesting enough for me to finish watching it.
best teaching video I have watched in my life. Speed is perfect.
I tired to use the Google Sheets API for PHP.
*PTSD flashbacks*
Never again.
Why?
Que?
Warum?
どうして？
Почему?
This is so cool! I hated the thought of even hearing the word database for years, this is such a game changer. Very cool video, keep it up.
Thanks for watching, glad it could help!
Good tutorial. Also very easy to understand what you are saying, you have a very clear and understandable voice.
Thanks for watching and for the kind words!
Really handy for smaller applications where you don't need any headers or relational links. You can get both of those with a little bit of workarounds, but if you needed those, you might as well have put the stuff in a more conventional database anyway.
Why didn't I find it earlier? Just brilliant. On point. No complicacy. Clap worthy really👏👏👏👏👏👏
holy after hours of trying to get this thing to work, it finally worked and I'm so excited
I’m glad you got it working!
Relly good! Clear, straight to the point perfect quality and a very pleasent voice. - And on top I got some new Ideas! Thx
I'm so glad I came across this video. It was very nicely done and quickly got me up to speed with gspread, an amazing python library.
The best part about this is that you can easily create charts & snippets from the database which you can embed in your website (with real time updates!) That is truly a great option.
My only concern is concureent access and throughput, which probably isn't that great. But for many applications, ut'a definitely sufficient.
It’s missing something, though it blew my mind a few years ago and I’m here again because it’s a simple idea yet amazing.
This is genius!! No server, built-in data and API!!
I did it from my Windows 10 Ent with python 3.6 worked seamlessly. thank you
Now I can say that I understood a python code :)
You are such a great person MAN. I love you for this great stuff.
Can't express how excited I'm right now.
Thanks for watching!
If only all tutorials were like this tutorial
I love how it's easy code awesome things with Python (and of course good libs)
An amazingly clear and simple video that works. And even better you kept it up to date... Go you!
Great video, I've been meaning to do something like this ever since I saw Travis from DevTips use the google sheets as a data base for his email inputs.
Love this format - great presentation! Such a relief not having to sit through a long into segment...
I think it will be next to impossible to set our rules for such a thing. Sometimes when I watch certain channels I have to watch the same intro again and again ... it is not that they aren't impressive, but it does get tedious after a while.
I guess was just pleasantly surprise when I watched your video. The no nonsense, the speed of progress, the voiceover and the idea. Great job ^_^
This channel is gonna grow so fast I can see it already
I m gettin excited when I see something like this. How did you learn this? and which university you graduated?
Just google: "Python beginner course" and click the first free link.
Thanks Twilio. What is the performance of gspread compared to google-apps-script? Also can you use gspread in the web app (by django) to extract/write data from/to google sheets at the same time as the data gets extracted/written from/to database?
works like a charm, thanks @Twilio!
updating the scope did the trick
Wonderful video! Very clear, a pleasure to watch... and super useful! The only thing missing for me so that I can do what I want would be a simple way to trigger the code from a button inside the google sheet. The code would be running on amazon aws for instance. Do you see a simple way of doing this? Thanks!
This is really Cool. Especially for people who have had no Background in Dbs.
Twilio, will you make a video that uses a service from AWS or Microsoft that puts your python function on a timer automating it to update your google sheets?
well I 've been searching for such video for a millennium! Thx Twilio
Was doing this since at least 2010 with Google spreadsheets and PHP. It's nice to see other languages evolving
Thanks for this. Stumbled on this completely by chance and I'll be able to use it. One question: is there any way to look at a sheet "revision" to see if it's been changed recently? I'd prefer a subscriber concept where I'm alerted of a change but will settle for poking the sheet to look for changes. Thinking of using this for a distributed system where one person puts in information and another can use it in (somewhat) real time.
Great video! I want to ask if speed is not my concern for my application when accessing the data, can I combine multiple spreadsheet to make an large scale (~100,000 row) actual database? Then i'll have an free mysql lying around for me to use
Awesome video! Gonna use this to access my school docs and automatically update them.
I'm a noob but I love this so much! Thanks for this introduction, eventhough I'm late to the party. :-)
Never too late to party with code 🎉
Nice. I don't know what i am going to use this for yet. But still super nice to know it's available!
Amazing really, I'm just starting to learn Python and all I can only say really simple and impressive , Thanks for the video.
Is there any way to find a specific value in the spreadsheet within the API without having to get all of the records? BTW loved the video I hope you upload more of these kind of videos.
finally got what i actually wanted :)
awesome work Twilio (y)
Hmm... saved for later, when i actually know what you are talking about^^ currently learning javascript to get custom functions for GS
i always wanted to learn coding.. this is so easy to understand.. thanks
Oh you should have shown the Revision History.. that would have been fun to see!
Another programmer from Pennsylvania! Who woulda thought.
Thanks for watching! -A programmer from the Keystone State, probably
when i do "pip install gspread oath2client" on my mac I keep getting "No matching distribution found for gspread" when i run pip2, and "No matching distribution found for oath2client" when i run it with pip3
Congratulations, You Just earnt my subscription, Awesome, simple, and lot's of Ideas Just came to mind. Thanks. simple, readable, even not in full screen, easy explained, direct instructions. and etc.
Hi, can you give a list of the software you used in the tutorial? I'm interested in the terminal. Also, did you record every app in full screen or you edited the borders out?
Thank you for the great video!
great video! what terminal setup are you using?
Very interesting, I don't see an actual use for me right now but looks really fun I'd like to try it out XD
Awesome :) Thanks for sharing. Do you plan any further tutorials on this subject?
I am new to coding, Python is my fitst programming language. There are just few good tutorolials on working with APIs .. would love to learn more!
Can you use python to automate spreadsheets instead of javascript/google apps script? Or is it more limited with python?
Thanks
You can do the same types of things with Python.
Wow. This is powerful!
Looking forward to using this for a project
@Twilio how to add a new spread sheet in gdrive ... Basically I need to create and populate a new Google Sheet every time I run a scrapper ....
Simple and Effective. Thanks for sharing with us!
this is the kind of content that I like, subscribed.
Thanks for watching!
Nice and clean tutorial. All relevant information. Good job.
such a nice job of keeping it simple and clean. Thank you! Subscribed.
Waho i didn't know your channel, it seems to be a mine of gold !
Thanks for watching!
Very useful. This gets me yet another step closer towards my maniacal takeover of Google! Muahaha🗯
Well... is there anyway you could add to this the web interface? I am trying to research how to interface to googlesheets via browser... and you just made me smile. Could you do a small web interface to maybe add a to a sheet from a web form?
Hello! Great video, thank's!
I have one question - how to update whole sheet with the data in xls or csv file?
Screen text so sharp it almost cuts. This is a REALLY great video. Good job Twilio!
How did you record it?
Nice practical emphasis Twilio Team.
Keep it up!
This is cool, but can it do more advanced things like setting formulas or style in a cell? I once had a jython project where I used the apache-poi java library in conjunction with hibernate from python to generate excel sheets for another service and it worked but startup was really slow compared to pure java code. But it was cool nevertheless. IMO apache-poi is the most comprehensive library for manipulating spreadsheets. Can that gspread lib use local files as well?
this channel deserves more subscribers
I got to about 2:40 in the video and when I try to print out the data from the spreadsheet i get permission errors (error 403). Did i set up something wrong?
edit: I just had to enable google sheets API in my settings googleapi settings to fix this
Glad you got it working!!
I'm definitely a beginner to this, when you type in the console, what console are you typing into? Python console? Terminal (Mac), the console on windows. Help im lost.
this is really intresting. but i have a question ( i did not do any digging ): i m working on a node js app so is it possible to do this in javascript ? or is it possible to use python like you did and somehow integrate it in the node app ? And thanks :)
Great video, nicely explained
Hi, Is there any way to handle 2nd or 3rd google spreadsheet? When I wrote sheet 2 or sheet 3 instead of sheet 1, I faced an error. Thank you so much for an awesome video.
I laughed so hard at "glorious list of perfectly formatted content"
Spl33ney It really was a bit of a jumbled mess, right?
I did exactly what was in the video and it worked perfectly. However after a couple days it gave me an Invalid Credentials error when I leave my program running
and I'm not sure what that happened
You may want to try the code listed in this GitHub issues answer if you have long running code. You may need to use a refresh token: github.com/burnash/gspread/issues/333#issuecomment-166398290
I am trying to do the same thing in my organization, but while inserting the client_email in Google sheets for sharing it says i cannot share this document with anyone outside the organization. Any immediate help on this would really be appreciated. Thanks.
Please remember when inserting into the DB to replace any = signs with "= (unless you need math operation to work)