將 Knoon AI 與 Google Sheets (Google) 連接以自動化 AI 工作流程。

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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