The information on this page refers to the Google Connector v1.4. Click here for the details about Google Connector v2.0.

Installation 

If you are using  In-house and have downloaded the Google Connector:

1.  rename the download file named connector-google-apps.zip to google.war copy google.war to cfile named connector-google-apps.zip to google.war
2.  copy google.war to c:\<frevvo-home>\tomcat\webapps
3. If you are using the tomcat-bundle, the google.war file is located in <frevvo-home>/ext/connectors. Copy the war file from this location to c:\<frevvo-home>\tomcat\webapps.

Tomcat will automatically expand the war file and start the connector running. If you are not using the  tomcat-bundle or have not installed the bundle into c:\frevvo make the necessary path adjustments to step 2 above.   

Google Spreadsheets

 forms can both write to and read from your Google spreadsheets.

...

Read from a Spreadsheet 

 forms can be initialized with data from a Google Spreadsheet by retrieving data from the Google Spreadsheet via a business rule. This form allows the user to select a customer from the dropdown. Once selected a business rule retrieves the address details from a Google Spreadsheet.

...

And the following Url parameters:

•  media=jason json - This must be set as shown
•  query=<query string> - This is where you specify which rows to match based on the data in your spreadsheet.

...

You can test your queries directly in the web browser. Note that characters such as the equals and double quotes must be URL encoded as shown in the examples below where you see %22 for quote and %3D for = 

http://www.frevvo.com/google/spreadsheets/query/u/<user>/p/<password>
    /s/DisclosureAddresses/w/ByName?media=json&query=name%3DHMF

http://www.frevvo.com/google/spreadsheets/query/u/<user>/p/<password>
    /s/DisclosureAddresses/w/ByName?media=json
    &query=name%3D%22AAA Insurance%22

...

And the following Url parameters:

•  media=jason json - This must be set as shown
•  query=<query string> - This is where you specify which rows to match based on the data in your spreadsheet.
•  update=<update string> - This is where you specify which cell(s) to update in the matched row(s)
•  method=put - A hard coded Url parameter that must exist in the Url string

...

Form submissions can be saved to your Google Apps Premier account. Note that Google Apps Premier accountfor Education account are currently not supported.

The first step is to create a Collection (effectively a folder) in your Google Apps account. This will be the location where your form submissions will be stored. For example, create a Collection called Leave Approvals.

Use the Google Documents wizard

1. Click the Doc Action button in the toolbar at the top of the form.
2. In the wizard that pops up, select the Save to Google Documents button.
3. Enter your login credentials.
4. After your login has succeeded, the wizard will show the list of Folders (Collections) available. Sub-folders are not listed in the folder list.
5. Select the collection you created earlier (Leave Approvals).
6. Choose a name for the Submission Folder. This name should be unique for each submission. The best approach is to choose a combination of controls in the form that will generate a unique name. For example, if your form contains controls named EFulName and StartDate for employee's full name and start date of the leave, then choose: {EFullName}_{StartDate}.
7. Click the Finish button.
8. Your form is now configured to save submissions to your Google Apps account. 

...

This feature is currently in alpha release. The syntax may change. The Google Document Connector uses a template syntax to insert values from a submitted form into the document. The syntax is ${form.[Name]}. Where [Name] is the name you gave to the particular form field in the  Form Designer. Read more about naming form fields.

...

...

Google Connector Known Issues

...