Google Colab Tutorial - Google Sheets, Read & Write Data

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

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

Thank you so much for this valuable content! :D

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

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

Mille fois Merci (:

in case someone need this

from google.colab import auth
auth.authenticate_user()

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

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

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

refer to error.

any req except upgrade gspread?

On point

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

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

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

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

thx

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

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

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

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

How do you get the dataset example for the videos? I want to follow along but it's hard without having the data

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?

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?

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

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).

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

Thanks for the run through, awesome, thank you!

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

Love you, really helpful.

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

Well done, Actionable lessons

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

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?

Thank you

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?

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.

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.

Man you don't know how you really helped me

Congratulations on your 100k subscribers achievement!

Congrats on 100K.

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

Excellent! Thank you!!

Can we publish it as web app?

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

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

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.

This is so cool

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

Wonderful!!! Amazing!!! Nice video sirji i appreciate your work and sir please do make basic videos for this particular software and advance level videos also, as i don't belong to programming background so please do makes basics videos just like you did in apps scripts. And really your videos are very helpful to me. Once again i appreciate your work