Google Sheets v4 Feature Representation (Format Attributes)

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Type Attributes), this format also adds format-specific attributes (Format Attributes).

Attribute Name

Notes

Contents

googlesheets_type

Read and write

This is always googlesheets_none.

googlesheets_row_number

Read and write

The reader sets this attribute to the row number that corresponds to the feature. By default, the writer uses this attribute for Update and Delete operations. The attribute can be customized using the Row Number Attribute option.

For writes, the value must be greater than the Field Names Row, or greater than 0 when not using a Field Names Row.

googlesheets_url

Read-only

The reader sets this attribute to a link for the range that corresponds to the feature.

fme_db_operation

Write-only

When Feature Operation is set to fme_db_operation, all features need to set this attribute to one of Insert, Update, or Delete.