Connect OpenClaw to Google Sheets and Salesforce
What happens next
Set up in minutes
Choose where it runs
On your computer through your own OpenClaw, or hosted in the cloud. The rest of setup adapts to your choice:
Pick what it can do in Google Sheets
A preset of real Google Sheets operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Pick what it can do in Salesforce
A preset of real Salesforce operations. Each one becomes a tool the agent can call, and it can't touch anything outside the list.
Connect Google Sheets
One sign-in. The agent acts through your account, scoped to the operations you picked.
Connect Salesforce
One sign-in. The agent acts through your account, scoped to the operations you picked.
Add your personal MCP link
The last step mints a private MCP URL for this agent and walks you through exactly this, with your real link filled in. The page flips to Connected the moment your OpenClaw first calls in.
Run this in your terminal
<your-link> is your personal server URL — setup mints it for you.
Exact capabilities
Tools OpenClaw gets
Google Sheets
85 toolsConfiguration for reading data from a Google Sheet
Configuration for writing data to a Google Sheet
Configuration for appending rows to a Google Sheet
Configuration for clearing values from a range
Configuration for creating a new spreadsheet
Configuration for getting spreadsheet metadata
Configuration for reading multiple ranges at once
Configuration for writing to multiple ranges at once
Configuration for adding a new sheet/tab
Configuration for deleting a sheet/tab
Configuration for copying a sheet to another spreadsheet
Configuration for renaming a sheet/tab
Configuration for duplicating a sheet within the same spreadsheet
Configuration for find and replace in a spreadsheet
Configuration for inserting rows
Configuration for deleting rows
Configuration for clearing multiple ranges at once
Configuration for inserting columns
Configuration for deleting columns
Configuration for formatting a range of cells
Configuration for sheet-level display properties
Configuration for auto-sizing columns or rows to fit their contents
Configuration for setting an explicit column width or row height
Configuration for merging cells
Configuration for unmerging cells
Configuration for drawing borders on a range
Configuration for alternating row colours
Configuration for adding a filter to a range
Configuration for removing a filter
Configuration for a conditional formatting rule
Configuration for sorting a range
Configuration for adding a dropdown or input rule to a range
Configuration for removing dropdowns / input rules from a range
Configuration for removing conditional formatting rules
Configuration for removing alternating row colours
Configuration for turning a range into a Sheets table
Configuration for removing a table
Configuration for editing or reordering a conditional formatting rule
Configuration for recolouring existing banding in place
Configuration for changing a table's name, range or column types
Configuration for spreadsheet-level properties
Configuration for naming a range
Configuration for changing a named range
Configuration for removing a named range
Configuration for protecting a range from edits
Configuration for changing a protected range
Configuration for removing range protection
Configuration for putting a hover note on cells
Configuration for inserting people or link smart chips
Configuration for anchoring a pivot table
Configuration for copying a range onto another
Configuration for moving a range
Configuration for pasting delimited text
Configuration for extending a series
Configuration for splitting a column of text
Configuration for trimming whitespace
Configuration for removing duplicate rows
Configuration for shuffling rows
Configuration for inserting cells and shifting the rest
Configuration for deleting cells and shifting the rest
Configuration for moving rows or columns
Configuration for appending blank rows or columns
Configuration for adding a chart
Configuration for changing an existing chart
Configuration for moving or resizing a chart
Configuration for a chart's border colour
Configuration for removing a chart
Configuration for appending rows of cells after the last row of data
Configuration for creating a saved filter view
Configuration for changing a filter view
Configuration for copying a filter view
Configuration for removing a filter view
Configuration for grouping rows or columns
Configuration for collapsing or expanding a group
Configuration for ungrouping rows or columns
Configuration for adding a slicer control
Configuration for changing a slicer
Configuration for tagging a sheet, row or column with durable metadata
Configuration for changing developer metadata
Configuration for removing developer metadata
Configuration for connecting a BigQuery data source
Configuration for repointing a data source
Configuration for disconnecting a data source
Configuration for refreshing connected data
Configuration for cancelling a running refresh
Salesforce
144 toolsExecute a SOQL query to retrieve records
Get the next batch of query results using a query locator
Execute a SOSL search across multiple objects
Get a single record by ID
Create a new record
Update an existing record
Delete a record
Create or update a record using an external ID field
Create multiple records in a single request (up to 200)
Update multiple records in a single request (up to 200)
Delete multiple records in a single request (up to 200)
List all available sObjects in the org
Get detailed metadata for a specific sObject including all fields
Get global metadata about the org
Get org API usage limits
Get information about the current authenticated user
Get available Salesforce API versions
Get available tabs for the user
List all approval processes in the org
Submit a record for approval
Approve or reject a pending approval request
Get blob (binary) data for a record field like Attachment body or Document body
Create an attachment on a record
Upload a file as ContentVersion (Files)
Execute multiple REST API requests in a single call
Create a tree of nested, parent-child records in a single request
Get recently viewed records
List available global quick actions
List quick actions for a specific object
Execute a quick action
Get page layouts for an object
Get compact layouts for an object
Create a bulk ingest job for large data operations
Upload CSV data to a bulk job
Close a bulk job to start processing
Get the status of a bulk job
Get results (successful or failed records) from a bulk job
Abort a bulk job
List bulk jobs
List available reports
Execute a report and get results
Get metadata for a report
Get records deleted within a time range
Get records updated within a time range
Execute a SOQL query including deleted and archived records
Get list views for an object
Get details of a specific list view
Execute a list view and get results
List available dashboards
Get dashboard data and metadata
Refresh a dashboard to get latest data
List available standard invocable actions
Get details of a specific invocable action
Execute an invocable action
Post a message to Chatter feed
Get Chatter feed items
Convert Lead
Merge Records
Create Task
Update Task
Create Event
Update Event
Create Note
Add Campaign Member
Update Campaign Member Status
Create Campaign
Add Case Comment
Add Opportunity Line Item
Add Contact to Opportunity
Assign Permission Set to User
Reset User Password
Get Content Document
Download Content Version
List Content Versions
Delete Content Document
Create Content Document Link
List Files Linked to Record
Send Single Email
Send Email via Template
List Email Templates
Send Mass Email
Get Chatter Feed Item
Delete Chatter Feed Item
Create Chatter Comment
Get Chatter Comments
Delete Chatter Comment
Like Chatter Feed Item
Get Record Chatter Feed
Get Chatter User Profile
List Chatter Groups
Post to Chatter Group
Get Chatter Group Members
Send Chatter Direct Message
Get Chatter Direct Messages
Search Chatter
Get Chatter News Feed
Execute Anonymous Apex
Run Apex Tests
Get Apex Test Results
Query Debug Logs
Get Debug Log Body
Create Trace Flag
Get Apex Code Coverage
Tooling SOQL Query
Get Pending Approval Items
Recall Approval Request
Get Approval History
Get Bulk Job Failed Results
Get Bulk Job Unprocessed Results
Delete Bulk Data Job
Create Bulk Query Job
Get Bulk Query Job Results
Execute Composite Batch
Bulk Retrieve Records
Composite Update Multiple
Run Report Async
Get Async Report Result
Get Dashboard Component Data
List Report Folders
Execute Flow
List Flows
Invoke Email Alert Action
Invoke Field Update Action
Get Org Info
Parameterized Search
Get Search Suggestions
Explain Query Plan
Get Record Count
List Users
Get User
Update User
List Profiles
List Roles
Get Org Storage Usage
List External Data Sources
Query External Object
Create External Object Record
List Knowledge Articles
Create Knowledge Article
Publish Knowledge Article
Attach Article to Case
Publish Platform Event
List Platform Event Channels
Get List View Results with Columns
Starting points
What you can build
Meet the runner
About OpenClaw
Good to know
Frequently asked questions
Keep exploring
More ways to connect
More tools for OpenClaw
Popular OpenClaw pairs
Make it yours
Open your OpenClaw agent in one click.
NoClick runs OpenClaw for you with Google Sheets and Salesforce wired in as tools. Connect your account and run.