How does Hermes turn a Google Doc into BigQuery tables?

It uses Fetch Document Content to read the spec, then Create Dataset, Create Table, and Create Routine to build what the doc describes. You allowlist which of those create operations it can run, so it only provisions what you permit.

Can it edit existing docs or only make new ones?

Both. Append Text, Insert Text, and Replace Document Text let it update a living data dictionary, while Create New Document starts a fresh one. List Google Drive Documents helps it find the right file first.

Do my BigQuery and Google credentials reach the model?

No. They resolve server-side at run time and never ride the model. Hermes reads and writes through the credentials you connect, limited to the projects and documents those credentials cover.

Hermes is an open agent based on Nous Research’s Hermes models. NoClick runs it for you and adds your connected apps as tools.

How do I give Hermes access to an app?

Connect the app's integration node to the agent's tools handle and pick the operations to expose. Each becomes a callable tool.

Do I need my own infrastructure?

No. The harness runs in a hosted sandbox and NoClick handles credentials for the apps you connect.

Can Hermes use multiple apps at once?

Yes. Wire in several integrations and the agent can use them together in a single run.

Connect Hermes to Google BigQuery and Google Docs

Give Hermes your BigQuery and Google Docs together and it can turn a written spec into real tables and keep the docs current as the schema changes. BigQuery holds the datasets, tables, and routines, and Google Docs is where the spec starts and the data dictionary lives. Hermes can read a spec from a Doc and create the matching BigQuery objects, or create a table and write its schema back into a Doc. The design and the warehouse stay in sync because one agent works both ends.

Loading preview…

Opens a workflow with 44 tools ready to use.

Tools Hermes gets

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

Google BigQuery

38 tools

Run Query

Run a SQL query and return results inline (synchronous, bounded by timeout).

Get Query Results

Page through the results of a (possibly async) query job.

Insert Job

Start a query / load / extract / copy job (async).

Get Job

Fetch a job's status and statistics (poll until DONE).

List Jobs

List jobs in a project (filter by state, time range).

Cancel Job

Request cancellation of a running job.

Delete Job

Delete a job's metadata.

List Datasets

List datasets in the project.

Get Dataset

Fetch dataset metadata.

Create Dataset

Create a new dataset.

Update Dataset

Full replace of dataset metadata (PUT).

Patch Dataset

Partial update of dataset metadata (PATCH).

Delete Dataset

Delete a dataset.

List Tables

List tables/views in a dataset.

Get Table

Fetch table metadata/schema.

Create Table

Create a table or view with a schema.

Patch Table

Partial update of a table (add columns, set expiration, etc.).

Update Table

Full replace of table metadata (PUT).

Delete Table

Delete a table or view.

Stream Insert Rows

Streaming insert of JSON rows into a table (real-time append).

List Table Data

Read rows from a table directly (paginated, no SQL).

List Routines

List stored procedures / UDFs / TVFs in a dataset.

Get Routine

Fetch a routine definition.

Create Routine

Create a stored procedure / UDF / TVF.

List Models

List BigQuery ML models in a dataset.

Get Model

Fetch BQML model metadata.

Delete Model

Delete a BQML model.

Get Service Account

Return the BigQuery service account for the project (KMS/transfer grants).

List Projects

List projects the caller can access (for project picker UIs).

Undelete Dataset

Restore a dataset within its time-travel window (datasets.undelete).

Update Routine

Replace a routine's full definition (routines.update, PUT).

Delete Routine

Delete a routine (routines.delete).

Patch Model

Update mutable BQML model metadata (models.patch).

Get Table IAM Policy

Get the IAM policy for a table (tables.getIamPolicy).

Set Table IAM Policy

Set the IAM policy for a table (tables.setIamPolicy).

Test Table IAM Permissions

Test the caller's permissions on a table (tables.testIamPermissions).

List Row Access Policies

List row access policies on a table (rowAccessPolicies.list).

Get Row Access Policy

Get a single row access policy (rowAccessPolicies.get).

Google Docs

6 tools

List Google Drive Documents

Configuration for listing documents from Google Drive

Fetch Document Content

Configuration for getting a document

Create New Document

Configuration for creating a new document

Append Text to Document

Configuration for appending text to a document

Insert Text in Document

Configuration for inserting text at a specific location

Replace Document Text

Configuration for replacing text in a document

What you can build

Read a schema spec from a Google Doc and create the matching BigQuery dataset, tables, and routines from it.

Create a BigQuery table and append its columns to a running Google Doc data dictionary.

Create a new Google Doc that documents a fresh BigQuery dataset and its starter tables.

Replace the schema section of a Google Doc when you rebuild a BigQuery routine so the doc matches the warehouse.

About Hermes

Hermes is an open agent built on Nous Research’s Hermes models. NoClick runs it hosted and connects your apps to it as tools, so it can do real work across your systems. Wire an integration into the agent and Hermes can use that app’s operations directly while it reasons through a task. It is a strong pick when you want an open-model agent with genuine tool access.

Built on open Hermes models

Capable general reasoning

Flexible, open-model foundation

Hosted with apps wired in as tools