Google Sheets v4 Writer Parameters

Service Connection

About Web Connections

Connections store authentication information.

For general information about web connections, please see Using Web Connections.

For information about managing web services (including authorization credentials such as Client Id and Client Secret), please see Managing Web Services.

Connection

From the Connection parameter in a web service format, you can do one of the following:

  • Select an existing previously defined connection. For information, see the section Reusing a Web Connection in Using Web Connections.
  • Select Add Web Connection to define a new connection. The new connection can be made visible only to the current user, or can be shared among multiple users.

Constraints

Spreadsheet Name or URL

This parameter specifies the spreadsheet to write. Two types of values are supported:

  • Spreadsheet Name: The user’s Google Drive is searched for a spreadsheet that exactly matches the given name. Search scope is limited to My Drive. It is an error if more than one match is found. If there was no match, and the Worksheet Handling option on all writer feature types is set to Create If Needed, then a new spreadsheet with the given name is created in the root level of the user’s Google Drive.
  • Spreadsheet URL: For example, https://docs.google.com/spreadsheets/d/{spreadsheet_id}/edit. The portion of the URL following the spreadsheet ID is ignored.
Note  To write to multiple spreadsheets, add multiple instances of the writer.

Schema Generation

The values supplied here are copied to the corresponding feature type parameters when the writer is initially added to the workspace.

Field Names Row

This optional parameter indicates the row number that contains the field names. If the writer created the worksheet during the translation, this row will be populated based on the user attributes defined on the feature type.

If a value is not provided, then field names are column letters from Start Column up to End Column.

Default: 1

Start Row

This optional parameter indicates the row number of the first feature. The value must be greater than Field Names Row.

If not specified, this is assumed to be either 1 or Field Names Row + 1, whichever is greater.

Start Column

The column from which to start mapping field names to user attributes.

Value: Must be a value between A and ZZZ.

Default: A

End Column

The column at which to stop mapping field names to user attributes.

The writer will write up to and including this column.

Value: Must be a value between A and ZZZ.

Default: AZ