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 229 tools ready to use.

What happens next

Set up in minutes

The open button drops you into a guided setup. It asks exactly this, nothing else:
  1. Choose where it runs

    On your computer through your own OpenClaw, or hosted in the cloud. The rest of setup adapts to your choice:

  2. 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.

  3. 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.

  4. Connect Google Sheets

    One sign-in. The agent acts through your account, scoped to the operations you picked.

  5. Connect Salesforce

    One sign-in. The agent acts through your account, scoped to the operations you picked.

  6. 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

    $openclaw mcp add noclick --url https://mcp.noclick.app/s/<your-link>

    <your-link> is your personal server URL — setup mints it for you.

Exact capabilities

Tools OpenClaw gets

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

Google Sheets

85 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

Format Cells

Configuration for formatting a range of cells

Update Sheet Properties

Configuration for sheet-level display properties

Auto-Resize Columns Or Rows

Configuration for auto-sizing columns or rows to fit their contents

Set Column Width Or Row Height

Configuration for setting an explicit column width or row height

Merge Cells

Configuration for merging cells

Unmerge Cells

Configuration for unmerging cells

Add Or Remove Borders

Configuration for drawing borders on a range

Add Alternating Colours

Configuration for alternating row colours

Set Filter

Configuration for adding a filter to a range

Clear Filter

Configuration for removing a filter

Add Conditional Formatting

Configuration for a conditional formatting rule

Sort Range

Configuration for sorting a range

Add Dropdown Or Input Rule

Configuration for adding a dropdown or input rule to a range

Remove Dropdown Or Input Rule

Configuration for removing dropdowns / input rules from a range

Remove Conditional Formatting

Configuration for removing conditional formatting rules

Remove Alternating Colours

Configuration for removing alternating row colours

Convert Range To Table

Configuration for turning a range into a Sheets table

Delete Table

Configuration for removing a table

Edit Conditional Formatting

Configuration for editing or reordering a conditional formatting rule

Recolour Alternating Colours

Configuration for recolouring existing banding in place

Edit Table

Configuration for changing a table's name, range or column types

Update Spreadsheet Properties

Configuration for spreadsheet-level properties

Add Named Range

Configuration for naming a range

Update Named Range

Configuration for changing a named range

Delete Named Range

Configuration for removing a named range

Protect Range

Configuration for protecting a range from edits

Update Protected Range

Configuration for changing a protected range

Unprotect Range

Configuration for removing range protection

Cell Notes

Configuration for putting a hover note on cells

Insert Smart Chips

Configuration for inserting people or link smart chips

Pivot Table

Configuration for anchoring a pivot table

Copy And Paste Range

Configuration for copying a range onto another

Cut And Paste Range

Configuration for moving a range

Paste Delimited Text

Configuration for pasting delimited text

Auto-Fill Range

Configuration for extending a series

Split Text To Columns

Configuration for splitting a column of text

Trim Whitespace

Configuration for trimming whitespace

Remove Duplicate Rows

Configuration for removing duplicate rows

Randomise Range

Configuration for shuffling rows

Insert Cells

Configuration for inserting cells and shifting the rest

Delete Cells

Configuration for deleting cells and shifting the rest

Move Rows Or Columns

Configuration for moving rows or columns

Append Rows Or Columns

Configuration for appending blank rows or columns

Add Chart

Configuration for adding a chart

Edit Chart

Configuration for changing an existing chart

Move Or Resize Chart

Configuration for moving or resizing a chart

Set Chart Border

Configuration for a chart's border colour

Delete Chart

Configuration for removing a chart

Append Rows After Data

Configuration for appending rows of cells after the last row of data

Filter View

Configuration for creating a saved filter view

Update Filter View

Configuration for changing a filter view

Duplicate Filter View

Configuration for copying a filter view

Delete Filter View

Configuration for removing a filter view

Group Rows Or Columns

Configuration for grouping rows or columns

Collapse Or Expand Group

Configuration for collapsing or expanding a group

Ungroup Rows Or Columns

Configuration for ungrouping rows or columns

Add Slicer

Configuration for adding a slicer control

Update Slicer

Configuration for changing a slicer

Add Developer Metadata

Configuration for tagging a sheet, row or column with durable metadata

Update Developer Metadata

Configuration for changing developer metadata

Delete Developer Metadata

Configuration for removing developer metadata

Connect BigQuery Data Source

Configuration for connecting a BigQuery data source

