Google Sheets
Use AI with Google Sheets to summarize a selected range, append new rows, and update specific cells in your spreadsheet.
Google Sheets organizes data in worksheets and cell ranges. Connect your Google account to read values, maintain tables, and adjust sheet structure.
Ajanınızın Google Sheets içinde yapabilecekleri
Göreve göre gruplanmış eylemler. Her grup çağırdığı eylemleri listeler.
Read and Analyze Ranges
Read one or several ranges and calculate numeric column summaries.
- Values Get
- Batch Get
- Aggregate Column Data
Write and Maintain Rows
Append rows, update cell ranges, or match rows by a key when maintaining a table.
- Spreadsheets Values Append
- Values Update
- Upsert Rows
Organize Worksheets
Inspect worksheet names, add sheets, and format selected cells.
- Get Sheet Names
- Add Sheet
- Format Cell
Ajanınıza verebileceğiniz görevler
Köşeli parantezleri doldurun; görev ikinci bir uygulamanın adını veriyorsa onu da bağlayın.
Summarize a Data Range
Read selected rows and identify trends, missing values, or unusual entries.
Read Sales!A1:F100 in [Google Sheets spreadsheet link]. Summarize sales by region using the column headers, flag missing values, and leave the sheet unchanged.
Append New Rows
Add supplied rows below an existing table in the column order you choose.
Append these rows [row values in column order] to the table in Orders!A:D in [spreadsheet link]. Treat all values as literal text or numbers, and keep the existing rows.
Update Specific Cells
Write new values into an exact range without expanding the task to other cells.
In [spreadsheet link], set Tasks!D2:D4 to these three status values: [status 1], [status 2], [status 3]. Write literal values and leave all other cells unchanged.
Compare Two Data Ranges
Read selected ranges together to explain differences.
Compare Actual!A1:D50 and Budget!A1:D50 in [spreadsheet link]. Match rows by the project column and explain the largest differences.
Share a Sales Summary in Slack
Read a sales range and send a focused recap to the team.
Read Sales!A1:F100 in [spreadsheet link]. Summarize revenue by region using the headers, flag missing values, and send the summary to Slack channel [channel ID].
Ayrıca gerekenlerSlackShare a Sales Summary in Feishu
Give the team regional sales totals and missing-data notes from a selected spreadsheet range.
Read Sales!A1:F100 in Google Sheets spreadsheet [spreadsheet link]. Summarize revenue by region using the column headers, flag missing values, and send the summary to Feishu chat [chat ID].
Ayrıca gerekenlerFeishu
Eylemler40
Google Sheets konektörünün sunduğu tüm eylemler, adı ve id'siyle.
- Add Sheet
add_sheetAdd a new sheet through spreadsheets.batchUpdate and return stable batch replies. - Aggregate Column Data
aggregate_column_dataAggregate numeric values from a target column, optionally filtered by another column, with stable counters. - Append Dimension
append_dimensionAppend rows or columns through spreadsheets.batchUpdate and return stable batch replies. - Auto Resize Dimensions
auto_resize_dimensionsAuto-resize rows or columns through spreadsheets.batchUpdate and return stable batch replies. - Batch Clear Values By Data Filter
batch_clear_values_by_data_filterClear spreadsheet values through values.batchClearByDataFilter and return the cleared ranges. - Batch Get
batch_getRead multiple spreadsheet ranges through values:batchGet and return stable valueRanges output. - Batch Update Values By Data Filter
batch_update_values_by_data_filterWrite spreadsheet values through values.batchUpdateByDataFilter and return stable aggregate counters. - Clear Basic Filter
clear_basic_filterClear a basic filter through spreadsheets.batchUpdate and return stable batch replies. - Clear Values
clear_valuesClear a single spreadsheet value range through values.clear and return the cleared A1 range. - Create Chart
create_chartCreate a chart through spreadsheets.batchUpdate and return stable batch replies. - Create Google Sheet1
create_google_sheet1Create a Google Sheets spreadsheet and return stable spreadsheet metadata for the new file. - Create Spreadsheet Column
create_spreadsheet_columnInsert an empty column into a sheet through spreadsheets.batchUpdate with stable top-level fields. - Create Spreadsheet Row
create_spreadsheet_rowInsert an empty row into a sheet through spreadsheets.batchUpdate with stable top-level fields. - Delete Dimension
delete_dimensionDelete rows or columns through spreadsheets.batchUpdate and return stable batch replies. - Delete Sheet
delete_sheetDelete a sheet through spreadsheets.batchUpdate and return stable batch replies. - Find Replace
find_replaceRun find and replace through spreadsheets.batchUpdate and return stable batch replies. - Format Cell
format_cellFormat cells through spreadsheets.batchUpdate and return stable batch replies. - Get Conditional Format Rules
get_conditional_format_rulesRead spreadsheet conditional formatting rules and project them into a stable per-sheet structure. - Get Data Validation Rules
get_data_validation_rulesRead spreadsheet data validation rules from the minimum necessary sheet ranges and return flattened rule entries. - Get Sheet Names
get_sheet_namesList visible or all sheet names from a spreadsheet and include a stable name-to-sheetId map.
Google Sheets hesabı nasıl bağlanır
- Giriş yöntemi
- OAuthAuthorize your Google account to connect Google Sheets.
- Gerekenler
- A Google account with access to the target spreadsheet; editing requires write access.
- Notlar
- Provide the spreadsheet link or ID, worksheet name, and range, such as Sales!A1:F100. For writes, specify the values and whether to append rows or replace existing cells.
Google Sheets konektörü hakkında sorular
Google Sheets ile birlikte kullanılan konektörler
Google Sheets içeren görevlerin de çağırdığı uygulamalar.
