--- title: "Connect Google Sheets to Hospitable - APIANT.ai" description: "When \"Aggregate Metric Changed\" fires in Google Sheets, your agent runs \"Create Task\" in Hospitable." canonical: "https://apiant.ai/connect/google-sheets-to-hospitable" --- # Connect Google Sheets to Hospitable When **Aggregate Metric Changed** fires in [Google Sheets](https://apiant.ai/connections/google-sheets), your agent runs **Create Task** in [Hospitable](https://apiant.ai/connections/hospitable). Describe the whole flow and it is built, tested on every scenario and kept running. Google Sheets **16** triggers Google Sheets **46** actions Hospitable **65** actions What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it. ## What do you want Google Sheets and Hospitable 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 Google Sheets can start in Hospitable - When **Aggregate Metric Changed** in Google Sheets then **Create Task** in Hospitable - When **Cell Range Values Changed** in Google Sheets then **Send a Message for an Inquiry** in Hospitable 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 Google Sheets and Hospitable ## Triggers and actions 16 triggers Β· 111 actions - Trigger **Aggregate Metric Changed** Fires when an aggregate metric (sum/avg/count/…) over a column changes. - Trigger **Cell Range Values Changed** Fires when the values in a specific cell range change. - Trigger **Conditional Format Rule Changed** Fires when a conditional-format rule changes. - Trigger **Data Validation Rule Changed** Fires when a data-validation rule changes. - Trigger **Developer Metadata Changed** Fires when developer metadata changes. - Trigger **Filtered Range Values Changed** Fires when the values in a filtered range change. - Trigger **New Rows** Fires when new rows are appended to a Google Sheet. - Trigger **New Sheet Added** Fires when a new sheet (tab) is added to a spreadsheet. - Trigger **New Spreadsheet Created** Fires when a new spreadsheet is created in the account. - Trigger **Spreadsheet Metadata Changed** Fires when spreadsheet metadata changes. - Trigger **Spreadsheet Properties Changed** Fires when spreadsheet properties change. - Trigger **Spreadsheet Row Changed** Fires when a row matching a query changes. - Trigger **Spreadsheet Search Match** Fires when a spreadsheet matching search criteria is found. - Trigger **Table Query Result Changed** Fires when the result of a SQL-style table query changes. - Trigger **Table Schema Changed** Fires when a table's column schema changes. - Trigger **Worksheet Names Changed** Fires when worksheet (tab) names change. - Action **Add Row** Append a row to a Google Sheet - Action **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). - Action **Auto-Resize Rows or Columns** Auto-fit row heights or column widths over an index range via autoResizeDimensions. - Action **Change Sheet Properties** Update a worksheet's grid properties (row/column count) using an explicit field mask. - Action **Clear Basic Filter** Remove the basic filter from a sheet via clearBasicFilter. - Action **Clear Spreadsheet Row(s)** Clear the values in a range (formatting preserved). - Action **Copy Range** Copy a source cell range to a destination range within the spreadsheet. - Action **Copy Worksheet** Copy a worksheet into a destination spreadsheet. - Action **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. - Action **Create Conditional Formatting Rule** Add a boolean conditional formatting rule (e.g. NUMBER_GREATER) that colors matching cells. - Action **Create Multiple Spreadsheet Rows** Append many rows in one call. - Action **Create Spreadsheet** Create a new Google Sheets spreadsheet with the given title. - Action **Create Spreadsheet Column** Insert a blank column at a given index. - Action **Create Spreadsheet Row** Append a single row of values to a sheet range. - Action **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. - Action **Create Worksheet** Add a new worksheet (tab) to an existing spreadsheet. - Action **Delete Chart** Delete an embedded chart via deleteEmbeddedObject. - Action **Delete Sheet** Delete a worksheet from a spreadsheet by sheetId (gid). - Action **Delete Spreadsheet Row(s)** Delete a contiguous block of rows by index. - Action **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). - Action **Find Spreadsheet** Find spreadsheets by exact name via the Drive API (cross-host through the googlesheets connection). - Action **Find Worksheet** Return the worksheet whose title matches the given title (sheet_id/index/found), reading the spreadsheet's sheet properties. - Action **Format Cell Range** Apply background color and bold formatting to a cell range via repeatCell. - Action **Format Spreadsheet Row** Apply a background color across an entire row via repeatCell over a row range. - Action **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). - Action **Get Data Range** Read all values in one or more ranges via batchGet. - Action **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). - Action **Get Many Spreadsheet Rows (Advanced)** Read multiple ranges at once via batchGet. - Action **Get Row by ID** Read a single row range. NOTE: Google Sheets has no row ID; the row number IS the identity. - Action **Get Sheet Names** Return the titles of all sheets (tabs) in the spreadsheet. - Action **Get Spreadsheet by ID** Fetch spreadsheet metadata (title, sheets, gids, grid properties). - Action **List Charts** List all embedded charts (chartId + title) across every sheet in the spreadsheet. - Action **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). - Action **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). - Action **Move Chart** Reposition an embedded chart to a new overlay anchor cell via updateEmbeddedObjectPosition. - Action **Rename Sheet** Rename a worksheet's title. - Action **Search Spreadsheets** Search spreadsheets by name substring (or full-text) via the Drive API, cross-host through the googlesheets connection. - Action **Set Basic Filter** Apply a basic filter to a range on a sheet via setBasicFilter. - Action **Set Data Validation** Apply a ONE_OF_LIST dropdown data-validation rule to a cell range. - Action **Sort Range** Sort a cell range by one column in ascending or descending order. - Action **Update Chart** Replace an existing chart's spec (title, chart type, domain/series ranges) via updateChartSpec. - Action **Update Conditional Format Rules** Replace an existing conditional-format rule (identified by its index on the sheet) with a new boolean rule. - Action **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). - Action **Update Spreadsheet Row** Overwrite the values at a specific range. - Action **Update Spreadsheet Row(s)** Update one or more disjoint ranges in a single batch. - Action **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). - Action **All Payouts** Returns Airbnb payouts. - Action **All Transactions** All Transactions in Hospitable. - Action **Cancel Manual Reservation** Cancel a manual reservation. Only manual reservations can be cancelled through this endpoint. - Action **Cancel Scheduled Message** Cancels a scheduled message so it will not be sent to the guest. The scheduled message record itself is preserved and can be restored with the restore-scheduled-message endpoint. - Action **Create Owner Statement Transaction** Creates an owner-statement expense or reimbursement transaction. - Action **Create Task** Creates a manual operations task on a property. Supports immediate internal teammate assignment via `teammate_uuid`. Marketplace assignment is not supported through this endpoint. - Action **Delete a Knowledge Hub item** Deletes a Knowledge Hub aggregate item from a property. - Action **Delete a Knowledge Hub topic** Deletes a Knowledge Hub topic and all of its aggregate items from a property. - Action **Delete Owner Statement Transaction** Deletes an owner-statement expense or reimbursement transaction. - Action **Delete Task** Deletes a manual operations task. Marketplace-backed tasks cannot be deleted through this endpoint. - Action **Get Agreement** Returns a single rental agreement with rendered **content**, structured **fields** (guest-submitted values), and a **pdf_url** for signed agreements. - Action **Get Agreements** Returns a paginated list of rental agreement **summaries** for the authenticated account, ordered by most recently created first. - Action **Get Alerts** Returns a paginated list of dashboard alerts for the authenticated team. Alerts are issues that need attention β€” for example a disconnected channel, low smart-lock battery, failed payment, or a detect - Action **Get an Enrichable Shortcode by Key** Returns the value that has been provided for the key. - Action **Get Business** Returns a single Owner Statements business by UUID. - Action **Get Businesses** Returns a paginated list of Owner Statements businesses for the active team. - Action **Get Channels** Returns the booking-platform channels connected to the account (Airbnb, VRBO, Booking.com, Agoda, iCal, manual, direct). Use the `user_id` field as the `host` filter on the get-custom-codes endpoint. - Action **Get Custom Codes** Returns the account's user-defined custom codes (`%%key%%`) used in guest messages. Filter by scoping fields to narrow. - Action **Get Inquiries** > πŸ“˜ **Available includes:** - Action **Get Inquiry by UUID** > πŸ“˜ **Available includes:** - Action **Get Opportunities** Returns a paginated list of dashboard opportunities for the authenticated team. Opportunities are suggestions that can improve listing performance β€” for example enabling property protection, optimizin - Action **Get Owner** Returns a single property owner by UUID, including `owner_portal_status` and `bank_account_status`. - Action **Get Owners** Returns a paginated list of property owners for the active team (Owner Statements), including `owner_portal_status` and `bank_account_status`. - Action **Get Owner Statement** Returns a single owner statement or invoice by UUID, including lean money totals by default (for example `total_reservation_income`, `taxes_to_manager`, `taxes_to_owner`, `total_due_to_owner`) plus `p - Action **Get Owner Statements** Returns a paginated list of owner statements and invoices for the active team. - Action **Get Owner Statement Transaction** Returns a single owner-statement expense transaction by UUID. - Action **Get Owner Statement Transactions** Returns a paginated list of owner-statement expense and reimbursement transactions. - Action **Get Properties** > πŸ“˜ **Available includes:** - Action **Get Property Availability Settings** Returns availability and booking rules for a property: advance notice, rolling availability window, maximum and minimum stay, check-in/check-out day restrictions, preparation time, instant book, and r - Action **Get Property by UUID** > πŸ“˜ **Available includes:** - Action **Get Property Calendar** Get Property Calendar in Hospitable. - Action **Get Property Devices** Returns the smart devices connected to a property: smart locks and thermostats. Filter by `device_type` to restrict to a single category. - Action **Get Property Images** Get Property Images in Hospitable. - Action **Get Property Knowledge Hub** Returns the Knowledge Hub for a property, including all sources, topics, and aggregate items. Aggregate items under each topic are the primary representation of knowledge for that property. - Action **Get Property Pricing** Returns pricing settings saved on a property: currency, base and weekend nightly rates, fees, guests included, maximum occupancy, and security deposit configuration. - Action **Get Property Reviews** Returns a paginated list of reviews that guests have left for a specific property. - Action **Get Property Taxes** Returns the tax rules configured for a property: type, calculation method, rate or amount, subjects, and per-channel activation and remittance flags. - Action **Get Reservation** > πŸ“˜ **Available includes**: - Action **Get Reservation Messages** > **Rate Limits**: (per vendor OAuth client, or per Hospitable account if using PATs) - Action **Get Reservations** > πŸ“˜ **Available includes:** - Action **Get Short Codes** Returns the catalog of built-in shortcodes (`%key%`) that can be embedded in guest messages, including the events they apply to. Filter by a specific event to see the subset valid for that lifecycle s - Action **Get Task** Returns a single task by UUID. `start_date` and `end_date` are ISO-8601 datetimes in the property local timezone (identified by the `timezone` field). - Action **Get Tasks** Returns a paginated list of operations tasks for one or more properties, with optional filters for dates, task types, and statuses. - Action **Get Teammate** Returns a single teammate by UUID. - Action **Get Teammates** Returns a paginated list of internal teammates associated with the account. Use this to resolve a teammate UUID for the task create/update endpoints. - Action **Get Upsell Product** Returns a single upsell product by UUID, including the same catalog fields as the list endpoint plus `can_edit_pricing_type` and a resolved `payout_method` when available. - Action **Get User & Billing** Get User & Billing in Hospitable. - Action **List Enrichable Shortcodes** Returns the enrichable shortcodes scoped to the client along with the values that have been provided. - Action **List Guest Reviews** Returns host-of-guest review records on the account, including pending drafts you have not yet submitted, reviews you have already sent to the platform, and reviews that were cancelled. Use `status` t - Action **List Purchased Upsells** Returns a paginated list of purchased upsells for the authenticated account, ordered by most recently paid first (`paid_at` descending, then id). - Action **List Reservation Scheduled Messages** Returns the scheduled messages attached to a single reservation, including ones that have already been sent and ones that have been cancelled. Time fields are returned in the reservation's local timez - Action **List Upsell Products** Returns a paginated list of upsell products in the authenticated account catalog (early check-in, late checkout, custom fees, trip insurance, and similar offers you configure for guests). - Action **Lock Smart Lock** Sends a lock command to the smart lock and returns the refreshed device state once the provider confirms the action. The response shape matches the get-property-devices item shape. - Action **Mark Owner Statement As Paid** Marks a published owner statement as paid. - Action **Mark Owner Statement As Unpaid** Marks a paid owner statement as unpaid (returns it to published). - Action **Publish Owner Statement** Starts an asynchronous publish for the owner statement. - Action **Respond to a Review** Respond to a review received for a reservation. - Action **Restore Scheduled Message** Restores a previously cancelled scheduled message so it will be sent at its existing `scheduled_for` time. - Action **Retrieve a Payout** Retrieve a Payout in Hospitable. - Action **Retrieve a Transaction** Retrieve a Transaction in Hospitable. - Action **Search Properties** This endpoint allows you to search up to **3 years** in the future and for a max period of **90 days**. - Action **Send a Message for an Inquiry** > **Rate Limits**: (per vendor OAuth client, or per Hospitable account if using PATs) - Action **Set an Enrichable Shortcode** Set an Enrichable Shortcode in Hospitable. - Action **Unlock Smart Lock** Sends a unlock command to the smart lock and returns the refreshed device state once the provider confirms the action. The response shape matches the get-property-devices item shape. - Action **Unpublish Owner Statement** Starts an asynchronous unpublish for the owner statement. ## Each app on its own - [ **Google Sheets** Google Sheets is Google's online spreadsheet app for creating, editing and sharing spreadsheets.](https://apiant.ai/connections/google-sheets) - [ **Hospitable** Hospitable is a vacation rental software that empowers you to run your business on autopilot.](https://apiant.ai/connections/hospitable) Reviews ## What our customers say ## More from Google Sheets - [ **Google Sheets to Stripe** Stripe is a payment processing platform for online businesses.](https://apiant.ai/connect/google-sheets-to-stripe) - [ **Google Sheets to QuickBooks Online** QuickBooks Online accounting β€” manage customers, invoices, bills, payments, vendors, expenses, and more via...](https://apiant.ai/connect/google-sheets-to-quickbooks-online) - [ **Google Sheets to Notion** A new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.](https://apiant.ai/connect/google-sheets-to-notion) - [ **Google Sheets to Airtable** Organize anything with Airtable, a modern database created for everyone.](https://apiant.ai/connect/google-sheets-to-airtable) - [ **Google Sheets to Trello** Trello is a visual collaboration tool that organizes projects into boards, lists, and cards.](https://apiant.ai/connect/google-sheets-to-trello) - [ **Google Sheets to Intercom** Intercom is a customer communications platform for support, engagement, and marketing.](https://apiant.ai/connect/google-sheets-to-intercom) ## More into Hospitable - [ **HubSpot to Hospitable** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/hubspot-to-hospitable) - [ **Salesforce to Hospitable** Salesforce is a leading enterprise customer relationship management (CRM) platform.](https://apiant.ai/connect/salesforce-to-hospitable) - [ **Slack to Hospitable** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/slack-to-hospitable) - [ **Gmail to Hospitable** Gmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...](https://apiant.ai/connect/gmail-to-hospitable) - [ **Google Calendar to Hospitable** Google Calendar is a time management tool providing scheduling features, event reminders, and integration...](https://apiant.ai/connect/google-calendar-to-hospitable) - [ **Google Drive to Hospitable** Google Drive is a cloud storage solution for uploading, sharing, and collaborating on files across devices...](https://apiant.ai/connect/google-drive-to-hospitable) Questions ## Google Sheets and Hospitable, answered ### ### What can start an automation from Google Sheets? Any of Google Sheets's 16 triggers in the catalog, including Aggregate Metric Changed, Cell Range Values Changed, Conditional Format Rule Changed and Data Validation Rule Changed. Describe the moment in plain language and your agent picks the right one. ### ### What can your agent do in Hospitable when something happens in Google Sheets? Any of Hospitable's 65 actions, including Create Owner Statement Transaction, Create Task, Send a Message for an Inquiry and All Payouts. Your agent maps the data both ways and tests every scenario before it ships. ### ### Can it also run from Hospitable to Google Sheets? Hospitable has no triggers in the catalog today, so automations start in Google Sheets. If you need the other direction, ask: your agent reads Hospitable's API documentation and adds it. ### ### Do I have to build a connector for Google Sheets or Hospitable? 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 Google Sheets and Hospitable 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.