configure_cosmos_connection
ChatGPTConfigure Azure Cosmos DB connection for the current user
configure_mssql_connection
ChatGPTConfigure MSSQL connection for the current user
correlate_email_revenue_vs_ecommerce
ChatGPTCross-source: Klaviyo email revenue vs Shopify/GA4 ecommerce revenue by date.
correlate_email_vs_social_ads
ChatGPTCross-source: Klaviyo email metrics vs Facebook ad spend by date.
correlate_email_vs_web_traffic
ChatGPTCross-source: Klaviyo email sends vs GA4 web sessions by date. Shows whether email days drive traffic spikes.
correlate_flow_revenue_vs_campaign_sends
ChatGPTKlaviyo-internal: flow revenue vs campaign send volume by date.
correlate_form_signups_vs_ad_traffic
ChatGPTCross-source: Klaviyo form submits vs GA4 traffic and Facebook ad spend by date.
correlate_list_growth_vs_youtube
ChatGPTCross-source: Klaviyo list growth vs YouTube views by date. Shows if YouTube drives signups.
cosmos_count_distinct
ChatGPTCount unique values of one field grouped by another in Cosmos DB. Use instead of COUNT(DISTINCT) which Cosmos does not support. Example: count unique sessions per day with count_field='c.sessionId', group_field='c.eventDate'.
describe_mssql_table
ChatGPTGet the schema/columns of a MSSQL table
describe_table
ChatGPTGet schema/columns for a database table from PostgreSQL or MSSQL.
disconnect_cosmos_connection
ChatGPTRemove Cosmos DB connection settings for the current user
disconnect_mssql_connection
ChatGPTRemove MSSQL connection settings for the current user
get_channel_attribution_summary
ChatGPTUnified revenue attribution across Klaviyo email, SMS, Shopify, GA4, and Facebook by date.
get_connector_status
ChatGPTReturn a pre-formatted Markdown dashboard showing every configured connector's status. IMPORTANT: The output is a complete, ready-to-display Markdown table — show it to the user exactly as returned, do NOT summarize or paraphrase. Each row includes connector name, provider, connection status (with emoji indicators), and a clickable link to authenticate if needed. After displaying the table, offer to help the user connect any unauthorized services and mention they can say 'refresh status' after authenticating.
get_cosmos_connection_status
ChatGPTGet Azure Cosmos DB connection status for the current user
get_cosmos_container_insights
ChatGPTReturn metadata and sample-based insights for the configured Cosmos DB container
get_drive_stats
ChatGPTGet statistics about the user's Google Drive including storage usage. Useful before iterating through a large drive.
get_ebay_customer_service_metric
ChatGPTGet eBay customer service metrics (INAD/INR rates and defect details).
get_ebay_funds_summary
ChatGPTGet the seller's current eBay funds summary: settled amount, funds on hold, and total balance. Requires sell.finances scope.
get_ebay_orders
ChatGPTList eBay orders with GMV, item counts, and fulfillment status. Returns summary (total GMV, status breakdown) plus full order details. Requires sell.fulfillment.readonly scope.
get_ebay_seller_performance_overview
ChatGPTGet a consolidated eBay seller performance overview across standards, customer service metrics, and traffic.
get_ebay_seller_privileges
ChatGPTGet eBay seller privileges and selling entitlements for the authenticated account.
get_ebay_seller_standards_profile
ChatGPTGet eBay seller standards profile for the selected standards program.
get_ebay_traffic_report
ChatGPTGet eBay listing traffic report metrics like impressions, views, and conversion rates.
get_ebay_transactions
ChatGPTList eBay financial transactions (sales, credits, refunds, fees, disputes). Returns totals by type plus full transaction details. Requires sell.finances scope.
get_facebook_account_insights
ChatGPTGet account-level Facebook Ads performance summary: impressions, clicks, spend, reach, frequency, CPM, CPC, CTR, conversions, and cost per action.
get_facebook_ad_account
ChatGPTGet detailed information about the connected Facebook ad account: name, status, currency, timezone, total spend, balance, and spend cap.
get_facebook_ad_set
ChatGPTGet full details for a single Facebook ad set: targeting rules, optimization goal, bid strategy, and promoted object.
get_facebook_age_gender_insights
ChatGPTGet Facebook Ads performance breakdown by age range and gender.
get_facebook_campaign
ChatGPTGet full details for a single Facebook campaign: objective, bid strategy, budget, schedule, and special ad categories.
get_facebook_campaign_insights
ChatGPTGet performance metrics for a specific Facebook campaign: impressions, clicks, spend, reach, CPM, CPC, CTR, and conversion actions.
get_facebook_campaign_insights_daily
ChatGPTGet daily performance breakdown for a Facebook campaign: day-by-day impressions, clicks, spend, reach, CPM, CPC, and CTR.
get_facebook_device_platform_insights
ChatGPTGet Facebook Ads performance breakdown by device and publisher platform.
get_facebook_geographic_insights
ChatGPTGet Facebook Ads performance breakdown by country.
get_facebook_placement_insights
ChatGPTGet Facebook Ads performance breakdown by ad placement and publisher platform.
get_file_content
ChatGPTGet the content of a Google Drive file
get_ga4_realtime
ChatGPTGet real-time Google Analytics 4 data showing current active users
get_gmail_message
ChatGPTGet a specific Gmail message by ID with full content
get_google_ads_account_summary
ChatGPTGet high-level Google Ads account performance summary with aggregate metrics.
get_google_ads_age_gender_performance
ChatGPTGet performance breakdown by age range and gender demographics.
get_google_ads_campaign_performance
ChatGPTGet daily performance breakdown for a specific Google Ads campaign.
get_google_ads_device_performance
ChatGPTGet performance breakdown by device type (desktop, mobile, tablet).
get_google_ads_geographic_performance
ChatGPTGet performance breakdown by geographic location.
get_google_ads_keyword_performance
ChatGPTGet keyword performance with quality scores, match types, and search impression share.
get_google_ads_search_terms
ChatGPTGet search term report showing actual queries that triggered your ads.
get_hubspot_account_info
ChatGPTGet HubSpot account and portal metadata for the authenticated user.
get_hubspot_company
ChatGPTGet full details for a HubSpot company by ID.
get_hubspot_contact
ChatGPTGet full details for a HubSpot contact by ID.
get_hubspot_deal
ChatGPTGet full details for a HubSpot deal by ID.
get_klaviyo_abandoned_cart_flows
ChatGPTGet abandoned cart flow performance: revenue recovered, conversion rate. Inputs: start_date, end_date.
get_klaviyo_campaign_metrics
ChatGPTGet detailed performance metrics for a specific Klaviyo campaign. Input: campaign_id (required).
get_klaviyo_campaign_revenue
ChatGPTGet attributed revenue by campaign. Inputs: start_date, end_date, group_by.
get_klaviyo_campaigns
ChatGPTList Klaviyo campaigns with performance metrics. Inputs: start_date, end_date, channel (email|sms|all), status, limit.
get_klaviyo_conversion_metrics
ChatGPTGet conversion metrics: conversions, revenue, conversion rate. Inputs: start_date, end_date.
get_klaviyo_email_metrics_summary
ChatGPTGet aggregated email campaign metrics: sends, opens, clicks, revenue. Inputs: start_date, end_date, interval.
get_klaviyo_events
ChatGPTGet Klaviyo events filtered by metric and date. Inputs: metric_id, start_date, end_date, limit.
get_klaviyo_flow_performance
ChatGPTGet performance metrics for a specific Klaviyo flow. Input: flow_id (required).
get_klaviyo_flow_series
ChatGPTGet time-series performance data for a Klaviyo flow. Inputs: flow_id (required), start_date, end_date, interval.
get_klaviyo_flows
ChatGPTList Klaviyo automation flows. Inputs: start_date, end_date, status, limit.
get_klaviyo_form_series
ChatGPTGet time-series performance data for a specific form. Input: form_id (required).
get_klaviyo_forms
ChatGPTList all Klaviyo signup forms. Inputs: start_date, end_date.
get_klaviyo_list_growth
ChatGPTGet subscriber growth and current size for a specific list. Input: list_id (required).
get_klaviyo_lists
ChatGPTList all Klaviyo email/SMS lists.
get_klaviyo_metrics
ChatGPTList all Klaviyo metrics (event types) available for querying.
get_klaviyo_predictive_analytics
ChatGPTGet predictive analytics: predicted CLV, churn risk, purchase probability distribution.
get_klaviyo_profile_count
ChatGPTGet total number of profiles in Klaviyo.
get_klaviyo_profile_growth
ChatGPTGet profile/subscriber growth over time. Inputs: start_date, end_date, interval.
get_klaviyo_recent_events
ChatGPTGet the most recent Klaviyo events (last 7 days). Inputs: metric_id, limit.
get_klaviyo_segment_performance
ChatGPTGet performance metrics for a specific segment. Input: segment_id (required).
get_klaviyo_segments
ChatGPTList all Klaviyo segments.
get_klaviyo_sms_metrics_summary
ChatGPTGet aggregated SMS campaign metrics: recipients, deliveries, clicks, revenue. Inputs: start_date, end_date.
get_klaviyo_subscription_health
ChatGPTGet subscription health metrics: active, unsubscribed, bounced, suppressed counts.
get_klaviyo_top_campaigns
ChatGPTGet top-performing Klaviyo campaigns ranked by a metric. Inputs: metric (revenue|opens|clicks|conversions), limit.
get_klaviyo_top_performing_forms
ChatGPTGet top-performing signup forms ranked by submission rate. Input: period (days), limit.
get_mssql_connection_status
ChatGPTGet MSSQL connection status for the current user
get_my_calendar_event
ChatGPTGet details of a specific Google Calendar event by ID
get_my_dropbox_account
ChatGPTGet information about the connected Dropbox account.
get_my_dropbox_recent
ChatGPTGet recently modified files from Dropbox.
get_my_dropbox_storage
ChatGPTGet Dropbox storage information including quota, used space, and remaining space. Use when user asks about 'my Dropbox size', 'Dropbox storage', 'Dropbox space'.
get_my_onedrive_recent
ChatGPTGet recently accessed files from OneDrive. Requires Microsoft authentication via /oauth/microsoft/authorize.
get_my_onedrive_shared
ChatGPTGet files shared with the user in OneDrive. Requires Microsoft authentication via /oauth/microsoft/authorize.
get_my_onedrive_storage
ChatGPTGet OneDrive storage information including quota, used space, and remaining space. Use when user asks about 'my OneDrive size', 'OneDrive storage', or 'Microsoft storage'. Requires Microsoft authentication via /oauth/microsoft/authorize.
get_my_outlook_event
ChatGPTGet details of a specific Microsoft/Outlook calendar event by ID. Requires Microsoft authentication via /oauth/microsoft/authorize.
get_my_outlook_folders
ChatGPTList Outlook email folders with message counts. Requires Microsoft authentication via /oauth/microsoft/authorize.
get_my_outlook_mailbox
ChatGPTGet Outlook mailbox information including folder counts, total messages, and unread count. Use when user asks about 'my Outlook', 'my Microsoft email', 'my mailbox'. Requires Microsoft authentication via /oauth/microsoft/authorize.
get_my_youtube_analytics
ChatGPTGet analytics for the authenticated user's YouTube channel. Supports Brand Accounts via channel_id.
get_my_youtube_channel
ChatGPTGet the authenticated user's own YouTube channel information. Supports Brand Accounts via channel_id.
get_my_youtube_geography
ChatGPTGet geographic breakdown of viewers for the authenticated user's YouTube channel or a specific video. Supports Brand Accounts via channel_id.
get_my_youtube_video_analytics
ChatGPTGet detailed analytics for a specific video owned by the authenticated user. Supports Brand Accounts via channel_id.
get_my_youtube_videos
ChatGPTList the authenticated user's own uploaded YouTube videos. Supports Brand Accounts via channel_id.
get_quickbooks_ap_aging
ChatGPTGet Accounts Payable Aging report by age bucket.
get_quickbooks_ar_aging
ChatGPTGet Accounts Receivable Aging report by age bucket.
get_quickbooks_balance_sheet
ChatGPTGet Balance Sheet report: assets, liabilities, equity.
get_quickbooks_company_info
ChatGPTGet QuickBooks company profile: name, address, fiscal year, industry.
get_quickbooks_customer
ChatGPTGet full details for a single QuickBooks customer.
get_quickbooks_invoice
ChatGPTGet full details for a single QuickBooks invoice.
get_quickbooks_overdue_invoices
ChatGPTGet overdue invoices with open balance, sorted by days overdue.
get_quickbooks_payment
ChatGPTGet full details for a single QuickBooks payment.
get_quickbooks_profit_loss
ChatGPTGet Profit and Loss (Income Statement) report.
get_shopify_customer
ChatGPTGet detailed information for a single Shopify customer.
get_shopify_inventory
ChatGPTGet stock levels for all products, highlighting low-stock items.
get_shopify_order
ChatGPTGet detailed information for a single Shopify order.
get_shopify_order_summary
ChatGPTGet summary of recent orders: revenue, order count, AOV, top products.
get_shopify_popular_products
ChatGPTIdentify most popular products based on order frequency.
get_shopify_product
ChatGPTGet detailed information for a single Shopify product.
get_shopify_repeat_customers
ChatGPTIdentify repeat customers with multiple orders, sorted by lifetime spend.
get_shopify_risky_orders
ChatGPTIdentify potentially risky or fraudulent orders using Shopify fraud analysis.
get_shopify_shop_info
ChatGPTGet basic information about the connected Shopify store.
get_slack_thread
ChatGPTGet a Slack thread by channel ID and thread timestamp.
get_slack_workspace_analytics
ChatGPTGet aggregate Slack workspace analytics (channels, members, top channels).
get_slack_workspace_info
ChatGPTGet metadata about the connected Slack workspace (team, domain, URL).
get_tiktok_account_analytics
ChatGPTGet TikTok account-level analytics: total videos posted, total likes received, follower count, and following count.
get_tiktok_profile
ChatGPTGet the authenticated user's TikTok profile: username, display name, bio, verified status, avatar, and account statistics (follower count, following count, total likes, video count).
get_tiktok_video_analytics
ChatGPTGet aggregated analytics across all the user's TikTok videos: total views, likes, comments, shares, averages per video, and top 10 videos.
get_tiktok_video_details
ChatGPTGet detailed information for specific TikTok videos by their IDs, including engagement metrics and embed links.
get_youtube_channel
ChatGPTLook up a YouTube channel by ID, @handle, or legacy username.
get_youtube_channel_videos
ChatGPTGet recent videos from a YouTube channel.
get_youtube_transcript
ChatGPTGet the transcript (captions) for a YouTube video. Returns timestamped segments and full text.
get_youtube_video
ChatGPTGet detailed information about one or more YouTube videos including title, description, view/like/comment counts, duration, tags, and thumbnails.
list_cosmos_containers
ChatGPTList available Cosmos DB containers in the configured database
list_database_tables
ChatGPTList tables in the configured database backend (PostgreSQL or MSSQL).
list_drive_files
ChatGPTList files from Google Drive with pagination. Use page_token to iterate through large drives.
list_facebook_ad_accounts
ChatGPTList all Facebook/Meta ad accounts accessible to the authenticated user. Returns account IDs, names, status, currency, and timezone.
list_facebook_ad_sets
ChatGPTList Facebook ad sets with budget, targeting summary, and optimization goal. Optionally filter by campaign.
list_facebook_ads
ChatGPTList individual Facebook ads with creative details (title, body, image, call-to-action). Optionally filter by campaign or ad set.
list_facebook_campaigns
ChatGPTList Facebook/Meta ad campaigns with status, objective, budget, and dates.
list_ga4_accounts
ChatGPTList all Google Analytics 4 accounts the user has access to
list_ga4_properties
ChatGPTList GA4 properties (websites/apps). If account_id not provided, lists all properties from all accounts.
list_gmail_messages
ChatGPTList recent Gmail messages with optional query filter
list_google_ads_accounts
ChatGPTList all Google Ads accounts accessible to the authenticated user.
list_google_ads_ad_groups
ChatGPTList ad groups with performance metrics, optionally filtered by campaign.
list_google_ads_ads
ChatGPTList individual ads with performance metrics, headlines, descriptions, and URLs.
list_google_ads_campaigns
ChatGPTList Google Ads campaigns with performance metrics (impressions, clicks, cost, conversions, CTR, CPC).
list_hubspot_companies
ChatGPTList HubSpot companies with pagination.
list_hubspot_contacts
ChatGPTList HubSpot contacts using legacy API pagination.
list_hubspot_deals
ChatGPTList HubSpot deals with pagination.
list_mssql_tables
ChatGPTList all base tables in the MSSQL database
list_my_calendar_events
ChatGPTList upcoming Google Calendar events. Use when user asks 'what's on my calendar', 'show my meetings'
list_my_calendars
ChatGPTList all Google Calendars the user has access to
list_my_dropbox_files
ChatGPTList files in Dropbox. Supports pagination and filtering by folder. Use when user asks 'show my Dropbox files', 'what's in my Dropbox'.
list_my_onedrive_files
ChatGPTList files from Microsoft OneDrive with pagination. Use when user asks 'show my OneDrive files'. Requires Microsoft authentication via /oauth/microsoft/authorize.
list_my_outlook_calendars
ChatGPTList all Microsoft/Outlook calendars the user has access to. Requires Microsoft authentication via /oauth/microsoft/authorize.
list_my_outlook_emails
ChatGPTList emails from Outlook inbox or other folders. Use when user asks 'show my Outlook emails', 'what's in my inbox', 'list my Microsoft emails'. Requires Microsoft authentication via /oauth/microsoft/authorize.
list_my_outlook_events
ChatGPTList upcoming Microsoft/Outlook calendar events. Use when user asks 'what's on my Outlook calendar', 'show my Microsoft meetings'. Requires Microsoft authentication via /oauth/microsoft/authorize.
list_my_youtube_channels
ChatGPTList all YouTube channels the user owns or manages, including Brand Accounts.
list_quickbooks_accounts
ChatGPTList chart of accounts from QuickBooks.
list_quickbooks_bills
ChatGPTList bills (payables) with optional date filters.
list_quickbooks_customers
ChatGPTList QuickBooks customers with pagination.
list_quickbooks_invoices
ChatGPTList invoices with optional date filters.
list_quickbooks_items
ChatGPTList products and services (items) in QuickBooks.
list_quickbooks_payments
ChatGPTList payments received with optional date filters.
list_quickbooks_vendors
ChatGPTList vendors (suppliers) in QuickBooks.
list_shopify_customers
ChatGPTList customers with optional date filters.
list_shopify_orders
ChatGPTList orders with optional filters by status, financial/fulfillment status, dates.
list_shopify_products
ChatGPTList products with optional filtering by status, vendor, type, or title.
list_slack_channels
ChatGPTList Slack channels accessible to the authenticated user.
list_tiktok_videos
ChatGPTList the authenticated user's posted TikTok videos with engagement metrics (views, likes, comments, shares). Supports pagination.
query_cosmos_database
ChatGPTExecute a read-only Cosmos DB SQL SELECT query. CRITICAL rules (violations silently return 0 rows): 1) No subqueries, only FROM c. 2) ALL GROUP BY MUST use SELECT VALUE {'key': c.field, 'agg': COUNT(1)} syntax. Without VALUE, cross-partition queries return empty. 3) COUNT(DISTINCT field) does NOT exist. To count unique values, use SELECT DISTINCT VALUE c.field and count results. 4) JOIN is intra-document only. 5) Use TOP N not LIMIT. 6) For complex analytics, break into multiple queries. CORRECT: SELECT VALUE COUNT(1) FROM c | SELECT VALUE {'type': c.type, 'n': COUNT(1)} FROM c GROUP BY c.type | SELECT DISTINCT VALUE c.field FROM c
query_database
ChatGPTExecute a SQL SELECT query on the configured database backend (PostgreSQL or MSSQL).
query_klaviyo_metric_aggregates
ChatGPTQuery aggregate data for a specific Klaviyo metric. Inputs: metric_id (required), measurements, interval, group_by, start_date, end_date.
query_mssql_database
ChatGPTExecute a SQL SELECT query on the MSSQL database
read_my_dropbox_file
ChatGPTRead content of a file from Dropbox. Supports Word docs, Excel, PowerPoint, PDFs, and text files.
read_my_onedrive_file
ChatGPTRead the content of a file from OneDrive. Supports Word, Excel, PowerPoint, PDFs, and text files. Requires Microsoft authentication via /oauth/microsoft/authorize.
read_my_outlook_email
ChatGPTRead a specific Outlook email by ID with full content. Requires Microsoft authentication via /oauth/microsoft/authorize.
read_sheet
ChatGPTRead data from a Google Sheets spreadsheet
reset_connector_token
ChatGPTReset OAuth token state for a connector and force a fresh OAuth consent flow for the current user. Use when tokens are stale, missing scopes, tied to the wrong account/workspace, or repeatedly failing auth. Input: connector_id (required). Supported values: google_workspace, microsoft, dropbox, shopify, quickbooks, hubspot, slack, ebay, facebook_marketing, tiktok, klaviyo.
run_ga4_report
ChatGPTRun a custom Google Analytics 4 report with dimensions, metrics, and date ranges
run_google_ads_query
ChatGPTRun a custom GAQL (Google Ads Query Language) query for advanced analysis. See https://developers.google.com/google-ads/api/docs/query/overview
search_drive
ChatGPTSearch Google Drive files that the authenticated user has access to. Supports pagination for large result sets.
search_gmail
ChatGPTSearch Gmail messages using Gmail search syntax
search_hubspot_contacts
ChatGPTSearch HubSpot contacts by keyword.
search_my_calendar
ChatGPTSearch Google Calendar events by text
search_my_dropbox
ChatGPTSearch for files in Dropbox by name or content. Use when user asks 'find my Dropbox file', 'search Dropbox for X'.
search_my_onedrive
ChatGPTSearch OneDrive files by name or content. Use when user asks 'find my OneDrive file about X'. Requires Microsoft authentication via /oauth/microsoft/authorize.
search_my_outlook_calendar
ChatGPTSearch Microsoft/Outlook calendar events by text. Requires Microsoft authentication via /oauth/microsoft/authorize.
search_my_outlook_emails
ChatGPTSearch Outlook emails by keyword. Searches subject, body, and sender. Use when user asks 'find my Outlook email about X'. Requires Microsoft authentication via /oauth/microsoft/authorize.
search_quickbooks_customers
ChatGPTSearch QuickBooks customers by display name.
search_quickbooks_invoices
ChatGPTSearch invoices by customer name or invoice number.
search_shopify_customers
ChatGPTSearch for customers by name, email, or other attributes.
search_shopify_products
ChatGPTSearch for products by title, vendor, type, or tags.
search_slack_files
ChatGPTSearch Slack file attachments by query. If no matches are returned, use visibility_probe in the response to distinguish query mismatch from permission issues.
search_slack_messages
ChatGPTSearch Slack messages by query.
search_youtube
ChatGPTSearch YouTube for videos by query. Returns titles, channels, publish dates, thumbnails, and URLs.