openclaw

Connect OpenClaw to Google Sheets and Salesforce

Give OpenClaw Google Sheets and Salesforce together and it can load a spreadsheet into your CRM and report the other way in the same session. The sheet is where exports and new rows collect, and Salesforce is the system of record they need to reach. OpenClaw reads a range and creates the records, or queries Salesforce and writes the results back into a sheet. Both tools at once means bulk loads and reports stop being separate manual chores.

Loading preview…
Opens a workflow with 75 tools ready to use.

Tools OpenClaw gets

Pick the operations you want and each becomes a tool the agent can call directly while it works.

Google Sheets

19 tools
Read Sheet Data

Configuration for reading data from a Google Sheet

Write Sheet Data

Configuration for writing data to a Google Sheet

Append Rows to Sheet

Configuration for appending rows to a Google Sheet

Clear Sheet Range

Configuration for clearing values from a range

Create New Spreadsheet

Configuration for creating a new spreadsheet

Fetch Spreadsheet Metadata

Configuration for getting spreadsheet metadata

Read Multiple Sheet Ranges

Configuration for reading multiple ranges at once

Write to Multiple Sheet Ranges

Configuration for writing to multiple ranges at once

Add Spreadsheet Sheet

Configuration for adding a new sheet/tab

Delete Spreadsheet Sheet

Configuration for deleting a sheet/tab

Copy Sheet to Spreadsheet

Configuration for copying a sheet to another spreadsheet

Rename Spreadsheet Sheet

Configuration for renaming a sheet/tab

Duplicate Sheet in Spreadsheet

Configuration for duplicating a sheet within the same spreadsheet

Find and Replace in Spreadsheet

Configuration for find and replace in a spreadsheet

Insert Sheet Rows

Configuration for inserting rows

Delete Sheet Rows

Configuration for deleting rows

Clear Multiple Sheet Ranges

Configuration for clearing multiple ranges at once

Insert Sheet Columns

Configuration for inserting columns

Delete Sheet Columns

Configuration for deleting columns

Salesforce

56 tools
Execute Soql Query

Execute a SOQL query to retrieve records

Get Query Result Next Batch

Get the next batch of query results using a query locator

Execute Sosl Search

Execute a SOSL search across multiple objects

Get Single Record

Get a single record by ID

Create Single Record

Create a new record

Update Single Record

Update an existing record

Delete Single Record

Delete a record

Upsert Record by External Id

Create or update a record using an external ID field

Create Multiple Records

Create multiple records in a single request (up to 200)

Update Multiple Records

Update multiple records in a single request (up to 200)

Delete Multiple Records

Delete multiple records in a single request (up to 200)

List Available Sobjects

List all available sObjects in the org

Get Sobject Metadata

Get detailed metadata for a specific sObject including all fields

Get Org Global Metadata

Get global metadata about the org

Get Org Api Limits

Get org API usage limits

Get Current User Info

Get information about the current authenticated user

Get Available Api Versions

Get available Salesforce API versions

Get User Available Tabs

Get available tabs for the user

List Approval Processes

List all approval processes in the org

Submit Record for Approval

Submit a record for approval

Approve or Reject Approval Request

Approve or reject a pending approval request

Get Blob Field Content

Get blob (binary) data for a record field like Attachment body or Document body

Create Record Attachment

Create an attachment on a record

Upload File As Content Version

Upload a file as ContentVersion (Files)

Execute Composite Api Request

Execute multiple REST API requests in a single call

Create Nested Record Tree

Create a tree of nested, parent-child records in a single request

Get Recently Viewed Records

Get recently viewed records

List Global Quick Actions

List available global quick actions

List Object Quick Actions

List quick actions for a specific object

Execute Quick Action

Execute a quick action

Get Sobject Page Layouts

Get page layouts for an object

Get Sobject Compact Layouts

Get compact layouts for an object

Create Bulk Data Job

Create a bulk ingest job for large data operations

Upload Csv to Bulk Job

Upload CSV data to a bulk job

Close Bulk Data Job

Close a bulk job to start processing

Get Bulk Job Status

Get the status of a bulk job

Get Bulk Job Results

Get results (successful or failed records) from a bulk job

Abort Bulk Data Job

Abort a bulk job

List Bulk Data Jobs

List bulk jobs

List Available Reports

List available reports

Execute Report and Get Results

Execute a report and get results

Get Report Metadata

Get metadata for a report

Get Deleted Records in Range

Get records deleted within a time range

Get Updated Records in Range

Get records updated within a time range

Execute Soql Query Including Deleted

Execute a SOQL query including deleted and archived records

List Object List Views

Get list views for an object

Get List View Details

Get details of a specific list view

Execute List View Query

Execute a list view and get results

List Available Dashboards

List available dashboards

Get Dashboard Data

Get dashboard data and metadata

Refresh Dashboard Data

Refresh a dashboard to get latest data

List Invocable Actions

List available standard invocable actions

Get Invocable Action Details

Get details of a specific invocable action

Execute Invocable Action

Execute an invocable action

Post Message to Chatter Feed

Post a message to Chatter feed

Get Chatter Feed Items

Get Chatter feed items

What you can build

Read a range of new leads from a sheet and create them all in Salesforce with Create Multiple Records.
Load a large sheet export into Salesforce through a bulk data job, then close the job once the rows finish.
Query Salesforce with a composite API request and write the results into a sheet range for a report.
Read a sheet that lists documents and upload each one as a content version on the matching Salesforce record.

About OpenClaw

OpenClaw is an open command-line agent. NoClick runs it hosted and lets you connect your apps to it as tools, so it can take real actions across your systems. Wire an integration into the agent and OpenClaw can call that app’s operations directly. It is a good fit when you want an open, no-fuss agent with real tool access and nothing to install.

Open and approachable
Simple to point at a task
Solid general tool use
Hosted, with nothing to install

Frequently asked questions

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.