--- title: "Connect Kiwili and Smartsheet - APIANT.ai" description: "When \"Accounting Code Created\" fires in Kiwili, your agent runs \"Add row\" in Smartsheet, or \"New row\" in Smartsheet to \"Create Contact\" in Kiwili." canonical: "https://apiant.ai/connect/kiwili-to-smartsheet" --- # Connect Kiwili and Smartsheet When **Accounting Code Created** fires in [Kiwili](https://apiant.ai/connections/kiwili), your agent runs **Add row** in [Smartsheet](https://apiant.ai/connections/smartsheet), or **New row** in Smartsheet to **Create Contact** in Kiwili. Describe the whole flow and it is built, tested on every scenario and kept running. Kiwili **42** triggers Kiwili **73** actions Smartsheet **3** triggers Smartsheet **26** actions What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it. ## What do you want Kiwili and Smartsheet to do together? Give your AI client this address. `https://mcp.apiant.ai` One connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser. ### Set it up in your client ### Claude Code Run this in the directory you want to work in. `claude mcp add --transport http -s project apiant-ai https://mcp.apiant.ai` Start Claude Code there, approve the server, and sign in in the browser page it opens. [Claude Code guide (opens in a new tab)](https://apiant.ai/docs/mcp/claude-code) ### Claude, web and desktop Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Cursor Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Zed Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Codex and the ChatGPT desktop app Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) ### Any other MCP client Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection. [Setup guide (opens in a new tab)](https://apiant.ai/docs/mcp) Example flows ## What Kiwili and Smartsheet can do together ### From Kiwili to Smartsheet - When **Accounting Code Created** in Kiwili then **Add row** in Smartsheet - When **Accounting Code Updated** in Kiwili then **Add row attachment** in Smartsheet ### From Smartsheet to Kiwili - When **New row** in Smartsheet then **Create Contact** in Kiwili - When **New sheet** in Smartsheet then **Create Invoice** in Kiwili Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships. Everything your agent can do with Kiwili and Smartsheet ## Triggers and actions 45 triggers · 99 actions - Trigger **Accounting Code Created** Triggers when a new Accounting Code is created. - Trigger **Accounting Code Deleted** Triggers when an Accounting Code is deleted. - Trigger **Accounting Code Updated** Triggers when an Accounting Code is updated. - Trigger **Bank Account Created** Triggers when a new Bank Account is created. - Trigger **Bank Account Deleted** Triggers when a Bank Account is deleted. - Trigger **Contact Created** Triggers when a new Contact is created. - Trigger **Contact Deleted** Triggers when a Contact is deleted. - Trigger **Contact Updated** Triggers when a Contact is updated. - Trigger **Enterprise Created** Triggers when an Enterprise is created. - Trigger **Enterprise Deleted** Triggers when an Enterprise is deleted. - Trigger **Enterprise Updated** Triggers when an Enterprise is updated. - Trigger **Expense Account Created** Triggers when an Expense Account is created. - Trigger **Expense Account Deleted** Triggers when an Expense Account is deleted. - Trigger **Expense Account Updated** Triggers when an Expense Account is updated. - Trigger **Invoice Created** Triggers when an Invoice is created. - Trigger **Invoice Deleted** Triggers when an Invoice is deleted. - Trigger **Invoice Payment Created** Triggers when an Invoice Payment is created. - Trigger **Invoice Payment Updated** Triggers when an Invoice Payment is updated. - Trigger **Invoice Updated** Triggers when an Invoice is updated. - Trigger **Payment Type Created** Triggers when a new Payment Type is created. - Trigger **Payment Type Deleted** Triggers when a Payment Type is deleted. - Trigger **Payment Type Updated** Triggers when a Payment Type is updated. - Trigger **Product Created** Triggers when an Product is created. - Trigger **Product Deleted** Triggers when an Product is deleted. - Trigger **Product Updated** Triggers when an Product is updated. - Trigger **Project Created** Triggers when a Project is created. - Trigger **Project Deleted** Triggers when a Project is deleted. - Trigger **Project Step Deleted** Triggers when a project step is deleted. - Trigger **Project Updated** Triggers when a Project is updated. - Trigger **Service Created** Triggers when a Service is created. - Trigger **Service Deleted** Triggers when a Service is deleted. - Trigger **Service Updated** Triggers when a Service is updated. - Trigger **Sprint Created** Triggers when a Sprint is created. - Trigger **Sprint Updated** Triggers when a Sprint is updated. - Trigger **Task Created** Triggers when a Task is created. - Trigger **Task Updated** Triggers when a Task is updated. - Trigger **Tax Profile Created** Triggers when an Tax Profile is created. - Trigger **Tax Profile Deleted** Triggers when an Tax Profile is deleted. - Trigger **Tax Profile Updated** Triggers when an Tax Profile is updated. - Trigger **Time Entry Created** Triggers when a Time Entry is created. - Trigger **Time Entry Deleted** Triggers when a Time Entry is deleted. - Trigger **Time Entry Updated** Triggers when a Time Entry is updated. - Action **Create Accounting Code** Creates a new accounting code in Kiwili's chart of accounts, with its code number, description, accounting class and tax reclaim percentage. - Action **Create Bank Account** Creates a new bank account in Kiwili with its name, currency and optional banking details. - Action **Create Contact** Creates a new contact under an enterprise (client company) in Kiwili. - Action **Create Enterprise** Creates a new enterprise (client, prospect or provider company) in Kiwili and returns the created enterprise record. - Action **Create Expense Account** Creates a new expense account in Kiwili, used to categorize expenses with a default price, tax profile and accounting code. - Action **Create Invoice** Creates a new invoice for a client enterprise in Kiwili, with one or more product or service lines. - Action **Create Invoice Payment** Records a payment against an existing invoice in Kiwili, with its amount, date, payment type and bank account. - Action **Create Payment Type** Creates a new payment type in Kiwili. - Action **Create Product** Creates a new product in Kiwili, with its price, identifiers, tax profile, accounting code, inventory and resale settings. - Action **Create Project** Creates a new project in Kiwili for an enterprise (client), with optional billing type, budget, rate, team and services. - Action **Create Project Step** Creates a new step (phase) within a Kiwili project, with optional budget, dates, administrator and team allocation. - Action **Create Service** Creates a new service in Kiwili, with its name, rate, category, tax profile and accounting code. - Action **Create Sprint** Creates a new sprint in Kiwili with its dates, administrator and optional resources. - Action **Create Task** Creates a new task in Kiwili, optionally linked to a project, client, sprint or service and assigned to a user. - Action **Create Tax Profile** Creates a new tax profile in Kiwili, with up to two tax rates, their labels and registration numbers. - Action **Create Time Entry** Creates a time entry in Kiwili, logging hours worked by a user on a project step and service. - Action **Delete Accounting Code** Deletes an accounting code from your Kiwili account. Only accounting codes that are not in use can be deleted. - Action **Delete Bank Account** Deletes a bank account from Kiwili. Only bank accounts that are not used anywhere can be deleted. - Action **Delete Contact** Deletes a contact from your Kiwili account. - Action **Delete Enterprise** Deletes an enterprise (company client) from Kiwili. Only enterprises that are not in use can be deleted. - Action **Delete ExpenseAccount** Deletes an unused expense account in Kiwili. - Action **Delete Invoice** Deletes an invoice in Kiwili. Only invoices still in Draft status can be deleted. - Action **Delete Payment Type** Deletes a payment type from your Kiwili account. Only payment types not used by any payment can be deleted. - Action **Delete Product** Deletes a product from your Kiwili account. Only products that are not used on any document can be deleted. - Action **Delete Project** Deletes a project in Kiwili. Only projects that are not in use can be deleted. - Action **Delete Project Step** Deletes a project step in Kiwili. Only steps that are not in use can be deleted. - Action **Delete Service** Deletes a service from your Kiwili account. Only services not used on any document can be deleted. - Action **Delete Tax Profile** Deletes a tax profile from your Kiwili account. Only tax profiles that are not in use can be deleted. - Action **Delete Time Entry** Deletes a time entry from your Kiwili account. - Action **Find Accounting Code** Returns the accounting codes that match the search text or filters you specify, such as code, description or accounting class. - Action **Find Bank Account** Returns the Kiwili bank accounts that match the search text or the filters you supply, such as name, currency, account number or accounting code. - Action **Find Enterprise** Searches the enterprises (companies and clients) in your Kiwili account by name, email, code or any other property and returns the ones that match. - Action **Find ExpenseAccount** Searches the expense accounts in your Kiwili account by text, name, category, tax profile, price or other criteria and returns the matching expense accounts. - Action **Find Payment Type** Returns the payment types in your Kiwili account that match a name, search text or id range. - Action **Find Product** Returns the products in your Kiwili account that match the search text or filters you supply, such as name, SKU, UPC, category or price range. - Action **Find Project** Searches Kiwili projects by name, code, client, contact or other project details and returns the matching projects. - Action **Find Project Step** Searches the project steps in your Kiwili account by text, project, name, dates, budget or completion, and returns the matching steps. - Action **Find Service** Searches the services in your Kiwili account by text, name, number, category, rate and other criteria, and returns the matching services. - Action **Find Sprint** Searches the sprints in your Kiwili account by text, name, dates, administrator or other criteria and returns the matching sprints. - Action **Find Task** Returns the tasks that match the search text or the filters you choose, such as summary, project, assignee, status or due date. - Action **Find TaxProfile** Finds tax profiles in Kiwili by search text, description, tax labels, numbers or rates, and returns the matching tax profiles. - Action **Get Accounting Code** Returns one accounting code from your Kiwili chart of accounts by its id, including its code number, description, accounting class and tax reclaim percentage. - Action **Get Bank Account** Returns a single bank account from your Kiwili account by its ID, including its name, currency, account numbers and accounting code. - Action **Get Contact** Returns a single Kiwili contact by its ID, including name, email, phone numbers, address and the enterprise it belongs to. - Action **Get Enterprise** Returns a Kiwili enterprise (client, prospect or provider company) by its id, with its address, contact details and billing settings. - Action **Get ExpenseAccount** Returns a single expense account from Kiwili, including its name, description, default price, category, tax profile and accounting code. - Action **Get Invoice** Returns a single Kiwili invoice by its id, including its lines, totals, balance, status and payment details. - Action **Get InvoicePayment** Returns a single invoice payment from Kiwili by its id, including the amount, payment date, invoice and bank account it belongs to. - Action **Get Payment Type** Returns a single payment type (such as cash, cheque or credit card) by its id. - Action **Get Product** Returns a single product from Kiwili by its id, including its price, SKU, category, tax profile and inventory settings. - Action **Get Project** Returns a single Kiwili project by its ID, including its client, billing type, budget, team and services. - Action **Get Project Step** Returns a single project step (phase) of a Kiwili project by its ID, including its dates, budget, completion and team. - Action **Get Service** Returns a single Kiwili service by its id, including its name, number, rate, category, tax profile and accounting code. - Action **Get Sprint** Returns a single Kiwili sprint by its id, including its dates, administrator and assigned resources. - Action **Get Task** Returns a single Kiwili task by its id, including its summary, status, priority, dates, assignee and linked project, sprint and enterprise. - Action **Get TaxProfile** Returns a single Kiwili tax profile by its id, including its tax rates, labels and tax numbers. - Action **Get Time Entry** Returns a single time entry by its id, including date, hours, start and end times, user, project, service and billing status. - Action **Update Accounting Code** Updates an existing accounting code in Kiwili, changing its code number, description, accounting class or tax reclaim percentage. Fields left blank keep their current values. - Action **Update Bank Account** Updates an existing bank account in Kiwili, such as its name, description, currency, account numbers, credit limit or active status. - Action **Update Contact** Updates an existing contact in Kiwili, such as their name, email, phone, address or enterprise. Fields left blank are not changed. - Action **Update Enterprise** Updates an existing enterprise (client, prospect or provider company) in Kiwili. Only the fields you fill in are changed. - Action **Update ExpenseAccount** Updates an existing expense account in Kiwili, such as its name, description, default price, category, tax profile or accounting code. - Action **Update Invoice** Updates an existing invoice in Kiwili, including its client, dates, lines, taxes and status. Returns the updated invoice. - Action **Update InvoicePayment** Updates an existing invoice payment in Kiwili, such as its amount, date, payment type or bank account. - Action **Update Payment Type** Updates the name of an existing payment type in Kiwili. - Action **Update Product** Updates an existing product in Kiwili, changing only the details you provide, and returns the updated product. - Action **Update Project** Updates an existing project in Kiwili, such as its name, client, billing type, budget, rate or team, and returns the updated project. - Action **Update Project Step** Updates an existing project step in Kiwili, such as its name, dates, budget, progress or assigned team, and returns the updated step. - Action **Update Service** Updates an existing service in Kiwili, such as its name, rate, category, tax profile or billable status. - Action **Update Sprint** Updates an existing sprint in Kiwili, including its name, dates, administrator, status and assigned resources. - Action **Update Task** Updates an existing task in Kiwili, such as its summary, assignee, dates, priority or status. - Action **Update TaxProfile** Updates an existing tax profile in Kiwili, such as its description, tax rates, labels and registration numbers. Kiwili only allows the rates of tax profiles that are not yet in use to be changed. - Action **Update Time Entry** Updates an existing time entry in Kiwili, such as its date, hours, project, service or billing status. - Trigger **New row** Triggered when a new row is added to the specified sheet. Polls rows modified since the last check and emits new ones. - Trigger **New sheet** Triggered when a new sheet is created. Polls the list of sheets and emits newly seen ones. - Trigger **Updated row** Triggered when any row is updated in the specified sheet. Polls rows modified since the last check and emits updated ones. - Action **Add column** /sheets/{sheetId}/columns - add columns to a sheet. - Action **Add comment** /sheets/{sheetId}/discussions/{discussionId}/comments - add a comment to a discussion. - Action **Add discussion** Starts a new discussion on a sheet with a first comment, and returns the discussion. - Action **Add folder** /folders/{folderId}/folders or /home/folders - create a folder. - Action **Add home folder** Creates a folder at the top level of your Sheets home and returns it. - Action **Add row** Adds a new row to the specified sheet. Provide cells as an array of {columnId, value}. Set location to Top or Bottom. - Action **Add row attachment** /sheets/{sheetId}/rows/{rowId}/attachments - attach file or URL to a row. - Action **Add sheet** /sheets - create a sheet with columns. - Action **Copy row to another sheet** Copies a row from one sheet to another sheet. The placement of the cells in the destination sheet is determined by Smartsheet's logic. - Action **Copy sheet** /sheets/{sheetId}/copy - copy a sheet to a folder/workspace. - Action **Delete row** Deletes a row from a sheet given its Row ID. - Action **Delete row if deal does not exist in ActiveCampaign (Cisco)** Compares deals from ActiveCampaign with the Smartsheet 'ActiveCampaign Deal ID' column. Deletes rows whose deal ID is not present in the supplied list of existing ActiveCampaign deal IDs. Built from intent against Smartsheet API 2.0. - Action **Find rows** Searches for rows in a specified sheet containing the specified value (in any column). Returns zero or more row IDs. Use the 'Get row' action within a Loop to fetch each row's contents. - Action **Find rows by column value** Searches for rows in a specified sheet having the specified value in a specified column. Zero, one, or multiple row IDs may be returned. - Action **Find sheets by keyword** Returns the sheets that match the specified keyword. - Action **Find single row** Searches for a single row in a specified sheet matching the specified value (in any column). If zero or multiple rows are found, an error occurs. - Action **Find single row by column value** Searches for a single row in a specified sheet having the specified value in a specified column. If zero or multiple rows are found, an error occurs. - Action **Get discussion** Returns a sheet discussion with its title and comments. - Action **Get folder** Returns a folder with the folders and sheets directly inside it. - Action **Get row** Returns the column data for the specified row. An error occurs if the row is not found. - Action **Get sheet** Fetches a sheet by ID, including its columns and rows. An error occurs if the sheet is not found. - Action **List row attachments** Returns the attachments on a row of a Smartsheet sheet, such as files and links, with their names, types and addresses. - Action **Move row to another sheet** Moves a row from one sheet to another sheet. The placement of the cells in the destination sheet is determined by Smartsheet's logic. - Action **Two-way sync add or update a row** Creates or updates a row in a sheet. For use only with two-way sync triggers. If a Row ID is supplied the row is updated; otherwise a new row is added. - Action **Update row** Updates a row in a specified sheet. Provide the Row ID and cells as an array of {columnId, value}. - Action **Update sheet** /sheets/{sheetId} - update sheet properties (name, project settings). ## Each app on its own - [ **Kiwili** ERP & online account management software for your small business](https://apiant.ai/connections/kiwili) - [ **Smartsheet** Smartsheet is a work execution platform for managing sheets, rows, and columns.](https://apiant.ai/connections/smartsheet) Reviews ## What our customers say ## More from Kiwili - [ **Kiwili to Salesforce** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/kiwili-to-salesforce) - [ **Kiwili to Slack** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/kiwili-to-slack) - [ **Kiwili to Mailchimp** Mailchimp marketing automation and email platform.](https://apiant.ai/connect/kiwili-to-mailchimp) - [ **Kiwili to Stripe** Stripe is a payment processing platform for online businesses.](https://apiant.ai/connect/kiwili-to-stripe) - [ **Kiwili to Shopify** Shopify is a commerce platform for online stores and retail point-of-sale.](https://apiant.ai/connect/kiwili-to-shopify) - [ **Kiwili to QuickBooks Online** QuickBooks Online accounting — manage customers, invoices, bills, payments, vendors, expenses, and more via...](https://apiant.ai/connect/kiwili-to-quickbooks-online) ## More into Smartsheet - [ **Salesforce to Smartsheet** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/salesforce-to-smartsheet) - [ **Mailchimp to Smartsheet** Mailchimp marketing automation and email platform.](https://apiant.ai/connect/mailchimp-to-smartsheet) - [ **ServiceM8 to Smartsheet** ServiceM8 is a field service app and small business management platform for your computer, iPhone and iPad.](https://apiant.ai/connect/servicem8-to-smartsheet) - [ **HubSpot to Smartsheet** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/hubspot-to-smartsheet) - [ **Slack to Smartsheet** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/slack-to-smartsheet) - [ **Google Sheets to Smartsheet** Google Sheets](https://apiant.ai/connect/google-sheets-to-smartsheet) Questions ## Kiwili and Smartsheet, answered ### ### What can start an automation from Kiwili? Any of Kiwili's 42 triggers in the catalog, including Accounting Code Created, Accounting Code Updated, Bank Account Created and Contact Created. Describe the moment in plain language and your agent picks the right one. ### ### What can your agent do in Smartsheet when something happens in Kiwili? Any of Smartsheet's 26 actions, including Update row, Update sheet, Add column and Add comment. Your agent maps the data both ways and tests every scenario before it ships. ### ### Can it also run from Smartsheet to Kiwili? Yes. When something happens in Smartsheet, your agent can act in Kiwili too. This page covers both directions: Smartsheet's triggers and Kiwili's actions are listed here as well. ### ### Do I have to build a connector for Kiwili or Smartsheet? No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running. ### ### Can my AI client use Kiwili and Smartsheet without building an automation? Yes. With your AI client connected to APIANT, ask it to do something in either app once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running. One connection covers both. ### ### What happens when something fails? Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships. ### ### Is there a free plan? Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.