Integration
Connect Bind ERP and Google Sheets
When New Activity fires in Bind ERP, your agent runs Add Row in Google Sheets, or Aggregate Metric Changed in Google Sheets to Create Comment in Bind ERP. Describe the whole flow and it is built, tested on every scenario and kept running.
What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.
Build solutions, not workarounds.
What do you want Bind ERP and Google Sheets to do together?
Ask the assistant
Connect your AI client
Give your AI client this address.
https://mcp.apiant.aiOne 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.aiStart Claude Code there, approve the server, and sign in in the browser page it opens.
Claude Code guide (opens in a new tab)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)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)Zed
Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.
Setup guide (opens in a new tab)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)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)Example flows
What Bind ERP and Google Sheets can do together
From Bind ERP to Google Sheets
When New Activity in Bind ERP
then Add Row in Google Sheets
From Google Sheets to Bind ERP
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 Bind ERP and Google Sheets
Triggers and actions 22 triggers · 102 actions
- New Activity
Triggers when a new activity is scheduled on the Bind ERP calendar.
- New Invoice
Triggers when a new invoice is created in Bind ERP.
- New Product
Triggers when a new product is added in Bind ERP.
- New Prospect
Triggers when a new prospect is created in Bind ERP.
- New Quote
Triggers when a new quote is created in Bind ERP.
- Updated Inventory
Triggers when a product's inventory level changes in a Bind ERP warehouse.
- Create Accounting Journal
Creates a accounting journal in Bind ERP.
- Create Comment
Creates a comment in Bind ERP.
- Delete Account
Deletes a account from Bind ERP.
- Delete Client
Deletes a client from Bind ERP.
- Delete Formula
Deletes a formula from Bind ERP.
- Delete Invoice
Deletes a invoice from Bind ERP.
- Delete Order
Deletes a order from Bind ERP.
- Delete Product
Deletes a product from Bind ERP.
- Delete Prospect
Deletes a prospect from Bind ERP.
- Delete Provider
Deletes a provider from Bind ERP.
- Delete Quote
Deletes a quote from Bind ERP.
- Delete Service
Deletes a service from Bind ERP.
- Get Client
Returns one client from Bind ERP.
- Get Company Profile
Returns one company profile from Bind ERP.
- Get Expense
Returns one expense from Bind ERP.
- Get Expense Payments
Returns one expense from Bind ERP.
- Get Formula
Returns one formula from Bind ERP.
- Get Invoice
Returns one invoice from Bind ERP.
- Get Invoice Payments
Returns one invoice from Bind ERP.
- Get Order
Returns one order from Bind ERP.
- Get Product
Returns one product from Bind ERP.
- Get Prospect
Returns one prospect from Bind ERP.
- Get Quote
Returns one quote from Bind ERP.
- Get Service
Returns one service from Bind ERP.
- Get User Profile
Returns one user profile from Bind ERP.
- List Account Categories
Returns a page of account category records from Bind ERP, with optional OData filtering, sorting and paging.
- List Accounting Journals
Returns a page of accounting journal records from Bind ERP, with optional OData filtering, sorting and paging.
- List Accounts
Returns a page of account records from Bind ERP, with optional OData filtering, sorting and paging.
- List Activities
Returns a page of activity records from Bind ERP, with optional OData filtering, sorting and paging.
- List Bank Accounts
Returns a page of bank account records from Bind ERP, with optional OData filtering, sorting and paging.
- List Banks
Returns a page of bank records from Bind ERP, with optional OData filtering, sorting and paging.
- List Categories
Returns a page of category records from Bind ERP, with optional OData filtering, sorting and paging.
- List Cities
Returns a page of city records from Bind ERP, with optional OData filtering, sorting and paging.
- List Clients
Returns a page of client records from Bind ERP, with optional OData filtering, sorting and paging.
- List Comments
Returns a page of comment records from Bind ERP, with optional OData filtering, sorting and paging.
- List Currencies
Returns a page of currency records from Bind ERP, with optional OData filtering, sorting and paging.
- List Formulas
Returns a page of formula records from Bind ERP, with optional OData filtering, sorting and paging.
- List Inventory
Returns a page of inventory records from Bind ERP, with optional OData filtering, sorting and paging.
- List Invoices
Returns a page of invoice records from Bind ERP, with optional OData filtering, sorting and paging.
- List Locations
Returns a page of location records from Bind ERP, with optional OData filtering, sorting and paging.
- List Merchandise Receptions
Returns a page of inventory records from Bind ERP, with optional OData filtering, sorting and paging.
- List Merchandise Transfers
Returns a page of merchandise transfer records from Bind ERP, with optional OData filtering, sorting and paging.
- List Orders
Returns a page of order records from Bind ERP, with optional OData filtering, sorting and paging.
- List Price Lists
Returns a page of price list records from Bind ERP, with optional OData filtering, sorting and paging.
- List Product Price and Inventory
Returns a page of product price and inventory records from Bind ERP, with optional OData filtering, sorting and paging.
- List Products
Returns a page of product records from Bind ERP, with optional OData filtering, sorting and paging.
- List Prospects
Returns a page of prospect records from Bind ERP, with optional OData filtering, sorting and paging.
- List Providers
Returns a page of provider records from Bind ERP, with optional OData filtering, sorting and paging.
- List Purchase Orders
Returns a page of purchase records from Bind ERP, with optional OData filtering, sorting and paging.
- List Quotes
Returns a page of quote records from Bind ERP, with optional OData filtering, sorting and paging.
- List Series
Returns a page of series records from Bind ERP, with optional OData filtering, sorting and paging.
- List Services
Returns a page of service records from Bind ERP, with optional OData filtering, sorting and paging.
- List States
Returns a page of state records from Bind ERP, with optional OData filtering, sorting and paging.
- List Users
Returns a page of user records from Bind ERP, with optional OData filtering, sorting and paging.
- List Warehouses
Returns a page of warehouse records from Bind ERP, with optional OData filtering, sorting and paging.
- Update Provider
Updates an existing provider in Bind ERP.
- Aggregate Metric Changed
Fires when an aggregate metric (sum/avg/count/…) over a column changes.
- Cell Range Values Changed
Fires when the values in a specific cell range change.
- Conditional Format Rule Changed
Fires when a conditional-format rule changes.
- Data Validation Rule Changed
Fires when a data-validation rule changes.
- Developer Metadata Changed
Fires when developer metadata changes.
- Filtered Range Values Changed
Fires when the values in a filtered range change.
- New Rows
Fires when new rows are appended to a Google Sheet.
- New Sheet Added
Fires when a new sheet (tab) is added to a spreadsheet.
- New Spreadsheet Created
Fires when a new spreadsheet is created in the account.
- Spreadsheet Metadata Changed
Fires when spreadsheet metadata changes.
- Spreadsheet Properties Changed
Fires when spreadsheet properties change.
- Spreadsheet Row Changed
Fires when a row matching a query changes.
- Spreadsheet Search Match
Fires when a spreadsheet matching search criteria is found.
- Table Query Result Changed
Fires when the result of a SQL-style table query changes.
- Table Schema Changed
Fires when a table's column schema changes.
- Worksheet Names Changed
Fires when worksheet (tab) names change.
- Add Row
Append a row to a Google Sheet
- Aggregate Column Data
Read a range and compute an aggregate (sum|avg|min|max|count) over one column, skipping blank/non-numeric cells (so a header row is skipped automatically).
- Auto-Resize Rows or Columns
Auto-fit row heights or column widths over an index range via autoResizeDimensions.
- Change Sheet Properties
Update a worksheet's grid properties (row/column count) using an explicit field mask.
- Clear Basic Filter
Remove the basic filter from a sheet via clearBasicFilter.
- Clear Spreadsheet Row(s)
Clear the values in a range (formatting preserved).
- Copy Range
Copy a source cell range to a destination range within the spreadsheet.
- Copy Worksheet
Copy a worksheet into a destination spreadsheet.
- Create Chart
Add a basic embedded chart (column/bar/line/etc.) built from a domain range and a series range on a sheet. Returns the new chartId.
- Create Conditional Formatting Rule
Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells.
- Create Multiple Spreadsheet Rows
Append many rows in one call.
- Create Spreadsheet
Create a new Google Sheets spreadsheet with the given title.
- Create Spreadsheet Column
Insert a blank column at a given index.
- Create Spreadsheet Row
Append a single row of values to a sheet range.
- Create Spreadsheet Row at Top
Insert a blank row just below the header (row 2), then write the given values into it in one operation.
- Create Worksheet
Add a new worksheet (tab) to an existing spreadsheet.
- Delete Chart
Delete an embedded chart via deleteEmbeddedObject.
- Delete Sheet
Delete a worksheet from a spreadsheet by sheetId (gid).
- Delete Spreadsheet Row(s)
Delete a contiguous block of rows by index.
- Find and Replace
Find and replace text across the spreadsheet. Supply EXACTLY ONE scope: all_sheets=true OR sheet_id. Leave the other unset (do not pass all_sheets=false together with sheet_id).
- Find Spreadsheet
Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection).
- Find Worksheet
Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties.
- Format Cell Range
Apply background color and bold formatting to a cell range via repeatCell.
- Format Spreadsheet Row
Apply a background color across an entire row via repeatCell over a row range.
- Get Conditional Format Rules
List all conditional-format rules on each sheet (paired with the sheetId so a follow-up update can target a rule by index).
- Get Data Range
Read all values in one or more ranges via batchGet.
- Get Data Validation Rules
Read the data-validation rule set on every cell of a range (per-cell dataValidation, via includeGridData with a field mask).
- Get Many Spreadsheet Rows (Advanced)
Read multiple ranges at once via batchGet.
- Get Row by ID
Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity.
- Get Sheet Names
Return the titles of all sheets (tabs) in the spreadsheet.
- Get Spreadsheet by ID
Fetch spreadsheet metadata (title, sheets, gids, grid properties).
- List Charts
List all embedded charts (chartId + title) across every sheet in the spreadsheet.
- Lookup Spreadsheet Row
Read a range and return the FIRST row whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).
- Lookup Spreadsheet Rows (Advanced)
Read multiple ranges via batchGet and return ALL rows whose cell at column_index equals match_value (Sheets has no server-side filter; this op filters the returned rows).
- Move Chart
Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition.
- Rename Sheet
Rename a worksheet's title.
- Search Spreadsheets
Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection.
- Set Basic Filter
Apply a basic filter to a range on a sheet via setBasicFilter.
- Set Data Validation
Apply a ONE_OF_LIST dropdown data-validation rule to a cell range.
- Sort Range
Sort a cell range by one column in ascending or descending order.
- Update Chart
Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec.
- Update Conditional Format Rules
Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule.
- Update Data Validation Rule
Overwrite the data-validation rule on a cell range with a ONE_OF_LIST dropdown (same endpoint as create; setDataValidation replaces whatever rule the range held).
- Update Spreadsheet Row
Overwrite the values at a specific range.
- Update Spreadsheet Row(s)
Update one or more disjoint ranges in a single batch.
- Upsert Row
Read a range, find the row whose column_index cell equals match_value; UPDATE that row when found, otherwise APPEND a new row. One adaptive write request (method+path chosen by the match script).
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews
What our customers say
More from Bind ERP
Bind ERP to HubSpotHubSpot is your all-in-one stop for all of your marketing software needs.
Bind ERP to SalesforceSalesforce is a leading enterprise customer relationship management (CRM) platform.
Bind ERP to SlackSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
Bind ERP to GmailGmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...
Bind ERP to Google CalendarGoogle Calendar is a time management tool providing scheduling features, event reminders, and integration...
Bind ERP to Google DriveGoogle Drive is a cloud storage solution for uploading, sharing, and collaborating on files across devices...
More into Google Sheets
Questions
Bind ERP and Google Sheets, answered
What can start an automation from Bind ERP?
Any of Bind ERP's 6 triggers in the catalog, including New Activity, New Invoice, New Product and New Prospect. Describe the moment in plain language and your agent picks the right one.
What can your agent do in Google Sheets when something happens in Bind ERP?
Any of Google Sheets's 46 actions, including Create Chart, Create Conditional Formatting Rule, Create Multiple Spreadsheet Rows and Create Spreadsheet. Your agent maps the data both ways and tests every scenario before it ships.
Can it also run from Google Sheets to Bind ERP?
Yes. When something happens in Google Sheets, your agent can act in Bind ERP too. This page covers both directions: Google Sheets's triggers and Bind ERP's actions are listed here as well.
Do I have to build a connector for Bind ERP or Google Sheets?
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 Bind ERP and Google Sheets 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.