JotSheets allows you to create Webhook integrations that connects your JotForms to Google Spreadsheets. With JotSheets, you can connect a form to multiple sheets, with various different form field mappings with only a couple of mouse clicks.
JotSheets was developed as an internship project at JotForm.
- PHP 7 or higher
- mySQL or MariaDB
- Google APIs Client Library for PHP
- JotForm API Client for PHP
- Apache server with RewriteEngine on
- This project uses HTML5Sortable JavaScript library for drag & drop sort buttons.
After downloading the release, you need to do the following changes in order to make the script work.
- Create a database and import
./db.sql
- Fill in the necessary database details inside
./class/db.php
- Update the server information in
./class/server.php
- Fill in the API keys in
./class/google.php
- Install Google APIs Client Library for PHP under
./class/google/
. - Install JotForm API Client for PHP under
./class/jotform/
.
- The Google integrations class will look for the autoloader at the following location:
./class/google/vendor/autoload.php
- The JotForm integrations class will look for the JotForm API Client at the following location:
./class/jotform/JotForm.php
- Please make sure that both classes can read the library files properly.
Available at http://jotform.ozanalpay.com
Please create an issue, or directly submit a pull request. They are always appreciated.