googleSheetAddRow

Add a new row to a Google worksheet. Note that this only works with worksheets containing column headers.

Required Parameters

new:*	The column values to add.

Optional Parameters

authtoken	The authentication token retrieved from a previous authentication. If left empty, email and password are required.
email	The email address used to authenticate with Google. The email is required unless an authtoken is used.
password	The password used to authenticate with Google. The password is required unless an authtoken is used.
timeout	Timeout, in seconds, for the operation to complete. Zero (0) means no timeout.
proxy_server	IP Address or host name of the proxy server used for the request.
proxy_auto	Whether or not Proxy should be detected from Windows system settings. This takes precedence over other proxy settings and is not available in Java. The allowed values are: TRUE, FALSE.
proxy_port	Port number of the proxy server.
proxy_user	User ID used to authenticate with the proxy server.
proxy_password	Password used to authenticate with the proxy server.
proxy_authscheme	The proxy server The allowed values are: BASIC, DIGEST, PROPRIETARY, NONE, NTLM.
proxy_authtoken	The proxy authentication token.
proxy_ssltype	The proxy server The allowed values are: AUTO, ALWAYS, NEVER, TUNNEL.
firewall_server	IP Address or host name of the firewall.
firewall_port	Port number of the firewall.
firewall_user	User ID used to authenticate with the firewall.
firewall_password	Password used to authenticate with the firewall.
firewall_type	The type of the firewall. The allowed values are: TUNNEL, SOCKS4, SOCKS5.
logfile	The connector will log the exchange/transferred data to this file.
name	The spreadsheet name. Required if 'id' is not specified.
sheetname	The worksheet name. Required if 'id' is not specified.
id	The ID of the worksheet that you are updating. This can be obtained from the googleSheetListWorksheets operation. Not needed if specifying 'id' or 'rowlink'. Otherwise, if you know the ID, enter it to avoid the extra requests to the server. If left empty, the 'name' and 'sheetname' are required.
shareauthtoken	Whether or not to use the shared authentication token from a previous request, if one exists that matches the user name and password.

Output Attributes

ggl:rowlink	The link for the new row. This can be used for updating/deleting the row.
ggl:success	Indicates the success of the operation.