Insert Records To A Database From Google Sheets With Python

So recently I was helping a friend to streamline some of the workflows, and one of the task he does on almost daily is to take a Google Sheets report other team has updated and push the table into a database system.

In this video, I am going to show you how to use Python to export records from a Google Sheets to a database system (this can be any database such as SQL Server, Oracle, MySQL, SQLite, or even MS Access, as long as the database system supports ODBC Connection Manager). I will be using SQL Server as an example.

PS: Google offers unlimited Sheets API requests.

? Source Code: https://learndataanalysis.org/source-code-insert-records-to-from-google-sheets-and-a-database-with-python-and-sheets-api/

? Source Code (google_apis.py): https://learndataanalysis.org/google-py-file-source-code/

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
? Join Robinhood with my link and we'll both get a free stock: https://bit.ly/3iWr7LC

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------
? Becoming a Patreon supporter: https://www.patreon.com/JieJenn
? By shopping on Amazon → https://amzn.to/2JkGeMD
? Facebook Page → https://www.facebook.com/MadeInPython/
? More tutorial videos on my website → https://LearnDataAnalysis.org
✉️ Business Inquiring: [email protected]

#GoogleSheets #Python #Database #SheetsAPI