rocketkind
Productivity

Google Sheets

Google Sheets is Google's spreadsheet product.

Authentication

  • OAuth 2.0

Actions

Generic API request. Call any Google Sheets API endpoint on this connection, for the case where no shipped action covers it yet. The connection supplies the base URL, the authentication and the egress route, so only the path, query and body are yours to fill.

  • Add bandingApply alternating colours — banding, what the Sheets UI calls alternating colours — to a rectangular block of a sheet, so long tables stay readable.
  • Add chartEmbed a chart in a spreadsheet, built from a range of cells.
  • Add conditional format ruleAdd a conditional formatting rule to a block of a sheet, so cells restyle themselves whenever their contents match a condition.
  • Add data sourceConnect a spreadsheet to BigQuery or Looker, so a sheet is populated from that system instead of from typed-in values.
  • Add filter viewCreate a named filter view — a saved, private way of sorting and filtering a range that other people looking at the same spreadsheet do not see.
  • Add named rangeGive a block of cells a name, so formulas, charts and other actions can refer to it by that name instead of by an A1 range that breaks the moment rows move.
  • Add protected rangeLock a block of cells so only named people can change it — the Sheets "protect range" feature.
  • Add sheetAdd a sheet (tab) to an existing spreadsheet, optionally at a chosen position.
  • Add slicerAdd a slicer — the on-sheet drop-down control that lets a reader filter a table or chart on one column without editing anything.
  • Add tableTurn a range of cells into a named table, so its columns carry a declared type, its header and banding are styled, and formulas can refer to it by name.
  • Append rows of cellsAdd rows after the last row that holds data on a sheet, growing the grid if it runs out of room.
  • Append rows or columnsGrow a sheet by adding empty rows at the bottom or empty columns at the right edge.
  • Append valuesAdd rows to the end of an existing table without overwriting anything.
  • Auto-fill a seriesDestructiveContinue a pattern found in existing cells into more cells, the API form of dragging the fill handle: 1, 2, 3 keeps counting, Mon, Tue keeps naming days, and a formula is copied with its relative references rewritten.
  • Auto-resize rows or columnsDestructiveResize a band of rows or columns to fit their contents, the same as double-clicking a column border in the Sheets UI.
  • Batch clear valuesDestructiveClear values from several ranges at once, leaving formatting intact (POST /spreadsheets/{spreadsheetId}/values:batchClear, JSON {ranges:[...]}).
  • Batch get valuesDestructiveRead several ranges of one spreadsheet in a single request — cheaper than one googlesheets:getvalues call per range, and the ranges are read together rather than at drifting moments.
  • Batch update spreadsheetDestructiveApply structural changes to a spreadsheet (POST /spreadsheets/{spreadsheetId}:batchUpdate, JSON {requests:[...]}).
  • Batch update valuesDestructiveWrite to several ranges of one spreadsheet in a single request, each range carrying its own row-major values array.
  • Cancel data source refreshDestructiveStop a connected-sheet refresh that is still running, so a long or expensive BigQuery or Looker query does not finish.
  • Clear basic filterDestructiveTake the basic filter off a sheet, so every row it was hiding becomes visible again for everyone.
  • Clear valuesDestructiveClear values from a range, leaving formatting intact (POST /spreadsheets/{spreadsheetId}/values/{range}:clear).
  • Clear values by data filterDestructiveBlank the cell values of every range a set of filters matches, leaving the cells, their formatting, data validation and conditional formats in place.
  • Collapse or expand a groupDestructiveCollapse or expand an existing outline group.
  • Copy and paste a rangeCopy a block of cells to another area, leaving the source untouched.
  • Copy sheet to spreadsheetCopy a single sheet into another spreadsheet (POST /spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo, JSON {destinationSpreadsheetId}).
  • Create developer metadataAttach a hidden key/value label to a spreadsheet, a sheet, or a single row or column.
  • Create spreadsheetCreate a new, empty Google Sheets spreadsheet in the connected account's Drive under the title you give.
  • Cut and paste a rangeDestructiveMove a block of cells to another location, clearing the source.
  • Delete bandingDestructiveRemove a block of alternating colours from a sheet, leaving the cells and their contents in place — only the banding goes.
  • Delete cellsDestructiveDelete a rectangular block of cells and close the gap by pulling neighbouring cells in, without touching data outside the block's rows or columns.
  • Delete conditional format ruleDestructiveRemove one conditional formatting rule from a sheet.
  • Delete data sourceDestructiveDisconnect a spreadsheet from a BigQuery or Looker data source.
  • Delete developer metadataDestructiveRemove hidden key/value labels from a spreadsheet.
  • Delete duplicate rowsDestructiveRemove rows from a range whose values in the chosen columns repeat an earlier row, keeping the first occurrence.
  • Delete embedded objectDestructiveRemove an embedded object — a chart or a floating image — from a spreadsheet.
  • Delete filter viewDestructiveRemove a saved filter view from a spreadsheet.
  • Delete named rangeDestructiveDrop a name from a spreadsheet.
  • Delete protected rangeDestructiveRemove a range protection, so the cells it covered become editable by anyone who can edit the spreadsheet.
  • Delete rows or columnsDestructiveDelete whole rows or columns from a sheet, pulling the cells below or to the right up into the gap.
  • Delete sheetDestructiveRemove one sheet (tab), and every cell on it, from a spreadsheet.
  • Delete tableDestructiveRemove a table definition from a spreadsheet, leaving the cells it covered in place as ordinary values.
  • Duplicate filter viewCopy a saved filter view, criteria and sort order included, so you can vary it without disturbing the original.
  • Duplicate sheetCopy one sheet (tab), with all of its cells, formatting and formulas, into the same spreadsheet under a new name.
  • Fill a range with one cellDestructiveWrite the same value, note and formatting into every cell of a range in one call — the way a column of formulas, a currency format or a highlight colour is applied in bulk without sending one entry per cell.
  • Find and replaceReplace every occurrence of a string across one tab, one range, or the whole spreadsheet.
  • Get developer metadataRead one developer-metadata entry by its numeric id.
  • Get spreadsheetRetrieve a spreadsheet's metadata and structure (GET /spreadsheets/{spreadsheetId}).
  • Get spreadsheet by data filterRead a spreadsheet's structure, and optionally its cells, for only the parts matched by a set of filters — the selective counterpart of googlesheets:getspreadsheet, which returns the whole workbook.
  • Get valuesRead the cell values in one A1 range of a spreadsheet.
  • Group rows or columnsCreate an outline group over a band of rows or columns, giving the sheet the collapse and expand control that hides detail behind a summary row.
  • Insert cellsInsert a rectangular block of blank cells, shifting only the cells inside the affected rows or columns rather than the whole row or column.
  • Insert rows or columnsInsert blank rows or columns into the middle of a sheet, pushing the existing cells down or right and shifting every formula reference with them.
  • List spreadsheetsFind the spreadsheets the connected account can reach, so a name can be turned into the spreadsheetId every other Google Sheets action is keyed by.
  • Merge cellsDestructiveMerge a rectangular block of cells into one — the usual way to build a heading that spans several columns.
  • Move rows or columnsDestructiveMove a contiguous band of rows or columns to another position in the same sheet, carrying their values and formatting and rewriting the formula references that point at them.
  • Paste delimited or HTML dataDestructivePaste a CSV, TSV or HTML blob straight into a sheet at a chosen cell, letting Sheets split it into rows and columns.
  • Randomize row orderDestructiveShuffle the rows of a range into a random order, keeping each row's cells together.
  • Read values by data filterDestructiveRead several blocks of cell values in one call, selecting each by A1 range or by developer-metadata lookup.
  • Refresh data sourceDestructiveRe-run the query behind a connected sheet so its rows pick up what has changed in BigQuery or Looker.
  • Resize or hide rows or columnsDestructiveSet the pixel height of a band of rows or the pixel width of a band of columns, and hide or unhide them.
  • Search developer metadataFind developer-metadata entries by key, value, visibility or the location they are attached to.
  • Set basic filterDestructivePut a sheet's one basic filter over a range, with per-column criteria and a sort order.
  • Set data validationDestructivePut a data validation rule on a block of cells, so the sheet checks what people type into them — a dropdown from a list, a number range, a date, an email address, a checkbox, or a custom formula.
  • Sort a rangeDestructiveSort the rows of a range on one or more columns, moving whole rows so each row's cells stay together.
  • Split text into columnsDestructiveSplit one column of delimited text across several columns, the API form of the Data > Split text to columns menu item.
  • Trim whitespaceDestructiveStrip leading and trailing whitespace from every text cell in a range and collapse each internal run of spaces, tabs or newlines down to a single space.
  • Ungroup rows or columnsDestructiveRemove one outline group from a sheet, keeping the rows or columns and their data and deleting only the collapse control.
  • Unmerge cellsDestructiveSplit every merged cell inside a block back into its individual cells.
  • Update bandingDestructiveRecolour or move an existing block of alternating colours.
  • Update bordersDestructiveDraw or clear cell borders on a rectangular block of a sheet.
  • Update chart specDestructiveRewrite what an existing embedded chart plots and how it looks — its type, source ranges, title, legend and axis titles.
  • Update conditional format ruleDestructiveReplace a conditional formatting rule in place, move it to a different position in the sheet's evaluation order, or both.
  • Update data sourceDestructiveRepoint an existing connected-sheet data source — a different BigQuery table, a rewritten query, or changed query parameters.
  • Update developer metadataDestructiveChange the hidden key/value labels a spreadsheet already carries.
  • Update embedded object borderDestructiveRecolour the border drawn around an embedded object — the frame Sheets puts around a chart or a floating image.
  • Update embedded object positionDestructiveMove or resize an embedded object — a chart or a floating image — inside a spreadsheet.
  • Update filter viewDestructiveChange a saved filter view — rename it, move the range it covers, or replace its per-column criteria and sort order.
  • Update named rangeDestructiveRename a named range, or repoint it at a different block of cells — useful when a table grows and every formula referring to it should follow.
  • Update protected rangeDestructiveChange an existing range protection — who may edit it, what it covers, the message people see, or whether it blocks edits outright rather than merely warning.
  • Update sheet propertiesDestructiveRename, reorder, hide, recolour or resize one sheet (tab), and set its frozen rows and columns.
  • Update slicer specDestructiveChange what a slicer filters and how it looks — its data range, the column it acts on, its title, alignment, background and the values it hides.
  • Update spreadsheet propertiesDestructiveChange workbook-wide settings: the file title, the locale that drives default number and date formats, the time zone NOW and TODAY read, and how often volatile functions recalculate.
  • Update tableDestructiveChange an existing table — rename it, grow or move the range it covers, retype its columns, or restyle its header and banding.
  • Update valuesDestructiveOverwrite the cells of one A1 range with the values you supply, given as a row-major array of arrays anchored at the top-left of the range.
  • Write cells by grid indexDestructiveWrite a block of cell values addressed by numeric sheet and row/column indexes rather than an A1 range, which is what makes it safe to drive from a loop counter.
  • Write values by data filterDestructiveWrite one block of cell values into every range a filter matches, selecting either by A1 range or by developer-metadata lookup.

Triggers

  • New or updated spreadsheetStarts when a Google Sheets spreadsheet the connected account can see is created or modified.
  • New rowStarts when a row is appended below the rows already present in the watched range of a spreadsheet.

Product names, logos and brands are the property of their respective owners and are used here for identification only. Their use does not imply endorsement by, or affiliation with, those owners.