Google Sheets

sheets.google.com
Google Sheets is Google’s spreadsheet platform for organizing data, collaborating with others, and building reports from structured inputs. With cloud-based sheets, teams can create workbooks, manage worksheets, and keep data consistent as it changes—making it a trusted choice for everything from simple trackers to business reporting and lightweight analysis.
Connect Google Sheets so BOBs can turn scattered inputs into organized, maintained spreadsheets—then keep them accurate as data changes. BOBs can generate new workbooks and add worksheets when a new reporting need appears, fetch spreadsheet details, and read the right rows or values without manual copying. BOBs can also support ongoing operations like: locating specific records (row-level searches), extracting cell or range data for analysis, and appending new rows as new leads, orders, or tasks come in. This enables use cases such as automated weekly reporting sheets, inventory/CRM-style trackers, data preparation for downstream tools, and spreadsheet-based SOP tracking where the sheet always reflects the latest inputs.

What can BOBs do with Google Sheets?

Perform actions

  • Add Conditional Format Rule
  • Add Multiple Rows
  • Add Protected Range
  • Add Rows
  • Add Single Row
  • Add Worksheet
  • Clear Cell
  • Clear Rows
  • Copy Worksheet
  • Create Column
  • Create Spreadsheet
  • Create Worksheet
  • Delete Conditional Format Rule
  • Delete Rows
  • Delete Worksheet
  • Find Row
  • Find Rows
  • Get Cell
  • Get Current User
  • Get Spreadsheet by ID
  • Get Spreadsheet Info
  • Get Values in Range
  • Insert an Anchored Note
  • Insert Comment
  • Insert Dimension
  • List Spreadsheets
  • List Worksheets
  • Merge Cells
  • Move Dimension
  • New Spreadsheet
  • Read Rows
  • Set Data Validation
  • Update Cell
  • Update Conditional Format Rule
  • Update Formatting
  • Update Multiple Rows
  • Update Row
  • Update Rows
  • Upsert Row

Listen to real-time events

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