Tilbake til Google Sheets

Koble til Knoon AI med Google Sheets (Google) for å automatisere AI-arbeidsflyter.

Read all used cells from a specific sheet (tab) in a Google Sheets file.
googleSheetsReadSheet
BETA
Tillatelser
  • https://www.googleapis.com/auth/drive.file
Valgfrie tillatelser
  • https://www.googleapis.com/auth/drive
Parametere
NavnTypeBeskrivelsePåkrevd
spreadsheetIdfile Select the Google Sheets file to read from.Ja
sheetNamemustache Name of the sheet (tab) to read (e.g. "Sheet1").Ja
Returer
NavnTypeBeskrivelse
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.