Google Sheets
Last updated: August 22, 2025
The Google Sheets integration allows Zams to automate spreadsheet-related tasks such as reading, writing, updating, and searching data. This makes it easier to manage workflows, track records, and analyze information without needing to open Google Sheets directly. For example, you can use Zams to log meeting notes, update project trackers, or generate reports automatically.
Connection Method
Authentication Type: OAuth Flow
Requirements:
A Google account with Google Sheets enabled.
Steps to Connect in Zams:
Go to Integrations in the Zams dashboard.
Select Google Sheets from the list of available integrations.
Click Connect and follow the Google OAuth sign-in process.
Grant Zams permission to view and manage spreadsheets.
Once complete, Google Sheets features will be available to your agents.
Available Functionalites
Spreadsheet Management
Funcionality | Description |
List My Spreadsheets | Show all Google Sheets you own or have access to. |
Create New Spreadsheet | Start a new Google Sheet with a custom title. |
Get Spreadsheet Info | See details such as sheet names and size. |
Reading Data
Funcionality | Description |
Read Data | Retrieve data from a sheet or range (e.g., “Sheet1!A1:D5”). |
Batch Read Data | Read from multiple ranges at once. |
Search Rows | Find rows that match specific criteria (e.g., “all rows where Status = Completed”). |
Writing & Updating Data
Funcionality | Description |
Write or Update Data | Enter or replace values in specific cells or ranges. |
Append Rows | Add new rows of data to the end of a sheet. |
Batch Update Data | Update multiple ranges in a single operation. |
Update Matching Rows | Search for rows that meet conditions and update them (e.g., change all tasks with “Pending” to “In Progress”). |
Clearing Data
Funcionality | Description |
Clear Range | Delete all content from a specific range of cells. |
Example of Use
Read data from a sheet:
“Show me all rows from the ‘Sales Q1’ sheet.”
Add new information:
“Append a new row with John Smith, Closed Deal, $5,000 in the Sales Tracker sheet.”
Update existing records:
“Update the status of all tasks assigned to Mary from ‘Pending’ to ‘Completed’.”
Clean up a range:
“Clear all data in columns A to C of the ‘Drafts’ sheet.”