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§
Source§readonly event?: "rowAdded" | "rowUpdate" | "anyUpdate"
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"
Source§readonly include
readonly include
This option will be effective only when automatically executing the workflow Default: "new"
Source§readonly 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";
}
readonly 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";
}
Default: {}
Default: {"mode":"list","value":""}