--- title: "Connect Google Sheets and Mindbody - APIANT.ai" description: "When \"New Rows\" fires in Google Sheets, your agent runs \"Add client\" in Mindbody, or \"Cancelled class booking\" in Mindbody to \"Add Row\" in Google Sheets." canonical: "https://apiant.ai/connect/google-sheets-to-mindbody" --- # Connect Google Sheets and Mindbody When **New Rows** fires in [Google Sheets](https://apiant.ai/connections/google-sheets), your agent runs **Add client** in [Mindbody](https://apiant.ai/connections/mindbody), or **Cancelled class booking** in Mindbody to **Add Row** in Google Sheets. Describe the whole flow and it is built, tested on every scenario and kept running. Google Sheets **16** triggers Google Sheets **46** actions Mindbody **57** triggers Mindbody **123** actions What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it. [ Mindbody Partner Award winner: Most Valuable Partner (opens the announcement in a new tab)](https://www.mindbodyonline.com/company/press/mindbody-announces-third-annual-bold-partner-award-winners) ## What do you want Google Sheets and Mindbody 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) Running MINDBODY and Google Sheets together means the studio data your team reads in a spreadsheet matches what is in the booking system. New sales, bookings and clients in MINDBODY can be written into Google Sheets rows, and edits made in a sheet can create or update clients, prices and records back in MINDBODY. ## Google Sheets and Mindbody customer stories - [ Video, 1:10 **Yoga studio: Mindbody sales into a register** A yoga studio wanted every Mindbody sale in its membership register, sorted by its own rules. It went live on day three and sorted 21 paid sales by the afternoon of day four.](https://apiant.ai/stories/yoga-studio-membership-register) Example flows ## What Google Sheets and Mindbody can do together ### From Google Sheets to Mindbody - When **New Rows** in Google Sheets then **Add client** in Mindbody - When **Spreadsheet Row Changed** in Google Sheets then **Get client** in Mindbody ### From Mindbody to Google Sheets - When **Cancelled class booking** in Mindbody then **Add Row** in Google Sheets - When **New class booking** in Mindbody then **Create Spreadsheet Row at Top** in Google Sheets 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 Mindbody ## Triggers and actions 73 triggers · 169 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). - Trigger **Cancelled appointment booking** Triggered when an appointment booking is cancelled - Trigger **Cancelled class booking** Fires when a client's class booking is cancelled. - Trigger **Cancelled class schedule** Triggered when a class schedule is cancelled. When this occurs, all of the classes associated with the schedule are removed. - Trigger **Cancelled client contract** Triggered when a client's contract is cancelled - Trigger **Cancelled membership** Triggered when a membership is cancelled - Trigger **Class updated** Triggered when a single class is updated. - Trigger **Completed appointment** Triggered when an appointment is completed. - Trigger **Deactivated client** Triggered when a client is deactivated - Trigger **Deactivated location** Triggered when a location is deactivated - Trigger **Every appointment in date range** This is not a standard trigger! Always emits every appointment in the configured date range. - Trigger **Every class in date range** This is not a standard trigger! Always emits classes in the configured date range. - Trigger **Every uncanceled class in date range** This is not a standard trigger! Always emits uncanceled classes in the configured date range. - Trigger **Merged clients** Triggered when clients are merged - Trigger **New appointment booking** Triggered when an appointment booking is created - Trigger **New class booking** Triggered when a new booking is made for a class - Trigger **New class (integration setting)** Triggered when a class is created in the amount of time specified by an integration setting stored in a lookup table. The default is 24 hours. - Trigger **New class schedule** Triggered when a new class offering is scheduled - Trigger **New client** Triggered when a new client is added - Trigger **New client contract** Triggered when a new contract is sold to a client - Trigger **New completed class** Triggered when a class completes - Trigger **New completed class (integration setting)** Triggered when a class completes within a number of hours specified by an integration setting. - Trigger **New location** Triggered when a location is created - Trigger **New membership** Triggered when a new membership is created - Trigger **New or updated appointment -7d +30d for any connection** Triggered for new or updated appointments in the last 7 days or 30 days in the future, for any connected account. - Trigger **New or updated appointment in date range** Triggered for new or updated appointments in the specified date range. - Trigger **New or updated class** Triggered for new or updated classes in the configured date range. - Trigger **New or updated class (integration setting)** Triggered when a class is created or updated in the amount of time specified by an integration setting stored in a lookup table. The default is 24 hours. Updates are only triggered when the class name, staff id, resource id, or cancelled status are modified. - Trigger **New or updated client** Triggered when a client is added or updated - Trigger **New or updated client (integration setting)** Triggered when a client is added or modified. Will include inactive clients if specified by an integration setting. By default inactive clients are not included. NOTE: this trigger will only work when less than 200 clients are added/updated per day. - Trigger **New or updated gift card** Triggered when a gift card is created or updated - Trigger **New or updated package** Triggered when a package is created or updated - Trigger **New or updated product** Triggered when a product is created or updated - Trigger **New or updated product (integration setting)** Triggered when a product is created or updated. An integration setting is used to control the fetching of products only sold online. - Trigger **New or updated products inventory** Triggered when inventory changes for a product, or when products are added. - Trigger **New or updated service** Triggered when a service is created or updated - Trigger **New or updated session type** Triggered when session types are created or updated - Trigger **New or updated staff member** Triggered when staff member is created or updated - Trigger **New sale** Triggered when a new sale is made to a client. - Trigger **New sale for any connected account** Triggered when a new sale is made to a client for any connected MINDBODY account. - Trigger **New sale itemized payment** Triggered when a new sale is made to a client. Payments emitted as separate rows. NOTE: line items are not emitted, use the separate trigger to obtain them. - Trigger **New sale line item** Triggered when a new sale is made to a client. Line items are emitted as separate rows. NOTE: payments are not emitted, use the separate trigger to obtain them. - Trigger **New sales since days** Triggers for new sales that occur within the configured number of days - Trigger **Two-way sync new or updated clients** A polling trigger for two-way syncing new and updated clients, with enhanced on-the-fly mapping. Can only be used with enhanced two-way sync actions that support on-the-fly mapping. - Trigger **Two-way sync new or updated clients (instant)** A trigger for two-way syncing new and updated clients, with enhanced on-the-fly mapping. Can only be used with enhanced two-way sync actions that support on-the-fly mapping. - Trigger **Upcoming appointment in database** Triggered when an appointment in the database is scheduled to start within the account's "Email_notification_timing_hrs" setting. - Trigger **Upcoming appointment in database via setting** Triggered when an appointment in the database is scheduled to start within the specified "notification timing hours" setting. - Trigger **Upcoming class** Triggered when an uncanceled class is upcoming in the specified amount of time. - Trigger **Upcoming class in database** Triggered when a class in the database is scheduled to start within the account's "Email_notification_timing_hrs" setting. - Trigger **Upcoming class in database via entered time** Triggered when a class in the database is scheduled to start within the entered amount of time. - Trigger **Upcoming class (Zoom meeting creation)** Triggered when an uncanceled class is upcoming in the amount of time specified by a setting stored in a lookup table. The default is 24 hours. - Trigger **Updated appointment booking** Triggered when an appointment booking is updated - Trigger **Updated class booking** Triggered when a booking for a class is updated - Trigger **Updated class booking with service ID** Triggered when a booking for a class is updated - Trigger **Updated class schedule** Triggered when a scheduled class offering is modified. Note that if the class schedule’s endDate changes, classes are added or removed from the schedule accordingly. - Trigger **Updated client** Triggered when a client is updated - Trigger **Updated client contract** Triggered when a client's contract is updated - Trigger **Updated location** Triggered when a location is updated - Action **Add account credit to client** Adds credit to a client's account balance, recorded as a sale at the chosen location. - Action **Add appointment** Adds a new appointment - Action **Add client** Adds a client. An error will occur if the client already exists. - Action **Add client relationship** Adds a client relationship. Existing relationships are not removed. NOTE: custom relationships are not currently supported due to limitations with the MINDBODY API. - Action **Add client to enrollment** Enrolls a client in a class schedule and returns the enrollment details including start and end dates. - Action **Add client with on-the-fly custom field id lookup** Adds a client. Makes an additional API call to fetch client custom fields in order to determine custom field ids via matching names of custom fields. An error will occur if the client already exists or if a custom field does not exist. - Action **Add completed sale to client** Adds a completed sale to a client using a custom payment method. - Action **Add contact log** Creates a new contact log. - Action **Add or update client** Adds or updates a client based on the selected matching logic. - Action **Add or update client index** Adds or updates a client index. Existing indexes on the client are not removed. - Action **Add site client index** Adds a site client index. An error will occur if the index name already exists. - Action **Add staff** Adds a staff member - Action **Book client into a class** Books the specified client into the specified class. - Action **Calculate total spend for client** Returns the total amount of money received for the specified client, going back for the specified number of days. - Action **Cancel a class** Cancels a single scheduled class at the studio. The MINDBODY login used for the connection needs the Manage Class Schedules and Cancel Reservations permissions. - Action **Cancel Appointment** Cancels a MINDBODY appointment as a standard cancellation, never a late cancel, so no late-cancel fee is charged. It can optionally email the client. Runs as a dry run unless Test is set to false. - Action **Client purchases: fetch** Fetches client purchases that meet the search criteria from the MBO API. The API response is stored in the database. This action emits a transaction uuid and an array of records IDs. Use a loop and the "client purchases: get record" action to process all the fetched records. - Action **Client purchases: get record** Emits the client purchase record from the database that was previously fetched using the "Client purchases: fetch" action, which must be executed before this action is used in a loop to process all records. - Action **Deactivate Client** Marks a Mindbody client as inactive. The client record is kept and can be made active again with Reactivate Client. - Action **Find clients by email** Returns up to 100 clients that have the specified email address. - Action **Find clients by phone** Returns up to 100 clients that have the specified phone number. Can either be Mobile phone, Home phone or Work phone. - Action **Find contact log type by name** Returns the ID of the specified contact log type. An error occurs if zero or multiple are found. - Action **Find sales** Searches Mindbody sales and returns the matching sale records. Filter by sale date range, sale id, client id or payment method, and page through results with Limit and Offset. Use "Get sale" to retrieve a single sale by its id. - Action **Get accrual sales within date range** Emits accrual sales data over a given date range. - Action **Get activation code** Generates an activation code and link to access a Mindbody Site API. - Action **Get Active Memberships for Clients** Look up the current memberships for up to 200 Mindbody clients at once, returning each client's ID and the names of their active memberships. - Action **Get Active Session Times** Get the bookable appointment start times for one or more session types in a date range. - Action **Get all client contract IDs** Returns all contract IDs for the specified client. Use a Loop and the "get client contract by ID" action to fetch details for each contract. - Action **Get all products** Returns all products - Action **Get all products inventory** Returns inventory information for all products at all locations. - Action **Get all sellable online products** Returns all products only sold online. - Action **Get all services** Retrieves all services. - Action **Get all session types** Returns all session types - Action **Get all staff members** Returns all staff members - Action **Get appointment** Returns details for the specified appointment. If the appointment is not found an error occurs. - Action **Get bookable availabilities** Probe build: lists MBO session types to discover a valid appointment SessionTypeId before finalizing the bookable-availabilities query. - Action **Get cash sales within date range** Emits sales data over a given date range. Will return all sales, including products, account credits, gift cards, and autopays. Autopays will be notated in the response, and the product description will specify gift card and account credit purchases. - Action **Get class** Returns details for the specified class. If the class is not found no error will occur, so a conditional must be used for error checking. - Action **Get class description** Returns the class description for the specified ClassDescriptionId. Includes name, category, subcategory, program, and session type details. If not found, no error occurs — output is empty. - Action **Get classes** Returns scheduled classes for the site within an optional date range. - Action **Get class recently updated** Returns classes last modified on or after system time minus the entered amount of hours. No error will occur if no class is found. - Action **Get class schedules** Returns available class schedule templates, optionally filtered by date, location, staff, or program. - Action **Get class visits** Fetches the ids of all clients booked for the specified class. The output is suitable to use within a loop. - Action **Get client** Returns details for the specified client. If the client is not found an error will occur. - Action **Get client account balance** Returns account balance details for the specified client. If the client is not found no error will occur, so a conditional must be used for error checking. - Action **Get client appointments in date range** Returns details for all of the specified client's appointments in the specified date range. - Action **Get client complete info** Returns complete client information along with list of purchased services, contract details, membership details and arrival programs for a specific client. If the client is not found an error will occur. - Action **Get client contact logs in date range** Returns details for all of the specified client's contact logs in the specified date range. - Action **Get client contract** Returns details for the specified client contract. If the client contract is not found an error will occur. - Action **Get Client Membership** Returns details for one of a client's active memberships, selected by Membership ID. If no active membership matches that ID, the output fields come back empty. - Action **Get client purchased service by ID** Returns details for the specified service purchased by a specified client. No error occurs if none is found. - Action **Get client purchased services** Returns details for services purchased by a specified client. No error occurs if the client is not found. - Action **Get clients** Returns clients for the site, optionally filtered by a search term. - Action **Get client services totals by product ID** Returns details for services purchased by a specified client for a specified product ID. If more than 1 matching client service is found, 'Count' and 'Remaining' are totaled and the furthest expiration date is used. No error occurs if none are found, the output is empty instead. - Action **Get client visits** Returns details for client visits in the specified date range. - Action **Get contact log types** Returns all defined contact log types. NOTE: currently returns no more than 200, which should be more than enough for most sites. - Action **Get contract** Returns details for the specified contract. If the contract is not found an error will occur. - Action **Get custom payment method by name** Returns the ID of the custom payment method having the specified name. An error occurs if zero or multiple are found. - Action **Get enrollments** Returns enrollments for clients within a specified date range. - Action **Get gift card balance** Returns the remaining balance for the specified gift card. NOTE: no error occurs if the barcode ID is invalid. - Action **Get gift cards** Returns up to 200 gift cards. - Action **Get locations** Returns details for up to 200 locations. NOTE: currently only supports up to 200 locations, does not currently do pagination. - Action **Get membership** Returns details for the specified membership. If the membership is not found an error will occur. - Action **Get most recent client contract** Returns details for the most recent contract for the specified client. An error occurs no contract is not found. - Action **Get packages** Returns packages available for sale, optionally filtered to those sellable online. - Action **Get product** Returns details for the specified product. If the product is not found an error will occur. - Action **Get product filtered by sellable online** Returns details for the specified product, filtered by it being sellable online or not. If the product is not found an error will occur. - Action **Get product inventory** Returns inventory information for the specified product at all locations. - Action **Get program** Returns details for the specified program. If the program is not found an error will occur. - Action **Get required client fields** Returns the site's required client fields (e.g. Birthday, Gender). - Action **Get sale** Returns details for the specified sale. If the sale is not found an error will occur. - Action **Get sales in date range** Lists MINDBODY sales in a date range. Filters by StartSaleDateTime/EndSaleDateTime, optional PaymentMethodId, Limit/Offset pagination. Returns Sales[], SaleIds (Id), ClientIds (ClientId), TotalResults. - Action **Get scheduled client visits** Returns details for all of the specified client's scheduled visits, optionally in a specified date range. - Action **Get service** Returns details for the specified service. If the service is not found an error will occur. - Action **Get session type** Returns details for the specified session type. If the session type is not found an error will occur. - Action **Get site** Returns details for the site associated with the configured connection - Action **Get site for specified account** Returns details for the site connected to the specified account name. - Action **Get staff member** Returns details for the specified staff member. If the staff member is not found an error will occur. - Action **Get visits within date range** Emits all visits that occur in the specified date range, optionally filtered by a session type id and/or a location id. - Action **Get visits within date range for multiple session types** Emits all visits that occur in the specified date range, filtered by multiple session type ids and optionally a location id. - Action **List all clients** Returns every client on your MINDBODY site, across all pages, optionally including inactive clients. - Action **List Client Indexes** Lists the site's client indexes with their IDs, names and active values. - Action **List Client Memberships** Returns details for all of the specified client's memberships. - Action **List Custom Payment Methods** Returns every custom payment method set up for the Mindbody site, with each method's id and name. - Action **List Resources** List the rooms and resources available for given session types and a location in a date range. - Action **List Staff Appointments** Lists a staff member's appointments between a start and end date, with each appointment's time, status, session type and client. - Action **List Staff Unavailabilities** Lists the time blocks when staff members are unavailable for appointments within a date range, optionally filtered to specific staff. - Action **Lookup client payment** Returns payment information for the specified client and specified payment reference. - Action **Purchase contract** Purchases a contract - Action **Purchase gift card** Purchases a gift card - Action **Reactivate Client** Reactivates a deactivated Mindbody client by ID so they can book and buy again. - Action **Remove client from a class** Removes the specified client from the specified class. - Action **Return sale** Return a comped sale for a specified sale ID in business mode. The sale is returnable only if it is a sale of a service, product or gift card and it has not been used. Currently, only the comp payment method is supported. - Action **Select upcoming class** A utility action that lets an upcoming class in the specified timeframe to be selected from a dropdown. The selected class' id is emitted as output. - Action **Send password reset email** Sends a password reset email to the specified user. - Action **Shopping cart - add item: package** Adds a package to the shopping cart. - Action **Shopping cart - add item: product** Adds a product to the shopping cart. - Action **Shopping cart - add item: service** Adds a service to the shopping cart. - Action **Shopping cart - add item: tip** Adds a tip to the shopping cart. - Action **Shopping cart - add payment: cash** Adds a cash payment to the shopping cart. - Action **Shopping cart - add payment: check** Adds a check payment to the shopping cart. - Action **Shopping cart - add payment: comp** Adds a complimentary amount to the shopping cart. - Action **Shopping cart - add payment: custom** Adds a payment to the shopping cart using the specified custom payment method. - Action **Shopping cart - add payment: gift card** Adds a gift card payment to the shopping cart. - Action **Shopping cart - add payment: stored credit card** Adds a stored credit card payment to the shopping cart. - Action **Shopping cart - checkout** Submits the shopping cart for checkout. - Action **Shopping cart - create** Initializes a new shopping cart. Emits a cart ID that must be passed into other shopping cart actions to add items to the cart and checkout. - Action **Shopping cart - delete** Deletes the specified cart from the database. - Action **Shopping cart - get totals** Calculates the total amount of the cart. - Action **Terminate Client Contract** Ends a client's contract in MINDBODY on a set termination date, with an optional termination code and comments. - Action **Two-way sync add or update a client** An action for two-way syncing new and updated clients, with enhanced on-the-fly mapping using client email addresses for matching. Can only be used with enhanced two-way sync triggers that support on-the-fly mapping. - Action **Update appointment** Updates an existing appointment - Action **Update client** Updates a client by ID. - Action **Update client id** Updates an existing client's id. An error occurs if the id cannot be changed, for example if it already exists. - Action **Update Client Service Dates** Changes the expiration date, and optionally the active date, of a pricing option (pass, membership or class pack) on a client's account. - Action **Update client visit** Updates a client visit. - Action **Update client with on-the-fly custom field id lookup** Updates a client by ID. Makes an additional API call to fetch client custom fields in order to determine custom field ids via matching names of custom fields. An error will occur if a custom field does not exist. - Action **Update product price** Updates the price of the specified product. - Action **Update sale date** Updates the date of the specified sale. - Action **Update service price** Updates the price of the specified service. - Action **Update staff** Updates an existing staff member - Action **Upload client document** Uploads a client document from the provided URL. NOTE: the file must be no larger than 4MB - Action **Upload client profile photo** Uploads a client's profile photo from the provided URL. NOTE: the image file must be no larger than 4MB ## Each app on its own - [ **Google Sheets** Google Sheets](https://apiant.ai/connections/google-sheets) - [ **Mindbody** MINDBODY is a powerful business management software that combines your scheduling, task automation...](https://apiant.ai/connections/mindbody) 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 Mindbody - [ **HubSpot to Mindbody** HubSpot is your all-in-one stop for all of your marketing software needs.](https://apiant.ai/connect/hubspot-to-mindbody) - [ **Slack to Mindbody** Slack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...](https://apiant.ai/connect/slack-to-mindbody) - [ **Mailchimp to Mindbody** Mailchimp marketing automation and email platform.](https://apiant.ai/connect/mailchimp-to-mindbody) - [ **Stripe to Mindbody** Stripe is a payment processing platform for online businesses.](https://apiant.ai/connect/stripe-to-mindbody) - [ **Shopify to Mindbody** Shopify is a commerce platform for online stores and retail point-of-sale.](https://apiant.ai/connect/shopify-to-mindbody) - [ **JIRA to Mindbody** Atlassian JIRA Cloud — issue tracking and project management.](https://apiant.ai/connect/jira-to-mindbody) Questions ## Google Sheets and Mindbody, answered ### ### Can a row I type in Google Sheets create a real client record in MINDBODY? Yes. A new row in your sheet can trigger the Add client action in MINDBODY, and a changed row can drive updates such as a product price. The agent tests every scenario before it runs on live data. ### ### How do we avoid duplicate rows when the same client books again? Use a lookup on the sheet first, then the Upsert Row action, which updates the matching row when it exists and appends a new one when it does not. Matching is done on a column you choose, such as client email or client ID. ### ### What can start an automation from Google Sheets? Any of Google Sheets's 16 triggers in the catalog, including New Rows, Spreadsheet Row Changed, Aggregate Metric Changed and Cell Range Values Changed. Describe the moment in plain language and your agent picks the right one. ### ### What can your agent do in Mindbody when something happens in Google Sheets? Any of Mindbody's 123 actions, including Add client, Get client, Update product price and Add completed sale to client. Your agent maps the data both ways and tests every scenario before it ships. ### ### Can it also run from Mindbody to Google Sheets? Yes. When something happens in Mindbody, your agent can act in Google Sheets too. This page covers both directions: Mindbody's triggers and Google Sheets's actions are listed here as well. ### ### Do I have to build a connector for Google Sheets or Mindbody? 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 Mindbody 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.