Will it overwrite contacts that already exist in HubSpot?

That depends on the operation you expose. Batch Upsert Records updates matches and creates the rest, while Batch Create Records only adds new ones, so you pick the behavior by choosing which operation to allowlist.

Does OpenClaw see my HubSpot API key?

No. You connect the credential once and it resolves server-side when a tool runs. The key never passes through the model.

Can it read from HubSpot as well as write?

Yes, if you allowlist Batch Read Records. Then it can pull records from HubSpot and write them into a sheet range, which is how the reporting flows work.

How does OpenClaw act on my apps?

You connect an integration to the agent's tools handle and select operations. OpenClaw calls those operations as tools while it runs.

Is there anything to install?

No. NoClick runs the OpenClaw harness for you in a hosted sandbox.

Can I run it on a schedule?

Yes. A hosted agent can be started from a schedule, a webhook, or another app event.

Which apps can it use?

Any of NoClick’s tool-provider integrations across communication, CRM, developer tools, databases, and more.

Connect OpenClaw to Google Sheets and HubSpot

Connect Google Sheets and HubSpot to OpenClaw and it can keep a spreadsheet and your CRM in step in one pass. The sheet is often where raw rows land first, and HubSpot is where contacts and companies need to end up. OpenClaw reads a range, batches the records into HubSpot, and can pull HubSpot data back into a sheet for reporting. With both tools wired in, sync work that people do row by row becomes one job.

Loading preview…

Opens a workflow with 314 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:

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 HubSpot
A preset of real HubSpot 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 HubSpot
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
$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

HubSpot

229 tools

List Contacts

Get Contact

Create Contact

Update Contact

Delete Contact

Search Contacts

List Companies

Get Company

Create Company

Update Company

Delete Company

Search Companies

List Deals

Get Deal

Create Deal

Update Deal

Delete Deal

Search Deals

List Support Tickets

Get Support Ticket

Create Support Ticket

Update Support Ticket

Delete Support Ticket

Search Support Tickets

List Leads

Get Lead

Create Lead

Update Lead

Delete Lead

Search Leads

List Products

Get Product

Create Product

Update Product

Delete Product

Search Products

List Line Items

Get Line Item

Create Line Item

Update Line Item

Delete Line Item

Search Line Items

List Quotes

Get Quote

Create Quote

Update Quote

Delete Quote

Search Quotes

List Note Activities

Get Note Activity

Create Note Activity

Update Note Activity

Delete Note Activity

Search Note Activities

List Task Activities

Get Task Activity

Create Task Activity

Update Task Activity

Delete Task Activity

Search Task Activities

List Call Activities

Get Call Activity

Create Call Activity

Update Call Activity

Delete Call Activity

Search Call Activities

List Meeting Activities

Get Meeting Activity

Create Meeting Activity

Update Meeting Activity

Delete Meeting Activity

Search Meeting Activities

List Email Activities

Get Email Activity

Create Email Activity

Update Email Activity

Delete Email Activity

Search Email Activities

List Orders

Get Order

Create Order

Update Order

Delete Order

Search Orders

List Account Owners

Create Record Association

Delete Record Association

List Record Associations

List Custom Properties

Get Custom Property

Create Custom Property

Update Custom Property

Archive Custom Property

List Pipelines

Get Pipeline

Create Pipeline

Update Pipeline

Replace Pipeline

Delete Pipeline

List Pipeline Stages

Get Pipeline Stage

Create Pipeline Stage

Update Pipeline Stage

Replace Pipeline Stage

Delete Pipeline Stage

Batch Create Records

Batch Read Records

Batch Update Records

Batch Archive Records

Batch Upsert Records

List Contact Lists

Get Contact List

Create Contact List

Update Contact List

Delete Contact List

Add Contacts to List Batch

List Custom Object Schemas

Get Custom Object Schema

Create Custom Object Schema

Update Custom Object Schema

Delete Custom Object Schema

Purge Custom Object Schema

List Marketing Events

Get Marketing Event

Create Marketing Event

Update Marketing Event

Delete Marketing Event

Create Event Attendance

Get Event Attendance

Delete Event Attendance

List Marketing Campaigns

Get Marketing Campaign

Create Marketing Campaign

Update Marketing Campaign

Delete Marketing Campaign

Get Campaign Assets

Update Campaign Budget

Send Custom Event

List Custom Event Definitions

Create Custom Event Definition

Update Custom Event Definition

List Hubdb Tables

Get Hubdb Table

Create Hubdb Table

Update Hubdb Table

Publish Hubdb Table

Delete Hubdb Table

List Hubdb Rows

Get Hubdb Row

Create Hubdb Row

Update Hubdb Row

Delete Hubdb Row

Clone Hubdb Table

Get Contact Subscription Status

Subscribe Contact to List

Unsubscribe Contact from List

List Subscription Types

List Website Pages

Get Website Page

Create Website Page

Update Website Page

Delete Website Page

Publish Website Page

List Blog Posts

Get Blog Post

Create Blog Post

Update Blog Post

Delete Blog Post

List Blog Authors

Get Blog Author

Create Blog Author

List Blog Topics

Get Blog Topic

List Files

Get File

Upload File

Update File

Delete File

List Domains

Get Domain

List Url Redirects

Get Url Redirect

Create Url Redirect

Update Url Redirect

Delete Url Redirect

Search Website Content

List Conversation Threads

Get Conversation Thread

List Conversation Messages

Send Conversation Message

List Communication Channels

Get Communication Channel

Identify Website Visitor

Get Visitor

Update Conversation Status

List Workflows

Get Workflow

Enroll Contact in Workflow

Unenroll Contact from Workflow

List Sequences

Get Sequence

Enroll Contact in Sequence

Unenroll Contact from Sequence

List Users

Get User

Create User

Update User

Delete User

List Business Units

Get Business Unit

Get Account Info

List Audit Logs

List Goals

Get Goal

List Teams

Get Team

List Roles

Get Role

Create Data Export

Get Export Status

Download Data Export

Create Data Import

Get Import Status

Get Access Token Info

Revoke Access Token

List Api Scopes

Validate Access Token

List Feedback Submissions

Get Feedback Submission

Starting points

What you can build

Read a range of new signups from a sheet and batch upsert them into HubSpot as contacts.

Batch read HubSpot contacts and write them into a fresh sheet range for a weekly report.

Pull account and contact ids from a sheet and create the record associations between them in HubSpot.

Read a segment from a sheet, add those contacts to a HubSpot list in one batch, and append the run log back to the sheet.

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