Section | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
|
...
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.
...