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

Tip
customers building applications that are high volume and address critical business processes should not use Google Sheets in place of a production quality database.

Installation

Tip
If you are using Online, the Google Connector is already setup for you. If you are using In-house, please read the installation instructions.

...

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

...

Versions Compared