Posted in Google Apps for Business, Google Apps for Education, Google for Work, Google Spreadsheets

frevvo + Google Apps: Part 1. Save to a Google Sheet

Does your organization uses Google Apps? If so, you can combine frevvo + Google Sheets/Drive etc. to create some really cool and useful solutions. In this multi-part series of articles, we’ll explore several possibilities:

  1. Save submissions from a frevvo form into a Google Sheet (this article).
  2. Perform automated mileage calculations using the Google Maps API.
  3. Create dynamic drop down controls where the choices come form a Google Sheet.
  4. Update a Google Sheet with values from a form.
  5. Save documents generated by your frevvo form to Google Drive.
  6. Put it all together to create a leave approval workflow that connects with a Google Sheet, routes between multiple users for signatures, updates the Google Sheet and saves PDF documents to Google Drive.
  7. Single Sign On to frevvo using your Google Apps credentials.

Let’s look at the most basic and common use case. You have a form and you want to collect your submissions in a Google Sheet.

Step 1: First, you have to get an access token. This is a one-time step. Login to your Google account and then visit: Follow the prompts and copy the access token and save it. Detailed documentation is here.

Step 2: Create your form. We’ve created a simple example contact form with a few fields. If you need help creating a form, check out the Quick Demo and Form Designer tutorial videos on our website.

Contact Form
Contact Form

PropertiesStep 3: Create your Google Spreadsheet. Make sure the column header names match the Name property of each control. You can view the spreadsheet we created for the form above at this link (it’s read-only). See how the column names are Name, Email, Street, City etc. The Name property of the corresponding control in the form is set to match exactly.

Step 4: Connect your form to your spreadsheet using the Save to Google Sheets wizard. Detailed documentation is here. You must login using your user id and auth token (from Step 1), select a spreadsheet and worksheet and click Finish.

That’s it. When the form is submitted, the data will be saved to the selected Google Sheet. You can perform all the usual operations on the data e.g. see the Graphs Tab in our example sheet and you can see how we have created some sample graphs to analyze our submission data.

Google Spreadsheet graphs for submission data

Interested in learning more? Visit our website to view examples, watch videos, sign up for a free 30-day trial or contact us for more information.

Like what you see. Check out Part 2 which shows you how you can perform automated mileage calculations using the Google Maps API.

Leave a Reply