| Table of Contents |
|---|
frevvo business rules are used to retrieve and update data in Google sheets via the Google Connector. One advantage to initializing your form/workflow from a Google sheet is to provide business users, who may not be familiar with frevvo, an opportunity to modify the Google sheet to make changes. Once modified, the changes in the Google sheet are reflected in the form/workflow without further action.
...
- Use http headers for authentication in rulesin frevvo rules.
- You can identify your Google sheet/worksheet, using the ssname and wsname query parameters.
- frevvo recommends using the spreadsheet key instead of spreadsheet name to identify your Google Sheet
- Pass payloads and headers as native JavaScript objects.
...
Queries to a Google sheet can include query parameters or parameters that are part of the path in the URL or a combination of both.
Note for On Premise Customers
On Premise customers need to also specify the server and port where their Google Connector is hosted. The query url's below will start with '<YourServer:Port>/google/spreadsheets/. . . '.
Queries using the Spreadsheet key
...
| Warning |
|---|
Variables in rules must be unique. Having duplicate variables in the same rule will cause the rule to fail but you may not get an error message.e |
Queries using the Spreadsheet and Worksheet Name
...
The image shows a query that reads from a Google sheet named Google Connector Address Sheet and a worksheet (tab) named Sheet1.
| Warning | ||||||
|---|---|---|---|---|---|---|
The column name on a Google sheet must match the control name. The matching is case-insensitive and any spaces in the column name are ignored. A control named "FirstName" matches a column header "first name." However, references to Google Sheet columns in your rule must be lower case and cannot contain spaces. The correct reference for this example is "firstname."
|
...
Google supports special characters in Google Sheet and Worksheet Names. If you are using v6.1.3, and Google Connector version 2.1, your Your rules must pass the sheet and worksheet names as query parameters, to avoid any issues with special characters. Special characters {}, #, + ,& are not supported in rules but they will work in the Save Submissions to a Google Spreadsheet wizard.
...