Connect Hermes to Google Sheets and Shopify
What happens next
Set up in minutes
Choose where it runs
On your computer through your own Hermes, 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 Shopify
A preset of real Shopify 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 Shopify
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 Hermes first calls in.
1. Run this in your terminal
2. Answer no when asked if the server requires authentication — the link itself is the key
<your-link> is your personal server URL — setup mints it for you.
Exact capabilities
Tools Hermes 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
Shopify
103 toolsList products from the store with pagination and filtering
Get a single product by ID
Create a new product
Update an existing product
Delete a product
Get the count of products
List all variants for a product
Get a single product variant by ID
Create a new product variant
Update an existing product variant
Delete a product variant
Get the count of variants for a product
List all images for a product
Get a single product image by ID
Create a new product image
Delete a product image
List orders from the store with pagination and filtering
Get a single order by ID
Create a new order
Update an existing order
Delete an order
Cancel an order
Close an order
Reopen a closed order
Get the count of orders
List all refunds for an order
Get a single refund by ID
Create a refund for an order
Calculate refund transactions for an order
List all transactions for an order
Get a single transaction by ID
Create a transaction for an order
Get the count of transactions for an order
List customers from the store with pagination and filtering
Get a single customer by ID
Create a new customer
Update an existing customer
Delete a customer
Search for customers
Get the count of customers
Get orders for a specific customer
List all addresses for a customer
Get a single customer address by ID
Create a new address for a customer
Update an existing customer address
Delete a customer address
Set a customer address as the default
List inventory levels for items or locations
Adjust the inventory level of an item at a location
Set the inventory level of an item at a location
Connect an inventory item to a location
Delete an inventory level (disconnect item from location)
List fulfillments for an order
Get a single fulfillment
Create a fulfillment for an order
Update a fulfillment
Mark a fulfillment as complete
Cancel a fulfillment
List collections (custom collections)
Get a single collection
Create a new collection
Update a collection
Delete a collection
Add a product to a collection
List all locations
Get a single location
Get shop information
List metafields for a resource
Get a single metafield
Create a metafield
Update a metafield
Delete a metafield
List webhooks
Get a single webhook
Create a webhook
Update a webhook
Delete a webhook
List price rules
Get a single price rule
Create a price rule
Update a price rule
Delete a price rule
List discount codes for a price rule
Create a discount code for a price rule
Delete a discount code
List gift cards
Get a single gift card
Create a gift card
Update a gift card
Disable a gift card
Execute a custom GraphQL query (provides 100% API coverage)
Execute a custom GraphQL mutation (provides 100% API coverage)
Query products using GraphQL (more powerful than REST)
Create a product using GraphQL
Update a product using GraphQL
Query orders using GraphQL
Create a draft order using GraphQL
Query customers using GraphQL
Create a customer using GraphQL
Query inventory levels using GraphQL
Query collections using GraphQL
Query fulfillment orders using GraphQL
Get shop information using GraphQL
Starting points
What you can build
Meet the runner
About Hermes
Good to know
Frequently asked questions
Keep exploring
More ways to connect
More tools for Hermes
Popular Hermes pairs
Make it yours
Open your Hermes agent in one click.
NoClick runs Hermes for you with Google Sheets and Shopify wired in as tools. Connect your account and run.