返回应用市场

将 Knoon AI 与 Google Sheets (Google) 连接以自动化 AI 工作流。

Integrate with Google services such as Drive, Sheets, and other Workspace apps.

Google

测试版

应用操作

Aggregate Cells

Aggregate values within a specific A1 range in a Google Sheet (e.g. SUM, AVG, MIN, MAX, COUNT, ARRAY_AGG, STRING_AGG).

googleSheetsAggregateCells

Append a new row after existing data in a Google Sheet without overwriting rows.

googleSheetsAppendRow

Append Rows from CSV

Append one or more rows from CSV text after existing data in a Google Sheet without overwriting rows.

googleSheetsAppendFromCSV

Clone an existing sheet tab into a new sheet tab within the same Google Sheets file.

googleSheetsCloneSheet

Create a new sheet tab inside an existing Google Sheets file.

googleSheetsCreateSheet

Create Sheet from CSV

Create a new Google Sheet from CSV text, optionally inside a specific Google Drive folder.

googleSheetsCreateFromCSV

Create Sheet Tab from CSV

Create a new sheet tab inside an existing Google Sheets file and populate it with CSV text.

googleSheetsCreateSheetFromCSV

Find All Matching Rows

Find all rows in a Google Sheet where a specific column matches the given value.

googleSheetsFindRows

Find all cells in a sheet that match the given search criteria such as EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.

googleSheetsFindCells

Find First Cell

Find the first cell in a sheet that matches the given search criteria such as EQUALS, CONTAINS, STARTS_WITH, or ENDS_WITH.

googleSheetsFindFirstCell

Find First Matching Row

Find the first row in a Google Sheet where a specific column matches the given value.

googleSheetsFindRow

Insert Cells from CSV

Insert one or more new sheet rows from CSV text at the requested position in a Google Sheet and shift existing rows down.

googleSheetsInsertCellsFromCSV

Insert a new sheet row at the requested row number in a Google Sheet and shift existing rows down.

googleSheetsInsertRow

Read a specific A1 range of cells from a Google Sheet.

googleSheetsReadCells

Read rows from a Google Sheet within an optional A1 range on the specified sheet.

googleSheetsReadRows

Read all used cells from a specific sheet (tab) in a Google Sheets file.

googleSheetsReadSheet

Update Cells from CSV

Update a block of cells in a Google Sheet using CSV text, starting from a specific cell.

googleSheetsUpdateCellsFromCSV

Insert a new row or update an existing row in a Google Sheet based on a match in a specific column.

googleSheetsUpsertRow