+
Connect Close to Google Sheets
Automate Close and Google Sheets with AI
Outbound lists in Close and the Google Sheet SDRs edit need to match without nightly CSV exports. Your Operator agent on OpenClaw pulls Close smart views into Sheet rows with the columns you use, writes Sheet disposition back to Close lead status when a row is marked contacted, and flags leads where phone or title disagrees. Tell it to refresh the call list tab and it reads Close and updates Google Sheets.
It reaches both apps directly or through connectors like Composio MCP and Pipedream MCP, which handle the sign in and token refresh, so there is no Zap to build and no API keys to paste.
What your agent can do with Close and Google Sheets
What your agent does in Close
Create Call
Creates a new call record in Close.com. This tool allows you to log both inbound and outbound calls associated with a lead, supporting parameters such as lead_id, direction, and optional support for contact_id, phone, duration, note, rec...
Create Lead
Creates a new lead in Close CRM. A lead represents a company or organization in your sales pipeline. This tool allows you to create leads with company information (name, description, website), associate contacts with emails/phones/URLs,...
Create SMS Message
This tool creates a new SMS activity in Close CRM. It is primarily used to log SMS communications, including sent messages, received messages, and draft messages. The tool requires an internal phone number (local_phone) which must be an...
Create Task
This tool creates a new task in Close.com. Tasks are used to track to-do items and can be associated with leads. The tool will create a task with the specified parameters using the provided text, due_date, and is_complete flags.
Delete Call
This tool allows you to delete a specific call activity in Close.com. It is useful for removing incorrectly logged calls or cleaning up call records. The action deletes a call activity using its unique call ID and cannot be undone.
Get Notes
This tool retrieves a list of note activities from Close. It allows users to fetch notes with optional filtering parameters, including filtering by lead_id, user_id, and date ranges. The tool returns details such as note content, creatio...
What your agent does in Google Sheets
Add Sheet to Existing Spreadsheet
Adds a new sheet to a spreadsheet. Supports three sheet types: GRID, OBJECT, and DATA_SOURCE. SHEET TYPES: - GRID (default): Standard spreadsheet with rows/columns. Use properties to set dimensions, tab color, etc. - OBJECT: Sheet contai...
Aggregate Column Data
Searches for rows where a specific column matches a value and performs mathematical operations on data from another column.
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
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
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. Only values are cleared...
Batch get spreadsheet
Retrieves data from specified cell ranges in a Google Spreadsheet.
How it works
Tell the agent what you want to happen between Close and Google Sheets, for example to watch one and act in the other, or to keep the two in step. It reads what it needs from Close, works out what to do, and runs the matching action in Google Sheets without you mapping a single field.
You can have it run once, on a schedule, or whenever something changes. Ask it for a status any time and it reads the latest from both apps back to you in the same chat.
Common questions about Close and Google Sheets
- How do I connect Close and Google Sheets to Operator?
- You authorize Close and Google Sheets once each from your Operator dashboard. Operator holds both connections and refreshes the access tokens for you, so your agent keeps working across them without you signing in again.
- What can my agent do across Close and Google Sheets?
- Tell it the job and it moves between Close and Google Sheets as one task, choosing which actions to run on each side. There is nothing to map and no trigger to configure; you give instructions the way you would to a person.
- Can my agent keep Close and Google Sheets in sync?
- Yes. It can watch Close and act in Google Sheets, or keep both in step, reading from one and running the matching update in the other. This runs on demand when you ask or on a schedule you set.
- Do I need to build a workflow or write code?
- No. There is no workflow to build, no fields to map, and no API keys to paste. Operator manages both connections, and you give the agent instructions in plain language.
Close and Google Sheets integrations
Put your agent on Close and Google Sheets
Sign in, connect both apps, and hand your agent the work. The same setup reaches every app in the catalog. Your first week is free.
Try for free