Repoint Data Source

Configuration for repointing a data source

Delete Data Source

Configuration for disconnecting a data source

Refresh Data Source

Configuration for refreshing connected data

Cancel Data Source Refresh

Configuration for cancelling a running refresh

Salesforce

144 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

Convert Lead

Convert Lead

Merge Records

Merge Records

Create Task

Create Task

Update Task

Update Task

Create Event

Create Event

Update Event

Update Event

Create Note

Create Note

Add Campaign Member

Add Campaign Member

Update Campaign Member Status

Update Campaign Member Status

Create Campaign

Create Campaign

Add Case Comment

Add Case Comment

Add Opportunity Line Item

Add Opportunity Line Item

Add Contact to Opportunity

Add Contact to Opportunity

Assign Permission Set to User

Assign Permission Set to User

Reset User Password

Reset User Password

Get Content Document

Get Content Document

Download Content Version

Download Content Version

List Content Versions

List Content Versions

Delete Content Document

Delete Content Document

Create Content Document Link

Create Content Document Link

List Files Linked to Record

List Files Linked to Record

Send Single Email

Send Single Email

Send Email via Template

Send Email via Template

List Email Templates

List Email Templates

Send Mass Email

Send Mass Email

Get Chatter Feed Item

Get Chatter Feed Item

Delete Chatter Feed Item

Delete Chatter Feed Item

Create Chatter Comment

Create Chatter Comment

Get Chatter Comments

Get Chatter Comments

Delete Chatter Comment

Delete Chatter Comment

Like Chatter Feed Item

Like Chatter Feed Item

Get Record Chatter Feed

Get Record Chatter Feed

Get Chatter User Profile

Get Chatter User Profile

List Chatter Groups

List Chatter Groups

Post to Chatter Group

Post to Chatter Group

Get Chatter Group Members

Get Chatter Group Members

Send Chatter Direct Message

Send Chatter Direct Message

Get Chatter Direct Messages

Get Chatter Direct Messages

Search Chatter

Search Chatter

Get Chatter News Feed

Get Chatter News Feed

Execute Anonymous Apex

Execute Anonymous Apex

Run Apex Tests

Run Apex Tests

Get Apex Test Results

Get Apex Test Results

Query Debug Logs

Query Debug Logs

Get Debug Log Body

Get Debug Log Body

Create Trace Flag

Create Trace Flag

Get Apex Code Coverage

Get Apex Code Coverage

Tooling SOQL Query

Tooling SOQL Query

Get Pending Approval Items

Get Pending Approval Items

Recall Approval Request

Recall Approval Request

Get Approval History

Get Approval History

Get Bulk Job Failed Results

Get Bulk Job Failed Results

Get Bulk Job Unprocessed Results

Get Bulk Job Unprocessed Results

Delete Bulk Data Job

Delete Bulk Data Job

Create Bulk Query Job

Create Bulk Query Job

Get Bulk Query Job Results

Get Bulk Query Job Results

Execute Composite Batch

Execute Composite Batch

Bulk Retrieve Records

Bulk Retrieve Records

Composite Update Multiple

Composite Update Multiple

Run Report Async

Run Report Async

Get Async Report Result

Get Async Report Result

Get Dashboard Component Data

Get Dashboard Component Data

List Report Folders

List Report Folders

Execute Flow

Execute Flow

List Flows

List Flows

Invoke Email Alert Action

Invoke Email Alert Action

Invoke Field Update Action

Invoke Field Update Action

Get Org Info

Get Org Info

Parameterized Search

Parameterized Search

Get Search Suggestions

Get Search Suggestions

Explain Query Plan

Explain Query Plan

Get Record Count

Get Record Count

List Users

List Users

Get User

Get User

Update User

Update User

List Profiles

List Profiles

List Roles

List Roles

Get Org Storage Usage

Get Org Storage Usage

List External Data Sources

List External Data Sources

Query External Object

Query External Object

Create External Object Record

Create External Object Record

List Knowledge Articles

List Knowledge Articles

Create Knowledge Article

Create Knowledge Article

Publish Knowledge Article

Publish Knowledge Article

Attach Article to Case

Attach Article to Case

Publish Platform Event

Publish Platform Event

List Platform Event Channels

List Platform Event Channels

Get List View Results with Columns

Get List View Results with Columns

Starting points

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.

Meet the runner

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

Good to know

Frequently asked questions

Keep exploring

More ways to connect

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.