Google Sheets

community_google_sheets · action · Utility · Available · v1.0.0

Description

Enterprise connector for Google Sheets via the official Sheets API v4 (OAuth2): read ranges, append rows, update cells and clear ranges — the four operations covering the standard spreadsheet automation cycle.

⚙️ Configuration parameters

Fields shown in the editor when configuring the node. Generated directly from the NodeDefconfigFields.

Field	Type	Required	Default	Description
`operation` Operazione	`enum` `getValuesupdateValuesappendValuesbatchGet`	yes	`getValues`	—
`spreadsheetId` Spreadsheet ID	`expression`	yes	— 1AbcDef... (dalla URL del foglio)	ID Spreadsheet (parte tra /d/ e /edit nella URL). Supporta {{input.spreadsheetId}}.
`range` Range A1 notation	`expression`	yes	— Foglio1!A1:D100	Range A1 (es. "Foglio1!A1:D100" o solo "Foglio1" per intera scheda).
`valuesJson` Values (JSON array of arrays)	`expression`	no	— [["A1","B1"],["A2","B2"]]	Solo per updateValues/appendValues. Array 2D di valori.
`valueInputOption` Modo input	`enum` `RAWUSER_ENTERED`	no	`USER_ENTERED`	RAW = come testo grezzo. USER_ENTERED = parsa formula/date/numeri come la UI.
`integrationLabel` Etichetta credenziali (opzionale)	`string`	no	— Default account	Per gestire più account dello stesso provider. Lascia vuoto per il default.

💡 Configuration example

JSON snippet of the node as it appears in the workflow. Values are derived fromdefaultValue and from required parameters.

{
  "id": "node-community_google_sheets-1",
  "defId": "community_google_sheets",
  "label": "Google Sheets",
  "config": {
    "operation": "getValues",
    "spreadsheetId": "1AbcDef... (dalla URL del foglio)",
    "range": "Foglio1!A1:D100",
    "valueInputOption": "USER_ENTERED"
  }
}

🔗 Related nodes in the same category

Ready to use Google Sheets?

Available now on all FlowForge plans. Try it free without a credit card.

Start free Browse all nodes