Google Sheets - NoClick

The Google Sheets node adds Google Sheets operations to your workflows. Add it on the canvas or ask the AI builder for it by name, then pick an operation and fill in its fields. Google Sheets also includes 1 trigger operation (marked in the tables below) that can start a workflow when something happens in Google Sheets.

You can wire the Google Sheets node into an AI agent as a tool provider: the agent calls the operations you allow. See Agent tools.

Credentials

Connect Google Sheets under Credentials in the node settings. See Connecting credentials for the general flow. Sign in with your Google Sheets account when prompted; no keys to copy. NoClick requests the following permissions:

https://www.googleapis.com/auth/spreadsheets
https://www.googleapis.com/auth/drive.metadata.readonly

Operations

Chart

Operation	ID	Description
Add Chart	`add_chart`	Build a chart from a range and place it on a sheet
Delete Chart	`delete_chart`	Remove a chart from the spreadsheet
Edit Chart	`update_chart`	Change a chart’s type, title or the data it plots
Move Or Resize Chart	`move_chart`	Reposition a chart, resize it, or move it onto its own sheet
Set Chart Border	`set_chart_border`	Colour the border around a chart

Column

Operation	ID	Description
Delete Sheet Columns	`delete_sheet_columns`	Delete columns from a sheet
Insert Sheet Columns	`insert_sheet_columns`	Insert columns at a position
Split Text To Columns	`split_text_to_columns`	Split one column of delimited text across several columns

Data source

Operation	ID	Description
Cancel Data Source Refresh	`cancel_data_source_refresh`	Stop a refresh that is currently running
Connect BigQuery Data Source	`add_data_source`	Attach a BigQuery table or query to the spreadsheet as a connected data source
Delete Data Source	`delete_data_source`	Disconnect a data source and remove the sheets it backs
Refresh Data Source	`refresh_data_source`	Re-run a connected data source so its sheets pick up new rows
Repoint Data Source	`repoint_data_source`	Repoint a connected data source at a different table or query

Format

Operation	ID	Description
Add Alternating Colours	`add_alternating_colors`	Apply banded row colours to a range
Add Conditional Formatting	`add_conditional_format_rule`	Colour cells automatically based on their value
Add Dropdown Or Input Rule	`set_data_validation`	Restrict a range to a set of values, a checkbox, or a validated input
Add Or Remove Borders	`format_borders`	Draw or clear borders around and inside a range
Auto-Resize Columns Or Rows	`auto_resize_dimensions`	Resize columns or rows to fit their contents
Clear Filter	`clear_basic_filter`	Remove the sort and filter controls from a sheet
Convert Range To Table	`add_table`	Turn a range into a table, with chip dropdowns and typed columns
Delete Table	`delete_table`	Remove a table, leaving its values in place
Edit Conditional Formatting	`update_conditional_format_rule`	Change a conditional formatting rule, or move it up or down the priority order
Edit Table	`update_table`	Rename a table, resize it, or retype its columns
Format Cells	`format_cells`	Set font, colour, alignment and number format on a range
Merge Cells	`merge_cells`	Merge a range into a single cell
Recolour Alternating Colours	`update_alternating_colors`	Change the colours of banding that is already applied, without removing it first
Remove Alternating Colours	`clear_alternating_colors`	Strip banded row colours from a sheet so they can be reapplied
Remove Conditional Formatting	`delete_conditional_format_rules`	Delete one conditional formatting rule, or every rule on the sheet
Remove Dropdown Or Input Rule	`clear_data_validation`	Strip data validation from a range
Set Column Width Or Row Height	`set_dimension_size`	Set an exact pixel width for columns or height for rows
Set Filter	`set_basic_filter`	Add sort and filter controls to a header range
Unmerge Cells	`unmerge_cells`	Split merged cells back apart
Update Sheet Properties	`update_sheet_properties`	Freeze header rows or columns, set the tab colour, toggle gridlines

Metadata

Operation	ID	Description
Add Developer Metadata	`create_developer_metadata`	Tag a sheet, row or column with a key/value that survives edits and reordering
Delete Developer Metadata	`delete_developer_metadata`	Remove every metadata entry stored under a key
Update Developer Metadata	`update_developer_metadata`	Change the value stored against a metadata key

Range

