Integration
Connect Smartsheet via API Token to Harpoon
When something happens in Smartsheet via API Token, your agent does the next thing in Harpoon. Describe it in plain language and the automation is built, tested on every branch and kept running.
Build it
What do you want Smartsheet via API Token and Harpoon to do together?
Describe it and your agent reads both APIs, builds the automation, tests every branch and ships it. The list below is what exists today, not the limit.
Ask the assistant
You'll sign in before anything runs. What you typed comes with you.
Or work from Claude Code
Install the APIANT plugin for Claude Code and build, edit, test and read run history from your terminal. Every plan gets this, including free, and it spends no assistant credits.
Connect Claude CodeEverything your agent can do with Smartsheet via API Token and Harpoon
Triggers and actions 18 triggers · 139 actions
Trigger
List contactsList contacts
Trigger
List dashboardsList dashboards
Trigger
List org groupsList org groups
Trigger
List reportsList reports
Trigger
List sheetsList sheets
Trigger
List workspacesList workspaces
Trigger
New favoriteTriggers when a new item is added to your favorites.
Trigger
New rowPolling trigger: fires when a new row is added to the specified sheet. Each row carries a stable id for deduplication.
Trigger
New search resultTriggers when a new item matches your search query.
Action
Add columnsAdd columns
Action
Add favoritesAdd favorites
Action
Add image to cellAdd image to cell
Action
Add rowsAdd one or more rows to a sheet. Provide an array of row objects with cells.
Action
Add summary fieldsAdd summary fields
Action
Attach file or URL to commentAttach file or URL to comment
Action
Attach file or URL to rowAttach file or URL to row
Action
Attach file or URL to sheetAttach file or URL to sheet
Action
Attach new versionAttach new version
Action
Copy folderCopy folder
Action
Copy rows to another sheetCopy rows to another sheet
Action
Copy sheetCopy sheet
Action
Copy workspaceCopy workspace
Action
Create a commentCreate a comment
Action
Create a discussion on a rowCreate a discussion on a row
Action
Create an update requestCreate an update request
Action
Create cross-sheet referencesCreate cross-sheet references
Action
Create discussionCreate discussion
Action
Create folderCreate a folder in the user's Home.
Action
Create folder in workspaceCreate folder in workspace
Action
Create proofCreate proof
Action
Create proof discussionCreate proof discussion
Action
Create proof requestCreate proof request
Action
Create sheetCreates a new sheet with the given name and columns in the user's home "Sheets" area. To create a sheet inside a specific folder or workspace, use Create sheet in folder or Create sheet in workspace.
Action
Create sheet in folderCreate sheet in folder
Action
Create sheet in workspaceCreate sheet in workspace
Action
Create workspaceCreate workspace
Action
Delete a commentDelete a comment
Action
Delete a discussionDelete a discussion
Action
Delete an update requestDelete an update request
Action
Delete attachmentDelete attachment
Action
Delete columnDelete column
Action
Delete favoritesRemoves one or more objects of a given type from the user's Smartsheet favorites. Accepts a single object ID or a comma-separated list.
Action
Delete folderDelete folder
Action
Delete reportDelete report
Action
Delete rowsDelete rows
Action
Delete sent update requestDelete sent update request
Action
Delete sheetDelete a sheet by id.
Action
Delete summary fieldsDelete summary fields
Action
Delete workspaceDelete workspace
Action
Edit a commentEdit a comment
Action
Get a commentGet a comment
Action
Get an update requestGet an update request
Action
Get attachmentGet attachment
Action
Get columnGet column
Action
Get contactGet contact
Action
Get cross-sheet referenceGet cross-sheet reference
Action
Get discussionGet discussion
Action
Get folder metadataGet folder metadata
Action
Get proofGet proof
Action
Get reportGet report
Action
Get rowGet a single row from a sheet by row id.
Action
Get sent update requestGet sent update request
Action
Get sheetGet a sheet by id, including its rows and columns.
Action
Get sheet summaryGet sheet summary
Action
Get summary fieldsGet summary fields
Action
Get userGet user
Action
Get workspaceRetrieves a Smartsheet workspace by ID, including its sheets, folders, reports, sights, templates, permalink, and access level.
Action
Is favoriteIs favorite
Action
List attachmentsList attachments
Action
List columnsList all columns of a sheet.
Action
List contentsList contents
Action
List cross-sheet referencesList cross-sheet references
Action
List discussion attachmentsList discussion attachments
Action
List discussionsList discussions
Action
List discussions with a rowList discussions with a row
Action
List folder childrenList folder children
Action
List foldersList the folders in the user's Home.
Action
List proof attachmentsList proof attachments
Action
List proofsList proofs
Action
List row attachmentsList row attachments
Action
List sheet rowsConvenience read: returns the rows of a sheet (the full sheet object with rows and columns).
Action
List sheetsList all sheets the user has access to.
Action
Lists sent update requestsLists sent update requests
Action
List update requestsList update requests
Action
List workspace childrenList workspace children
Action
List workspacesList all workspaces the user has access to.
Action
Move folderMove folder
Action
Move rows to another sheetMove rows to another sheet
Action
Move sheetMove sheet
Action
SearchSearch across all sheets the user can access for the given text.
Action
Search sheetSearch a specific sheet for the given text.
Action
Send report via emailSend report via email
Action
Send rows via emailSend rows via email
Action
Send sheet via emailSend sheet via email
Action
Sort rows in sheetSort rows in sheet
Action
Update an update requestUpdate an update request
Action
Update columnUpdate column
Action
Update folderUpdate folder
Action
Update proof statusUpdate proof status
Action
Update rowsUpdate one or more existing rows in a sheet. Provide an array of row objects each with an id and cells.
Action
Update sheetUpdate sheet
Action
Update summary fieldsUpdate summary fields
Action
Update workspaceUpdate workspace
Trigger
New ClientTriggered when a new client is created in Harpoon.
Trigger
New ContactTriggered when a new contact is created in Harpoon.
Trigger
New ExpenseTriggered when a new expense is created in your Harpoon account.
Trigger
New Expense CategoryTriggered when a new expense category is created in Harpoon.
Trigger
New InvoiceTriggered when a new invoice is created in Harpoon.
Trigger
New PaymentTriggered when a new payment is recorded in your Harpoon account.
Trigger
New ProjectTriggered when a new project is created in Harpoon.
Trigger
New Task CategoryTriggered when a new task category is added in your Harpoon account.
Trigger
New Time EntryTriggered when a new time entry is logged in Harpoon.
Action
Add Credit EntryCreates a new credit entry on a client's account in Harpoon, recording an amount, a date and an optional note or originating invoice. Returns the credit entry that was created.
Action
Add InvoiceCreates a new invoice in Harpoon for a client or project, with an invoice number, issue date, and optional line items. Returns the invoice that was created.
Action
Add Lead SourceCreates a new lead source in Harpoon, so new clients can be tagged with where they came from. Returns the lead source that was created.
Action
Add NoteAdds a note to a client, project or invoice in Harpoon. Returns the note that was created.
Action
Add TeamCreates a new team in your Harpoon account. Harpoon populates the new team from your account details; the API accepts no team attributes on creation.
Action
Clone Time EntryCreates a copy of an existing time entry in Harpoon. The copy keeps the original's project, task and description, and starts with today's date and zero hours logged.
Action
Create ContactCreates a contact person under a Harpoon client, with their name, email address, and phone number. Returns the contact that was created.
Action
Create ExpenseRecords a one-off expense in Harpoon with its date, amount, and vendor, optionally attributed to a client, project, or expense category. Returns the expense that was created.
Action
Create Expense CategoryCreates a new expense category in your Harpoon account so expenses can be grouped under it.
Action
Create ProjectCreates a project in Harpoon for a client, with its budget, rate, and start and end dates. Returns the project that was created.
Action
Create Time EntryLogs hours worked in Harpoon for a team member on a given date, optionally against a client or project. Returns the time entry that was created.
Action
Delete ClientDeletes a client from your Harpoon account.
Action
Delete ExpensePermanently deletes an expense from your Harpoon account.
Action
Delete InvoicePermanently removes an invoice from Harpoon. Returns Harpoon's confirmation that the invoice was deleted.
Action
Delete NoteDeletes a note from your Harpoon account.
Action
Delete Recurring ExpenseDeletes a recurring expense template from Harpoon by its id, so it stops generating new expenses.
Action
Delete Recurring InvoiceStops and removes a recurring invoice schedule in Harpoon so it no longer generates invoices. Returns Harpoon's confirmation that it was deleted.
Action
Delete Time EntryDeletes a time entry from your Harpoon account.
Action
Get ClientReturns a single client from your Harpoon account, including its name, contact details and other stored attributes.
Action
Get Client CreditsReturns a client's credit entries in Harpoon, along with the credit still available on the account.
Action
Get ContactReturns a single Harpoon contact, including their name, email address, phone number, and the client they belong to.
Action
Get EstimateReturns a single estimate from your Harpoon account, including its client, line items, totals and status.
Action
Get ExpenseReturns a single expense from your Harpoon account, including its amount, date, vendor, category and the client or project it is attached to.
Action
Get Expense CategoryReturns a single Harpoon expense category with every detail it carries, including its name and budget settings.
Action
Get InvoiceFetches one invoice from Harpoon by its id, with its client, line items and payment totals. An error occurs if the invoice is not found.
Action
Get Lead SourceReturns a single lead source from your Harpoon account.
Action
Get ProjectReturns a single project from your Harpoon account, including its client, budget and status.
Action
Get Recurring ExpenseFetches one recurring expense template from Harpoon by its id, with its vendor, amount, frequency and schedule. An error occurs if it is not found.
Action
Get Recurring InvoiceReturns a single recurring invoice schedule from Harpoon, including its client, frequency, dates, and line items.
Action
Get TaskReturns a single task category from your Harpoon account, including its name and hourly rate.
Action
Get TeamReturns a single team from your Harpoon account, including its name, email address, phone, address, owner and whether it is active.
Action
Get Time EntryReturns a single tracked time entry from your Harpoon account, including its date, hours, client, project and notes.
Action
List ContactsReturns the contacts in your Harpoon account, including each contact's name, email address and phone number.
Action
List EstimatesReturns the estimates in a Harpoon account, optionally narrowed to a year, client, project, status, or search text.
Action
List Expense CategoriesReturns the expense categories set up in Harpoon, each with its budget settings.
Action
List ExpensesReturns the expenses in your Harpoon account, optionally narrowed by date range, client, project, category, billing status or search text.
Action
List ProjectsReturns the projects in a Harpoon account, with their client, budget, rate, and dates.
Action
List TeamsReturns the teams in your Harpoon account, along with the total number of teams found.
Action
List Time EntriesReturns time entries from your Harpoon account — either the timers running now or logged history for a date range — optionally narrowed by client, project, task, team member or billing status.
Action
Update ExpenseUpdates an existing expense in your Harpoon account. Only the values you supply are changed.
Action
Update InvoiceUpdates an existing invoice in your Harpoon account. Only the values you supply are changed.
Action
Update ProjectUpdates an existing project in Harpoon — its name, client, billing type, status, dates, budget and task rates. Returns the updated project.
Action
Update Recurring ExpenseUpdates a recurring expense in Harpoon — its vendor, amount, frequency, category, dates, and status. Anything left blank keeps its current value. Returns the updated recurring expense.
Action
Update Recurring InvoiceUpdates an existing recurring invoice template in your Harpoon account. Only the values you supply are changed.
Action
Update Time EntryUpdates an existing time entry in Harpoon — its date, hours, description, project, task or billing state.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.