Retour à Google Sheets

Connecter Knoon AI avec Google Sheets (Google) pour automatiser les flux de travail AI.

Read a specific A1 range of cells from a Google Sheet.
googleSheetsReadCells
Bêta
Autorisations
  • https://www.googleapis.com/auth/drive.file
Autorisations optionnelles
  • https://www.googleapis.com/auth/drive
Paramètres
NomTypeDescriptionRequis
spreadsheetIdfile Select the Google Sheets file to read cells from.Oui
sheetNamemustache Name of the sheet (tab) to read from (e.g. "Sheet1").Oui
rangemustache A1 range within the sheet to read (e.g. "A1:D10" or "B2:B20").Oui
Retours
NomTypeDescription
statusstring DONE.
rowsarray Array of rows represented as an array of cell values (e.g. [["123", "John"], ["456", "Jane"]]). Returns an empty array if no cells are found.