Operation	ID	Description
Add Named Range	`add_named_range`	Give a range a name so formulas can refer to it
Append Rows to Sheet	`append_rows_to_sheet`	Append rows to spreadsheet
Auto-Fill Range	`auto_fill`	Continue a pattern or series across a range
Cell Notes	`set_cell_notes`	Attach a hover note to every cell in a range, or clear them
Clear Multiple Sheet Ranges	`clear_multiple_sheet_ranges`	Clear multiple ranges at once
Clear Sheet Range	`clear_sheet_range`	Clear values from a range
Copy And Paste Range	`copy_paste_range`	Copy a range over another, optionally values-only or format-only
Cut And Paste Range	`cut_paste_range`	Move a range somewhere else, leaving the source empty
Delete Cells	`delete_cells`	Delete cells, shifting the remaining cells up or left
Delete Named Range	`delete_named_range`	Remove a named range. The cells and their values stay.
Insert Cells	`insert_cells`	Insert blank cells, shifting existing cells down or right
Insert Smart Chips	`insert_smart_chips`	Turn cells into people chips or rich link chips
Paste Delimited Text	`paste_data`	Paste CSV or tab-separated text into a range, splitting it into cells
Pivot Table	`insert_pivot_table`	Summarise a source range into a pivot table anchored at a cell
Protect Range	`add_protected_range`	Stop a range being edited, or warn when someone tries
Randomise Range	`randomize_range`	Shuffle the rows of a range into random order
Read Multiple Sheet Ranges	`read_multiple_sheet_ranges`	Read multiple ranges at once
Read Sheet Data	`read_sheet_data`	Read data from spreadsheet
Sort Range	`sort_range`	Sort rows in a range by a column
Trim Whitespace	`trim_whitespace`	Strip leading, trailing and repeated spaces from a range
Unprotect Range	`delete_protected_range`	Remove protection from a range
Update Named Range	`update_named_range`	Rename a named range or point it at a different range
Update Protected Range	`update_protected_range`	Change a protected range’s extent, description or editors
Write Sheet Data	`write_sheet_data`	Write data to spreadsheet
Write to Multiple Sheet Ranges	`write_to_multiple_sheet_ranges`	Write to multiple ranges at once

Row

Operation	ID	Description
Append Rows After Data	`append_cells`	Add rows directly after the last row that has data
Append Rows Or Columns	`append_rows_or_columns`	Add blank rows or columns to the end of a sheet
Delete Sheet Rows	`delete_sheet_rows`	Delete rows from a sheet
Insert Sheet Rows	`insert_sheet_rows`	Insert rows at a position
Move Rows Or Columns	`move_rows_or_columns`	Move a block of rows or columns to a different position
Remove Duplicate Rows	`remove_duplicate_rows`	Delete rows that repeat, optionally comparing only some columns

Sheet

Operation	ID	Description
Add Spreadsheet Sheet	`add_spreadsheet_sheet`	Add a new sheet/tab to spreadsheet
Copy Sheet to Spreadsheet	`copy_sheet_to_spreadsheet`	Copy a sheet to another spreadsheet
Delete Spreadsheet Sheet	`delete_spreadsheet_sheet`	Delete a sheet/tab from spreadsheet
Duplicate Sheet in Spreadsheet	`duplicate_sheet_in_spreadsheet`	Duplicate a sheet within the spreadsheet
Rename Spreadsheet Sheet	`rename_spreadsheet_sheet`	Rename a sheet/tab

Spreadsheet

Operation	ID	Description
Create New Spreadsheet	`create_new_spreadsheet`	Create a new spreadsheet
Fetch Spreadsheet Metadata	`fetch_spreadsheet_metadata`	Get spreadsheet info and properties
Find and Replace in Spreadsheet	`find_and_replace_in_spreadsheet`	Find and replace text in spreadsheet
Update Spreadsheet Properties	`update_spreadsheet_properties`	Rename the spreadsheet or change its locale, timezone or recalculation setting

View

Operation	ID	Description
Add Slicer	`add_slicer`	Place an interactive filter control on the sheet
Collapse Or Expand Group	`collapse_group`	Fold a group of rows or columns away, or open it back up
Delete Filter View	`delete_filter_view`	Remove a saved filter view
Duplicate Filter View	`duplicate_filter_view`	Copy a filter view so it can be tweaked without touching the original
Filter View	`save_filter_view`	Save a named filter that only you see, leaving everyone else’s view alone
Group Rows Or Columns	`group_rows_or_columns`	Make a block of rows or columns collapsible
Ungroup Rows Or Columns	`ungroup_rows_or_columns`	Remove a collapsible group, leaving the rows or columns in place
Update Filter View	`update_filter_view`	Rename a filter view, move it, or change how it sorts
Update Slicer	`update_slicer`	Retitle a slicer or point it at a different column

Other

Operation	ID	Description	Trigger
On New Row	`on_new_row`	Trigger: polls a sheet on a schedule and fires for newly added rows.	Yes

​Credentials

​Operations

​Chart

​Column

​Data source

​Format

​Metadata

​Range

​Row

​Sheet

​Spreadsheet

​View

​Other

Credentials

Operations

Chart

Column

Data source

Format

Metadata

Range

Row

Sheet

Spreadsheet

View

Other