AET

I help manage an event where the exhibitors submit information through a Google Form that feeds a Google Spreadsheet. With over 300 entries and 50+ columns, information retrieval became quite a challenge. This software is an attempt to amend that. The python script grabs information from the spreadsheet and posts it to a Mongo database. Currently, the data is bring posted to Mongolabs.

Code is on Github

The gspread library made the whole process seamless. As long as a gmail email address has access to the spreadsheet, everything falls in place.

python_logo.png