Tillbaka till Google Sheets

Anslut Knoon AI med Google Sheets (Google) för att automatisera AI-flöden.

Read all used cells from a specific sheet (tab) in a Google Sheets file.
googleSheetsReadSheet
BETA
Behörigheter
  • https://www.googleapis.com/auth/drive.file
Valfria behörigheter
  • https://www.googleapis.com/auth/drive
Parametrar
NamnTypBeskrivningObligatoriskt
spreadsheetIdfile Select the Google Sheets file to read from.Ja
sheetNamemustache Name of the sheet (tab) to read (e.g. "Sheet1").Ja
Returer
NamnTypBeskrivning
statusstring DONE.
rowsarray Array of rows represented as an array of cell values (e.g. [["ID", "Name"], ["123", "John Doe"]]). Returns an empty array if the sheet is empty.