nodes/generated

Interface GoogleSheetsTriggerNodeParameters

Source
interface GoogleSheetsTriggerNodeParameters {
    documentId?: {
        mode: "id" | "list" | "url";
        value: string;
    };
    event?: "rowAdded"
    | "rowUpdate"
    | "anyUpdate";
    includeInOutput?: "new" | "both" | "old";
    options?: {
        columnsToWatch?: unknown[];
        dataLocationOnSheet?: {
            values: {
                firstDataRow?: number;
                headerRow?: number;
                range?: string;
                rangeDefinition?: "specifyRangeA1" | "specifyRange";
            };
        };
        dateTimeRenderOption?: | "SERIAL_NUMBER"
        | "FORMATTED_STRING";
        valueRender?: | "UNFORMATTED_VALUE"
        | "FORMATTED_VALUE"
        | "FORMULA";
    };
    pollTimes: {
        item: { mode: string & {}
        | "everyMinute" }[];
    };
    sheetName?: {
        mode: "id"
        | "list"
        | "url";
        value: string;
    };
}

Properties§

§readonly documentId?: { ... }

Default: {"mode":"list","value":""}

§readonly event?: "rowAdded" | "rowUpdate" | "anyUpdate"

It will be triggered also by newly created columns (if the 'Columns to Watch' option is not set) Default: "anyUpdate"

§readonly includeInOutput?: "new" | "both" | "old"

This option will be effective only when automatically executing the workflow Default: "new"

§readonly options?: { ... }

Default: {}

§readonly pollTimes: { ... }
§readonly sheetName?: { ... }

Default: {"mode":"list","value":""} Type options: {"loadOptionsDependsOn":["documentId.value"]}