Integration · Company data

Connect Claude & ChatGPT to Orca Scan

Ask your AI what is recorded for a barcode, to add a new item to a sheet, or who changed a row in Orca Scan. It can list your sheets, look up rows by barcode, add and update rows, add and change columns, read change history and give people access to a sheet.

Connect Orca Scan free

Free plan, no credit card. Takes about a minute.

Try asking

“What do we have on file for barcode 5701234567890?”
The AI finds the sheet and looks up the row for that barcode.
“Add a new item to the Inventory sheet: barcode 123456, name Blue mug, quantity 40.”
It reads the sheet's columns and adds the row. If the barcode already exists, that row is updated instead.
“Set the quantity for the blue mug to 35.”
It finds the row and changes only the quantity field.

What your AI can do

Sheets and rows

List sheets, look up rows by barcode, and add, update and delete rows.

Columns

Create sheets, list their columns, and add or change columns with labels, formats and settings.

History and access

Read the change history of a row or a whole sheet, and list or add the people who can use a sheet.

“Who changed the price on this item, and when?”
It reads the row's change history: who changed what and when.
“Add a Location column to the Assets sheet.”
It adds a text column with that label to the sheet.
“Give [email protected] access to the Assets sheet, without delete rights.”
It adds him with the permissions you set, and he receives an invitation email.

15 tools for Orca Scan

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

add_sheet_fieldChanges dataAdd a column to a sheet: pass `sheet_id`, a `label` and a `format` (such as text, number or date), plus optional settings like required or list options.
add_sheet_rowChanges dataAdd a row to a sheet: pass `sheet_id` and the row values in `body`, keyed by field key (include barcode). If the barcode already exists, that row is updated instead.
add_sheet_userChanges dataGive someone access to a sheet: pass `sheet_id`, their `email` and permissions (can_update, can_delete, can_export, can_admin). They receive an invitation email.
create_sheetChanges dataCreate a new sheet with a `name`, optional description, and optionally start from a template.
delete_sheet_rowDeletesPermanently delete one row by `sheet_id` and `row_id`. This cannot be undone.
get_row_historyGet the change history of one row by `sheet_id` and `row_id`: who changed what and when.
get_sheet_rowGet one row by `sheet_id` and `row_id`.
list_sheet_fieldsList the columns (fields) of a sheet by `sheet_id`, with their keys and formats. Use the keys when adding or updating rows.
list_sheet_historyGet the recent change history of a whole sheet by `sheet_id`.
list_sheet_rowsList the rows of a sheet by `sheet_id`; pass `barcode` to look up the row for a scanned barcode.
list_sheet_usersList the people who have access to a sheet by `sheet_id`, with their permissions.
list_sheetsList your Orca Scan sheets with their IDs. Start here to find the sheet you want to work with.
rename_sheetVisible to othersRename a sheet by `sheet_id` with a new `name` and optional description.
update_sheet_fieldChanges dataUpdate a column's label, format or settings by `sheet_id` and `field_key`.
update_sheet_rowChanges dataUpdate one row by `sheet_id` and `row_id` with new values in `body`; set `partial` to true to change only the fields you pass.

Set up in three steps

1
Pick the app
Create a free PipMCP account and choose Orca Scan from the app list.
2
Paste your key
Paste your Orca Scan API key. You need an Orca Scan Business subscription. Log in to the Orca Scan web app at cloud.orcascan.com, open Account Settings and copy your API key.
3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
1. Click your name, then Settings › Connectors › Add custom connector.
2. Paste your link as the Remote MCP server URL.
3. Switch it on from the + menu in a chat.

Questions

What can the AI do in Orca Scan?

The AI can list sheets, columns, rows, row and sheet history, and the people with access to a sheet. It can look up a row by barcode, create and rename sheets, add and change columns, add and update rows, give people access to a sheet, and delete a row if you switch that tool on.

Does the AI see my Orca Scan credentials?

No. Your Orca Scan API key is encrypted at rest and never shown to the AI. After you save it, it is not shown again, not even to you. The AI only sees the results of the tools it calls.

Can I control what the AI is allowed to do?

Yes. You choose which tools are switched on, so you can start read-only. Deleting a row cannot be undone, and giving someone access sends them an invitation email, so these can require your approval before they run. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your PipMCP link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.

What does it cost?

PipMCP has a free plan with no credit card required. Paid plans bill per completed task. You also need your own Orca Scan account on a Business subscription, which the Orca Scan API needs.

Which Orca Scan plan do I need?

You need an Orca Scan Business subscription to use the API. On that plan, you find your API key under Account Settings in the Orca Scan web app at cloud.orcascan.com.