Kembali ke Pasar Aplikasi

Sambungkan Knoon AI dengan Google Sheets (Google) untuk mengotomatisasi alur kerja AI.

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

Google

Beta

Tindakan Aplikasi

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