Integration · Spreadsheets
Read and update tracking spreadsheets without copying data by hand. Below, the actions and events the vendor publishes, what it takes to start and where this fits into the work.
Actions and eventsGoogle Sheets
Google Sheets is a cloud-based spreadsheet tool enabling real-time collaboration, data analysis, and integration with other Google Workspace apps
45 ACTIONS
published by the vendor; the company enables only the necessary ones
16 EVENTS
triggers the system can send, when the vendor offers them
SIGN IN TO THE SERVICE ACCOUNT
each person signs in with their own credential, encrypted
APPROVAL BY RISK
sensitive actions show a card before running
Live proof
The scene uses actions the vendor publishes for Google Sheets. In your company, only the functions turned on by the administrator come into play.
Input
A team member asks, in the conversation, for something that today requires opening Google Sheets — inside their area's space, with their login.
What Skyller does
Result
Google Sheets stops being an open tab and starts answering inside the conversation — through the functions your company enabled.
What this scene does not promise
Where this helps your work
Three common situations for people who use Google Sheets every day. What Skyller does in each one depends on the functions your company turns on.
Closing the month
The analyst asks in the Finance space. Skyller reads the range in Google Sheets with her login and returns the list, checking it against the published policy.
Spreadsheet read in the conversation
Consolidating
Appending rows is a write action: Skyller shows the card with the rows it is about to insert in Google Sheets and waits for Approve.
Write with approval
Administering
The administrator turns on only read, find and append for the team; delete functions stay off. Every call to Google Sheets is recorded.
Only the enabled functions
Actions and events
Names as the vendor publishes them, in English, with the description summarized to its first sentence. In your company, the administrator turns on only the necessary actions; none of them runs without permission, and sensitive ones go through approval.
Add Sheet to Existing Spreadsheet
GOOGLESHEETS_ADD_SHEET
Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES:
Aggregate Column Data
GOOGLESHEETS_AGGREGATE_COLUMN_DATA
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
Append Dimension
GOOGLESHEETS_APPEND_DIMENSION
Tool to append new rows or columns to a sheet, increasing its size. Use when you need to add empty rows or columns to an existing sheet.
Auto-Resize Rows or Columns
GOOGLESHEETS_AUTO_RESIZE_DIMENSIONS
Auto-fit column widths or row heights for a dimension range using batchUpdate.autoResizeDimensions. Use when you need to automatically adjust row heights or column widths to fit content after writing data.
Batch Clear Values By Data Filter
GOOGLESHEETS_BATCH_CLEAR_VALUES_BY_DATA_FILTER
Clears one or more ranges of values from a spreadsheet using data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared.
Batch get spreadsheet
GOOGLESHEETS_BATCH_GET
Retrieves data from specified cell ranges in a Google Spreadsheet.
Batch Update Values by Data Filter
GOOGLESHEETS_BATCH_UPDATE_VALUES_BY_DATA_FILTER
Tool to update values in ranges matching data filters. Use when you need to update specific data in a Google Sheet based on criteria rather than fixed cell ranges.
Clear Basic Filter
GOOGLESHEETS_CLEAR_BASIC_FILTER
Tool to clear the basic filter from a sheet. Use when you need to remove an existing basic filter from a specific sheet within a Google Spreadsheet.
Clear spreadsheet values
GOOGLESHEETS_CLEAR_VALUES
Clears cell content (preserving formatting and notes) from a specified A1 notation range in a Google Spreadsheet; the range must correspond to an existing sheet and cells.
Create Chart in Google Sheets
GOOGLESHEETS_CREATE_CHART
Create a chart in a Google Sheets spreadsheet using the specified data range and chart type. Conditional requirements:
Create a Google Sheet
GOOGLESHEETS_CREATE_GOOGLE_SHEET1
Creates a new Google Spreadsheet in Google Drive. If a title is provided, the spreadsheet will be created with that name.
Create spreadsheet column
GOOGLESHEETS_CREATE_SPREADSHEET_COLUMN
Creates a new column in a Google Spreadsheet. Specify the target sheet using sheet_id (numeric) or sheet_name (text). If neither is provided, defaults to the first sheet (sheet_id=0).
Before you start
Questions from the people who decide
Related integrations
Work on the Microsoft 365 spreadsheets that already run the area's controls.
See actions and requirementsUse the files your team already keeps in Drive as the source of answers.
See actions and requirementsRead, search and append data in CSVBox spreadsheets from the conversation, through the functions your company enables.
See actions and requirementsRead, search and append data in Retable spreadsheets from the conversation, through the functions your company enables.
See actions and requirementsNext step
Try it free with your team or book a demo: together we pick the Google Sheets functions to enable and show the first approved action, with fictitious data.
