Google Sheets undoubtedly is one the most popular spreadsheet software in the industry today. Almost everyone who use Google have used Google Sheets at some point. In Microsoft Excel, there are VBA and Office for JavaScript API, but honestly, VBA is lacked the functionality of working with outside software, and Office for JavaScript… well it is JavaScript that’s all I can say.

Google Sheets API however, in my opinion, is one of the most versatile and powerful (stabled to since it is already on build v4) APIs when it comes to Google Suites Applications (Google Doc, Slides, GMAIL, etc). In this tutorial, I will show you a very powerful tip – how to import a Pandas DataFrame into a Google Spreadsheet using Google Sheets API.

Google.py
DF_To_GSheet.py