Integration
Connect Archie and Google Sheets
When New Booking fires in Archie, your agent runs Add Row in Google Sheets, or Aggregate Metric Changed in Google Sheets to Create a document in Archie. 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 Archie 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)Grok
Open grok.com/connectors, choose New Connector, then Custom, and paste the address. Grok signs you in in your browser.
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 Archie and Google Sheets can do together
From Archie to Google Sheets
When New Booking in Archie
then Add Row in Google Sheets
From Google Sheets to Archie
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 Archie and Google Sheets
Triggers and actions 24 triggers · 235 actions
- New Booking
Triggers when a new booking is made in the Archie space.
- New Cart Purchase
Triggers when a new purchase (day pass, product or event ticket) is made in the Archie space.
- New Day Pass Check In
Triggers when someone checks in to the Archie space.
- New Event
Triggers when a new event is created in the Archie space.
- New Invoice
Triggers when a new invoice is created in the Archie space.
- New Payment
Triggers when a new payment is recorded in the Archie space.
- New Subscription
Triggers when a new subscription to a plan or product is created in the Archie space.
- New User
Triggers when a new user is added to the Archie space.
- Activate Area
Activate an Area
- Activate Children
Activate all children of an Area
- Activate Group
Activate an archived Group and given members for a Space
- Activity schedule (who is in)
Paginated activity schedule for all users in the space.
- Add Children
Add children to an Area
- Admin check-in a visit
Check in a visit as a space admin. Optional multipart form fields: checkInDate, fieldResults, deviceUUID.
- Admin checks out a user from the space
Updates a presence log to mark the user as checked out
- Archive Area
Archive an Area
- Archive Area Revision
Archive an Area Revision
- Archive Children
Archive children of an Area
- Archive Children Revisions
Archive all children revisions of an Area
- Archive Group
Archive a Group
- Archive Plan Version
Archive a plan revision (version)
- Archive Product Version
Archive a revision (version) of a product
- Archive Ticket Price
Archive a ticket price revision
- Assign an Issue Ticket
Assign an Issue Ticket for a space
- Booking Generate Invoice
Booking Generate Invoice
- Booking Send Details
Booking Send Details
- Cancel a document signature
Cancel a document signature workflow.
- Cancel Booking for a space
Cancel Booking for a space
- Cancel check-in for a space
Cancel check-in for a space
- Cancel Credit Note
Cancel a credit note
- Cancel Entity Deposit for a group
Cancel Entity Deposit for a group in a space
- Cancel Entity Deposit for a space
Cancel Entity Deposit for a space
- Cancel Entity Deposit for a user
Cancel Entity Deposit for a user in a space
- Cancel Event
Cancel an event
- Check if signature was requested for an email
Returns whether a document signature was requested for the given email on this document.
- Close an Issue Ticket
Close an Issue Ticket for a space
- Create a badge
Create a badge for a space.
- Create a Benefit Category
Create a Benefit for a space
- Create a custom Activity Status
Create a custom activity status for a space. Only statuses with type `custom` are accepted.
- Create a document
Create a document for the space. Use multipart form: `type`, `title`, `category`, optional `signatureExpirationDays`, `text` for text documents, or `file` for PDF documents.
- Create a document revision
Add a new revision for a document. Multipart: `text`, `requiresSignature`, optional `file` for file-type documents.
- Create a door access configuration
Create a door access configuration (space admin).
- Create an Accounting Code for a space
Create an Accounting Code for a space
- Create a Pipeline Stage
Create a Pipeline Stage for a space
- Create a Tax for a space
Create a Tax for a space
- Create Check-in for a group
Create Check-in for a group
- Create Check-in for a user
Create Check-in for a user
- Create Day Pass Version
Create a day pass revision
- Create leads form for space
Create leads form for space
- Create Payment Account for a space
Create Payment Account for a space
- Create Payment Method
Create a payment method for a space
- Create Ticket Price
Create a ticket price revision
- Delete a badge
Delete a badge.
- Delete a Building Guide Section
Delete a Building Guide Section for a space
- Delete a campus
Delete a campus and clear location assignments.
- Delete a charge
Delete a charge.
- Delete a Coupon for a space
Delete a Coupon for a space
- Delete a custom Activity Status
Delete a custom activity status. Only statuses with type `custom` can be deleted.
- Delete a deposit
Delete a deposit.
- Delete a document
Soft-delete a document.
- Delete a Door Access Account for a user in a space
Delete a Door Access Account for a user in a space
- Delete a door access configuration
Delete a door access configuration (space admin).
- Delete an Accounting Code for a space
Delete an Accounting Code for a space
- Delete an Amenity
Delete an Amenity for a space
- Delete an email template
Delete an email template by UUID (space admin).
- Delete an Issue ticket category
Delete an Issue ticket category for a space
- Delete an Opportunity
Delete an opportunity for a space
- Delete a Note for a Group
Delete a Note for a Group in a Space
- Delete a Note for a User
Delete a Note for a User in a Space
- Delete a Pipeline Stage
Delete a Pipeline Stage for a space
- Delete a presence log
Deletes a specific presence log by UUID
- Delete Area
Delete an Area
- Delete Area Revision
Delete an Area Revision
- Delete a Role for a space
Delete a Role for a space
- Delete a Segment for a space
Delete a Segment for a space
- Delete a space email
Required Scope | `emails:write`
- Delete a Tax for a space
Delete a Tax for a space
- Delete a Visit Type
Delete a Visit Type for a space
- Delete Children
Delete all children of an Area
- Delete Credit Note
Delete credit note
- Delete Credit Note Line
Delete a credit note line
- Delete Event Ticket
Delete a ticket
- Delete group file
Required Scope | `files:write`
- Delete Invoice
Delete Invoice
- Delete Invoice Line
Delete an Invoice Line
- Delete Line from Preview
Remove a line from the invoice preview
- Delete Line from Preview (2)
Remove a line from the invoice preview
- Delete Payment Account
Delete Payment Account
- Delete Payment Method
Delete a payment method
- Delete Plan
Delete a plan
- Delete Plan Version
Delete a plan revision (version)
- Delete Product
Delete a product
- Delete Product Version
Delete a revision (version) of a product
- Delete Quota for a space
Delete Quota for a space
- Delete Ticket Price
Delete a ticket price revision
- Delete user file
Required Scope | `files:write`
- Disable a Door Access Account for a user in a space
Disable a Door Access Account for a user in a space
- Disconnect a Door Access Account for a user in a space
Disconnect a Door Access Account for a user in a space
- Documents for Group
Get all Documents for a Group
- Documents for User
Get all Documents for a User
- Duplicate Area
Duplicate an Area
- Duplicate Area Revision
Duplicate an Area Revision
- Duplicate Event
Duplicate an event
- Enable a Door Access Account for a user in a space
Enable a Door Access Account for a user in a space
- End an evacuation
Required Scope | `evacuations:write`
- Export to CSV (2)
Get a download link to a CSV file containing all events.
- Export to CSV (6)
Get a download link to a CSV file containing all users for the given space.
- Extend document signature expiration
Set a new expiration date for a pending document signature.
- Get all Printing Accounts for a space
Get all Printing Accounts for a space
- Get an email template
Get an email template by key or UUID (space admin).
- Get an evacuation
Required Scope | `evacuations:read`
- Get Area
Get an Area
- Get Booking for a space
Get Booking for a space
- Get Bookings
Get a paginated list of bookings in a space using filters and sort options.
- Get Building Guide Sections
Get all Building Guide Sections for a space
- Get charges for a space
List all charges for a space.
- Get community manager
Returns the user designated as community manager for the space, including email.
- Get Credit Note
Get Credit Note for space
- Get Credit Notes
Get a paginated list of credit notes for space
- Get Credit Notes for Group
Get a paginated list of credit notes for group in space
- Get Credit Notes for Group (2)
Get a paginated list of credit notes for group in space
- Get Entity Deposits for a group
Get all Entity Deposits for a group in a space
- Get Entity Deposits for a space
Get all Entity Deposits for a space
- Get Entity Deposits for a user
Get all Entity Deposits for a user in a space
- Get Entity Invoices
Retrieve a paginated list of invoices for a specific entity (User or Group) within a space.
- Get Entity Invoices (2)
Retrieve a paginated list of invoices for a specific entity (User or Group) within a space.
- Get Event
Get an event for a space
- Get Event Ticket
Get a ticket for an event
- Get Group
Get a Group by UUID or Slug
- Get Invoice
Get Invoice for space
- Get Invoices
Get a paginated list of invoices for space
- Get Issue Ticket for a space
Get all issue ticket for a space
- Get leads form space
Get leads form space
- Get ongoing evacuation
Required Scope | `evacuations:read`
- Get Plan
Get a plan for a space
- Get Plans
Get all plans for a space
- Get Preview
Get invoice preview for an entity in a space
- Get Preview (2)
Get invoice preview for an entity in a space
- Get Preview (3)
Get invoice preview for an entity in a space
- Get Preview (4)
Get invoice preview for an entity in a space
- Get Product
Get a product for a space
- Get Quota for a space
Get Quota for a space
- Get User
Get a user in the space by ID
- List campuses
List campuses for an organization with assigned locations.
- List document signatures for a space
Paginated document signatures for the space with optional filters.
- List evacuations
Paginated list of evacuations for a space (requires evacuation feature and space admin).
- List Payments
Get a paginated list of payments for the specified Space. Without any query parameters, the service will return the first 40 items.
- List Purchases
Get a paginated list of purchases for the specified Space. Without any query parameters, the service will return the first 40 items.
- List Subscriptions
Get a paginated list of subscriptions for the specified Space.
- List Users
Get a paginated list of users for the specified Space. Without any query parameters, the service will return the first 40 users.
- List Visits
Get a paginated list of visits for the specified Space.
- Mark all popup emails as read
Required Scope | `emails-sent:write`
- Mark user as not safe
Required Scope | `evacuations:write`
- Mark user as safe
Required Scope | `evacuations:write`
- Move the pipeline stage section up in the list
Move the pipeline stage section up in the list by changing the rank
- Move the Segment up in the list
Move the Segment up in the list by changing the rank
- My activity schedule
Activity schedule for the current user only.
- Paginate leads forms for space
Paginate leads forms for space
- Preview an email template
Render HTML preview for a template (space admin).
- Print Credit Note
Print a credit note to PDF
- Print Invoice
Print an Invoice into PDF
- Publish Area Revision
Publish an Area Revision
- Publish Children Revisions
Publish all children revisions of an Area
- Publish Plan Version
Publish a plan revision (version)
- Publish Product Version
Publish a revision (version) of a product
- Publish Ticket Price
Publish a ticket price revision
- Refund Entity Deposit for a group
Refund Entity Deposit for a group in a space
- Refund Entity Deposit for a space
Refund Entity Deposit for a space
- Refund Entity Deposit for a user
Refund Entity Deposit for a user in a space
- Remove Children
Remove children from an Area
- Restore Credit Note Line
Restore a credit note line
- Restore Invoice Line
Restore an Invoice Line
- Restore Line in Preview
Restore a deleted line in the invoice preview
- Restore Line in Preview (2)
Restore a deleted line in the invoice preview
- Restore Preview
Restore invoice preview to initial values
- Restore Preview (2)
Restore invoice preview to initial values
- Send Credit Note
Send a credit note to the entity
- Send document for signature
Send or re-send a document signature request for the current user context.
- Send Invoice
Send an Invoice
- Set Primary Payment Method
Set a payment method as primary for a space
- Start an evacuation
Required Scope | `evacuations:write`
- Update a badge
Update a badge.
- Update a Benefit
Update a Benefit for a space
- Update a Benefit Category
Update a Benefit for a space
- Update a custom Activity Status
Update a custom activity status. Only statuses with type `custom` can be modified.
- Update a door access configuration
Update a door access configuration (space admin).
- Update an Accounting Code for a space
Update an Accounting Code for a space
- Update a Note for a Group
Update a Note for a Group in a Space
- Update a Note for a User
Update a Note for a User in a Space
- Update a Pipeline Stage
Update a Pipeline Stage for a space
- Update a Tax for a space
Update a Tax for a space
- Update availability end date for a Quota for a space
Update availability end date for a Quota for a space
- Update Children
Update all children of an Area
- Update Day Pass Version
Update a day pass revision
- Update Payment Account for a space
Update Payment Account for a space
- Update segments for a subscription for a space
Update segments for a subscription for a space
- Update Ticket Price
Update a ticket price revision
- 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 Archie
Archie to HubSpotHubSpot is your all-in-one stop for all of your marketing software needs.
Archie to SalesforceSalesforce is a leading enterprise customer relationship management (CRM) platform.
Archie to SlackSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
Archie to GmailGmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...
Archie to Google CalendarGoogle Calendar is a time management tool providing scheduling features, event reminders, and integration...
Archie to Google DriveGoogle Drive is a cloud storage solution for uploading, sharing, and collaborating on files across devices...
More into Google Sheets
Questions
Archie and Google Sheets, answered
What can start an automation from Archie?
Any of Archie's 8 triggers in the catalog, including New Booking, New Cart Purchase, New Day Pass Check In and New Event. 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 Archie?
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 Archie?
Yes. When something happens in Google Sheets, your agent can act in Archie too. This page covers both directions: Google Sheets's triggers and Archie's actions are listed here as well.
Do I have to build a connector for Archie 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 Archie 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.