Google Sheets Database with Python Web Scraping

We can use Google Sheets as a database for our Python Web Scrapers. In this video tutorial I will show you how to add new rows under each other to a Google Sheet from your Python script.

-------------------------------------
-------------------------------------
Disclaimer: These are affiliate links and as an Amazon Associate I earn from qualifying purchases

[InfinitycgIN]

Thanks a ton, your video helped me in reducing the code by almost 60%, I am a non programmer and was writing my script just by googling and YouTube. A massive thanks for the easy-going and straightforwardly understandable video with no clutter

[alexlytle]

dude thank you so much!! I get excited everytime you post a new video. Really high quality stuff mate.
I ran into this error "ImportError: No module named gspread". But i fixed it by running this into my python interpreter
import pip
pip.main(["install", "gspread"])

just in this happens to somebody else

[zjm]

This came at the perfect time. Looking forward to watching more of your videos

[justash]

SIR THIS IS THE BEST TUTORIAL EVER!
Im hosting a website using heroku but my manual database keep clearing after a few hours, but this is the perfect solution for that, tysm!

[AbdulMalik-rtvx]

Very useful and real life example! Thank you John!

[jamesmarx]

I find it really easy to learn from you. Thanks for making content!

[louisgirardin]

Great lesson with the right content and easy to follow ! Thx a ton.

[omarcedric]

Straightforward and concise. Thank you for this.

[ayencoscolfield]

Speechless as usual one word for you pal, awesome!!!

[gitgosc]

something new for me, thanks a lot, great channel!

[snapesrds]

Thanks You from deepest of my heart. ❤

[EUU]

Perfect, thank you for your effort and time Mr Rooney

[aysenurakdass]

Your video has been very helpful. Thank you so much.

[ahmadcooper]

Hey John, thanks for your videos, they're easy to understand and follow. After watching your Google News scraper video, and this video on how to scrape to Google Sheets, I'm wondering if you could make another video on "How to Scrape Google News to Google Sheets". I tried figuring it out myself but I only managed to get the first news article. Additionally, if its possible, a video on "How to append scrape data (i.e. Google News) to Excel"), or to create a new Sheet within an existing doc. If you could do any of those that would be amazing.

[wkowalski]

By any chance you think you could do a video about automating scrapers with cronjobs, and maybe even using launchd on Mac OS if you happen to know anything about that? Really glad I found your videos... They're really well done and very helpful.

[ianpropst-campbell]

Excellent tutorial! You mentioned something cron jobs. Do you have any tutorials about how to set those up?

[pedrofilhojp]

Obrigado pelo seu video. Ajudou muito na automatização de minha planilha. Show. Parabéns.

[gabefife]

Thank you so much, I do get an error that says I need to requests more quota but it doesn’t really effect it bc I still get what I want with it.

[DuckkkMr]

Thanks that is very helpful. I am looking to know how to import several row with several values (i.e I have a .csv with 400 rows and I want to upload these 400 rows into GSheet automatically) ? Right now it only insert the latest value of my .csv
Thanks !

[wangdanny]

Hey john, do you need to have to import my google sheet is not updated as the script tells