While working on projects, we frequently encounter challenges that require a software solution. Whenever possible, we open-source our solutions.
PHP Google Spreadsheet Connector
While developing a website, we encountered a challenge. We wanted to take information from a web-based form and submit it directly to Google Analytics. However, the webhost’s server configuration limited our ability to fully utilize Google’s standard PHP client libraries to connect with the spreadsheet API.
We also wanted a solution that was quickly reusable to scale to other applications.
So, we wrote the a Google Spreadsheet PHP-based form connector. It uses CURL as its primary interfacing point, and can be easily and quickly re-modified to fit other systems. A form submit posts through a PHP file into the Google spreadsheet of your choosing.
By using Google’s new Pivot Table options, it’s simple to create charts and tables that automatically update with each new submission (be sure to use A:A formatting for your ranges).
Credit: Mircea Rabaea, Public Learning Media
File: PLML-PHP-Google-Spreadsheet-Connector.zip
License: Open Source (MIT)
