Insert Records To A Database From Google Sheets With Python

preview_player
Показать описание
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.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#GoogleSheets #Python #Database #SheetsAPI
Рекомендации по теме
Комментарии
Автор

hi sir, can you tell me how to create client-secret.json ?

muhammadmulyawan