Practical Business Python

Taking care of business, one python script at a time

Tue 09 June 2015

Collecting Data with Google Forms and Pandas

Posted by Chris Moffitt in articles   

Google Forms is a service that allows you to collect information via simple web forms. One of the useful features is that the forms will automatically save your data to a Google Sheet. This article will walk through how to create a form, authenticate using OAuth 2 and read all the responses into a pandas dataframe. Because the initial setup and authentication process is a little time consuming, this article will be the first in a two part series.