/** * Google Sheets Node - Version 4.3 * Discriminator: resource=sheet, operation=update */ interface Credentials { googleApi: CredentialReference; googleSheetsOAuth2Api: CredentialReference; } /** Update an existing row in a sheet */ export type GoogleSheetsV43SheetUpdateParams = { resource: 'sheet'; operation: 'update'; authentication?: 'serviceAccount' | 'oAuth2' | Expression; /** * Document * @builderHint Default to mode: 'list' which is easier for users to set up * @default {"mode":"list","value":""} */ documentId?: { __rl: true; mode: 'list' | 'url' | 'id'; value: string; cachedResultName?: string }; /** * Sheet * @builderHint Default to mode: 'list' which is easier for users to set up * @default {"mode":"list","value":""} */ sheetName?: { __rl: true; mode: 'list' | 'url' | 'id' | 'name'; value: string; cachedResultName?: string }; /** * Columns * @displayOptions.hide { sheetName: [""] } * @default {"mappingMode":"defineBelow","value":null} */ columns?: string; /** * Options * @displayOptions.hide { sheetName: [""] } * @default {} */ options?: { /** Determines how data should be interpreted * @default USER_ENTERED */ cellFormat?: 'USER_ENTERED' | 'RAW' | Expression; /** Data Location on Sheet * @default {"values":{}} */ locationDefine?: { /** Values */ values?: { /** Index is relative to the set 'Range', first row index is 1 * @hint Index of the row which contains the column names * @default 1 */ headerRow?: number | Expression; /** Index is relative to the set 'Range', first row index is 1 * @hint Index of first row which contains the actual data * @default 2 */ firstDataRow?: number | Expression; }; }; /** What do to with fields that don't match any columns in the Google Sheet * @displayOptions.show { /dataMode: ["autoMapInputData"] } * @default insertInNewColumn */ handlingExtraData?: 'insertInNewColumn' | 'ignoreIt' | 'error' | Expression; /** What do to with fields that don't match any columns in the Google Sheet * @displayOptions.show { /columns.mappingMode: ["autoMapInputData"] } * @default insertInNewColumn */ handlingExtraData?: 'insertInNewColumn' | 'ignoreIt' | 'error' | Expression; }; }; export type GoogleSheetsV43SheetUpdateNode = { type: 'n8n-nodes-base.googleSheets'; version: 4.3; credentials?: Credentials; config: NodeConfig; };