Integration

Google Sheets

Connect Google Sheets once and Beam can work in it: chats, agents and workflows read what is there, make changes, and can start when something happens.

43

actions

8

events

What Beam can do in Google Sheets

Every action below is available to chats, to agents (Actions › Add action) and to workflows (an Integration action step). Names are the ones the action picker shows.

Read (11)

Look things up without changing anything.

  • Get Values in Range
  • Find Row
  • Find Rows
  • Get Cell
  • Get Cell Formatting
  • Get Current User
  • Get Spreadsheet by ID
  • Get Spreadsheet Info
  • List Spreadsheets
  • List Worksheets

Change (32)

Create, update, send or delete.

  • Add Single Row
  • Add Multiple Rows
  • Add Conditional Format Rule
  • Add Conditional Formatting
  • Add Protected Range
  • Add Rows
  • Add Worksheet
  • Clear Cell
  • Clear Rows
  • Copy Worksheet

What can start a workflow

Pick one of these Google Sheets events as a workflow's App event trigger, and the workflow runs each time it happens.

Events (8)

  • New Comment
  • New Comment (Instant)
  • New Row Added
  • New Row Added (Instant)
  • New Updates
  • New Updates (Instant)
  • New Worksheet (Instant)
  • New Worksheet (Polling)

Templates that work with Google Sheets

AgentWorks with Excel, Google Sheets, Snowflake
What does this drop in week-4 retention suggest?
Spreadsheet

Data Analyst

Interprets data, explains trends, and recommends next steps in plain language.

AnalyticsUse template

Questions

In Plugins › Integrations, find Google Sheets, click + and sign in. Each person can connect their own account, and an admin can also connect one for the whole workspace.