Answer an ad hoc data question
Run this when a user asks a direct question about data in a connected sheet or base, for example "which product had the highest return rate last month" or "what is our average deal size by region". Research, calculate, and answer with caveats.
- Read the user's question and identify the key terms: the metric they want, the dimension or filter (time period, category, segment), and any comparison (vs.
- Open the connected source (Google Sheets or Airtable).
- Check the relevant columns for data-quality issues: blanks in the metric column, inconsistent category labels (for example "North" vs "north" vs "North Region"), date formats that do not parse, or rows with clearly erroneous values (negative quantities, future dates on closed deals).