Google Sheets Writer Parameters

This parameter specifies a refresh token for OAuth 2.0 authentication to a specific Google account.

If you already know the token, you can copy/paste it into this parameter. To obtain a new token, click the browse button. This will prompt for a Google account authentication page from Google.

It is recommended that you save the defaults (from the Defaults button on the dialog) once the refresh token is retrieved so you will not have to re-authenticate in the future.

This parameter specifies the spreadsheet to write:

• Spreadsheet URL: To obtain the Spreadsheet URL, open the Google Sheet in a browser and copy the URL from the address bar. The domain in the URL must be docs.google.com or spreadsheets.google.com. It is an error if no such spreadsheet exists, or if the sharing settings for the Spreadsheet do not grant write access to your account.
• Spreadsheet name: If the value is not a URL, it is assumed to be a name that uniquely identifies a spreadsheet stored in your Google Drive account. If no such spreadsheet exists, it will be created.

A single spreadsheet must be specified.

To write to multiple spreadsheets, use multiple instances of the Google Sheets Writer.

This parameter is applicable only when the Use Attribute Names As Column Positions parameter is set to No.

If this parameter is set to Yes, the first row, as specified by the Start Writing At Row parameter, is populated with field names in the same order as their definition on the feature type.

• Yes: Attributes on writer feature types will be interpreted as column positions. For instance, an attribute named C will be interpreted as corresponding to column 3. Attributes that do not correspond to a column position are ignored.
• No: The attribute order, as defined on the feature type, determines the columns where values are written. Values are written in this order, starting from the column specified by the Start Writing At Column parameter.

This parameter determines how many cells are written in a single request, and approximately how many rows are retrieved in a single request. If not specified, a default value is used.

This parameter influences memory usage and progress logging. Under most circumstances, you will not have to change the default value.