compare_formulas
ChatGPTCompare two formulas and recommend which one is better. Evaluates formulas based on accuracy, performance, and readability. Use when the user has multiple ways to achieve the same result and wants to choose the best approach. Respond with a short confirmation only; full details render in the widget.
create_share_link
ChatGPTCreate a private link for the current user's formula card. Widget-accessible only.
debug_formula
ChatGPTFind and fix errors in a spreadsheet formula. Use when the user has a formula that returns an error like #REF!, #VALUE!, #NAME?, #N/A, or isn't working as expected. Examples: - "Fix this VLOOKUP that returns #N/A" - "Why is my formula giving #VALUE! error?" - "This SUMIF returns wrong results" - "My formula worked but now shows #REF!" Respond with a short confirmation only; full details render in the widget.
explain_formula
ChatGPTBreak down and explain an existing spreadsheet formula step by step. Use when the user pastes a formula and wants to understand what it does or how it works. Examples: - "What does this VLOOKUP formula do?" - "Explain =SUMIFS(B:B, A:A, ">10", C:C, "Complete")" - "Break down this INDEX MATCH formula" - "How does this array formula work?" Respond with a short confirmation only; full details render in the widget.
generate_airtable_script
ChatGPTGenerate Airtable automation scripts from natural language. Use when the user asks for Airtable automations or scripting. Respond with a short confirmation only; full details render in the widget.
generate_apps_script
ChatGPTGenerate Google Apps Script for Google Sheets from natural language. Use whenever the user asks for Apps Script or Google Sheets automation. Respond with a short confirmation only; full details render in the widget.
generate_formula
ChatGPTConvert a natural language description into an Excel or Google Sheets formula. Use when the user wants to create a formula, calculate something in a spreadsheet, or needs help with spreadsheet functions like VLOOKUP, SUMIF, INDEX/MATCH, etc. Examples of requests this tool handles: - "Calculate commission on sales over $10K" - "Find duplicates between column A and column B" - "Count weekdays between two dates" - "Sum values where status is 'Complete'" - "Extract text after the last space in a cell" - "Calculate running total with conditions" - "VLOOKUP that returns multiple columns" Respond with a short confirmation only; full details render in the widget.
generate_script
ChatGPTGenerate VBA macros for Excel, Apps Scripts for Google Sheets, or Airtable automation scripts from natural language. Examples: - "Create a VBA macro that highlights cells above 100 in red" - "Apps Script to send email when cell value changes" - "Macro to auto-format dates in column A" - "Script to copy data between sheets daily" Use when the user needs automation scripts beyond simple formulas. Always call this tool for VBA macros or Apps Script requests. Respond with a short confirmation only; full details render in the widget.
generate_sql
ChatGPTGenerate SQL queries for MySQL, PostgreSQL, SQL Server, or SQLite from natural language. Examples: - "Get all customers with orders over $100" - "Find duplicate emails in the users table" - "Calculate total sales by month" - "Join customers and orders, show top 10 by revenue" - "Update prices by 10% for products in category 'Electronics'" Use when the user needs database queries. Respond with a short confirmation only; full details render in the widget.
generate_vba
ChatGPTGenerate Excel VBA macros from natural language. Use whenever the user asks for a VBA macro, Excel macro, or VBA script. Respond with a short confirmation only; full details render in the widget.
validate_formula
ChatGPTRun verification coverage for a formula using simulation where supported. Produces coverage status (VERIFIED, PARTIAL, or SKIPPED), confidence score when available, and clear caveats. Use when the user wants confidence signals and edge-case checks without claiming guaranteed correctness. Respond with a short confirmation only; full details render in the widget.
