Google Colab Tutorial - Google Sheets, Read & Write Data

Can you start a online classes for us on week offs.

This is so cool

Your videos amazing. Congrats for 100k. Keep doing.. I learned everything from your videos only. Could you plz do videos of “learn basics of python” and how can we use python in google sheets and docs. It would be more helpful.

Amazing!! I can save a lot of time using it. Thank you very much!

Wow.. I have been using your tutorials since long to develop small application for my organization.
You and Google keep surprising me.
Will try it out

Can we publish it as web app?

Excellent! Thank you!!

Congrats on 100K.

Anyway, I can call a Colab script from a button click on the sheet ?

Congratulations on your 100k subscribers achievement!

Man you don't know how you really helped me

please continue on with the colab videos. they're great and amazing to see how the power of python can be easily harnessed within a single environment.

Hi. I am having an issue with get_all_values. dates and even numbers is read as string. Is there any method to get data separately according to its dtypes(obejct, int, float) from google spread sheet from scratch.. thanks always.

Thanks a very good colab demo!

I have three tabs on a Google Sheet workbook where two of them are input tabs and the third one is an output tab. I can display on the third tab calculation results made on the input tabs; all the calculations are done on colab.

Others users (who doesnt have experience with colab) have to experiment and play with the numbers in the input tabs, and would like to see output on the third tab before reaching a desired final output numbers. The issue with this, as you can see, is multiple pulling from colab and pushing to GS - change input numbers -> see output -> improve input numbers --> see output .....

Do you know ways to make this less painful?

Thank you

Is it possible to create an integration between Google Apps Scripts and Google Colab?
The ideia wouble be to create like a menu in the Google Sheets Spreadsheet with Google Apps Scripts and the action would call a notebook in Google Colab?

Awesome !!!.
Could we install/use tensorflow in google colab?

Well done, Actionable lessons

Hello i just found a problem today that the update function to write from google colab to google sheet isn't available anymore. Can you help me solve this? Thankyou

Love you, really helpful.

Hi, is Colab able to join Data from many CSV files in the G Drive?

Thanks for the run through, awesome, thank you!

Is there a way to use Google Apps Script to run a Google colab notebook. I'm thinking of trying to have a sheets form that has a button which triggers a python script but lost on how to start that

Been watching your Google Apps Script videos, great work and quality of tutorial. Thank you. With this tutorial I am having issues loading a worksheet - I have a row above the headers/column labels that I don't want to use. I usually use skiprows=1 but this does not work with the.DataFrame.from_records() - Any suggestions appreciated (from anyone, and please don't say google it, i've been there and done that).

not only java script can....now python also can....!!!!...So which language is best to learn? I am starting to learn..now...

Awesome video. I tried to use import robin_stocks which works in jupyter but I got an error [ModuleNotFoundError: No module named 'robin_stocks'] in colab. Any ideas?

You have taught me so much! I was completely new to programming but I've watched all of your Google Apps Script videos and have been been able to create some cool projects. I am just wondering what you suggest I learn next? Should I start learning Python and using Colab? Any tutorials on the way for how to start using the advanced services?

Please make a video on how to get real time stock data in google sheet using colab

How can I convert JSON data and write into a google sheet with Colab?

worksheet.update([dataframe.columns.values.tolist()] + dataframe.values.tolist()) skips all those lines of code for u and imports pandas straight into the sheet

Nice videos, but, wtf, man? I mean, attach a copy of the code or the github.

thx

I am getting an error that "update is not an attribute of worksheet". Can you help?

Excellent video as usual...if i may add, can you plz put time stamps in your video..that would help us keep track much easily..thnx

such a great video, saved me so much time, thank you!!!!

Nice Video. What is the link to the documentation of various methods you are referring to in the video ?

On point

IDK what date this tutorial was made.
but, now
gc = gspread.authorize(GoogleCredentials.get_application_default())

refer to error.

any req except upgrade gspread?

could you please countinue after load gsheet in dataframe then making to plotting x,y and another chart. please

in case someone need this

from google.colab import auth
auth.authenticate_user()

import gspread
from google.auth import default
creds, _ = default()

Mille fois Merci (:

Is there a link to this actual colab somewhere? :)

Amazing content I have learned a lot from your content. Big thanks! Hope you are always healthy and happy

Thank you so much for this valuable content! :D

Please can we have access to the Google sheet used for this video ?

i am realy impressed you are maing us learn how to search

i love you

You Sir, are awesome. You are a life saver. You inspired me to learn Python.