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. Google Sheets API, 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 be showing you a very powerful tip – how to import Google Spreadsheet dataset into Pandas DataFrame using Google Sheets API.
import gsheet to dataframe.py