Form responses to Google Sheets

Form responses to Google Sheets
Buy    $19.99

Version 1.00
Author WannaCo
License: ImpressPages
Download count for paid plugins is not available

Store form submissions in Google Sheets

Description

Collect Form submissions in Google Sheets.  

Forms submitted will create a Sheet in a Google Spreadsheet on the fly with the Name of the Page the form is on, will set the column headers and record a time stamp along with the form data. Sheets are created each time a new form is added and submitted. We recommend not adding more than one form per page. 

You can share the form afterwards and collaborate with your teams easily. Boost productivity and create leads based on you Form submissions.

See the Spreadsheet in action HERE!!!!!!!  you can fill out the form HERE!!!! 

Installation

Install the plugin as usual in ImpressPages CMS

Once installed you need to get a web app apps script url and paste it in the field as indicated in the image

To get the Web App running follow these steps:

  1. Create or open a spreadsheet in Google Sheets.
  2. Select the menu item Tools > Script editor. If you are presented with a welcome screen, click Blank Project on the left to start a new project.
  3. Delete any code in the script editor. Copy the code in the appsscript.txt file found in the plugins main direcotry and paste the code into the script editor. 
  4. Copy the spreadsheet URL and paste it where indicated in the code you copy from appscript.txt (its in line 14 with the comment "//Add the url until the /edit part")
  5. Select the menu item File > Save. Give the script project a name and click OK.

Deploying a script as a web appTo publish a script as a web app, follow these steps:


  1. Save a new version of the script by selecting File > Manage Versions, then Save New Version.
  2. Select Publish > Deploy as web app.
  3. Under Project version, select the version you just saved.
  4. Under Execute the app as, select whose authorization the app should run with: your account (the developer's).
  5. Under Who has access to the app, select who should be allowed to visit it. The options must be "Anyone, even anonymous" (@gmail.com accounts ).
  6. Click Deploy. Once you click Deploy, you'll see a new dialog with a message indicating that your project has been successfully deployed as a web app.


This dialog provides two important URLs for your app:

The first is labeled Current web app URL and ends in /exec. This URL is for the published version of your app, based on the last version you saved and deployed. The second is the link labeled latest code and ends in /dev. This URL can only be accessed by users who have edit access to the script. This instance of the app always runs the most recently saved code — not necessarily a formal version — and is intended for quick testing during development.

Go back to the Plugin settings page and Paste the URL.

Usage

Wait for visitors to fill out a form and visit your spreadsheet.