build_workbook
ChatGPTUse this when the user wants a new Excel workbook whose formulas are checked, not only generated: a budget or expense tracker, an inventory or stock tracker, an attendance or roster sheet, a project tracker, a rental property cash flow, quotes and invoices, a grade book, or a small business profit and loss. The first call creates a private preview with live formulas checked on sample rows and a pass/fail proof line (how many checks passed); the .xlsx file is delivered only after an explicit download action in the widget. Does not edit or read uploaded files; to check a file the user already has, use check_workbook_health. Workbook contents appear in the widget.
build_workbook_from_template
ChatGPTUse this when the user wants a ready-made template: budget, inventory, attendance, project, rental cash flow, quote/invoice, grade book, profit and loss. Builds the template as it is, without customization, as a private preview with live formulas checked on sample rows and a pass/fail proof line; the .xlsx file is delivered only after an explicit download action in the widget. Does not edit or read uploaded files. Workbook contents appear in the widget.
check_formula_samples
ChatGPTCompare a candidate Excel or Google Sheets formula with up to three explicit user-supplied expected samples using the bounded Formula Genius simulator. Returns per-case actual results, mismatches or unsupported reasons. Requires sign-in. It does not generate expectations, execute a workbook, save data, or certify spreadsheet correctness.
check_workbook_health
ChatGPTUse this when the user attaches an Excel (.xlsx) or UTF-8 CSV file (up to 5 MiB) and wants it checked for problems in the user's own file. It finds error values, broken or external links, duplicate rows, numbers or dates stored as text, hard-coded numbers inside formulas, inconsistent formulas, volatile or whole-column references, stray spaces and mixed types, and reports the count and location of each. This is a deterministic static scan of the user's file: formulas are not recalculated and the original file is never changed. Leave options empty unless the user explicitly asks to clean the data (clean) or to remove exact duplicate rows (removeDuplicates, which requires clean). Macro-enabled, legacy .xls or .xlsb and password-protected files are not supported. PDFs are not read here: use open_statement_converter for a bank statement PDF or open_invoice_extractor for a PDF invoice or receipt. The report appears in the widget and the .xlsx report file is delivered only after an explicit download action there.
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.
deliver_invoice_ledger
ChatGPTRun only on an explicit workspace action to show the full ledger using existing entitlements or accepted credits. Exports require row review. Returns XLSX or mapping CSV data only in private widget metadata. Repeating delivery for the same extraction does not consume credits twice.
deliver_workbook
ChatGPTUsed by the workbook widget after the user explicitly chooses to download. Never call automatically.
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_regex
ChatGPTCreate a regular-expression pattern from a plain-language matching task. Use when the user needs a regex and identify the intended runtime (such as JavaScript or Python) in the request or context when relevant. Returns the pattern, flags, explanation, examples, and usage notes; it does not execute the regex against user data.
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.
get_account_status
ChatGPTUse this when the user asks about their plan, remaining credits, or today's and this month's usage. Read-only; changes nothing.
get_workbook_health
ChatGPTUsed by the workbook widget to reload an owned health report. Read-only; consumes nothing.
get_workbook_preview
ChatGPTUsed by the workbook widget to reload an owned preview. Read-only; consumes nothing.
open_statement_converter
ChatGPTUse this when the user wants to convert a bank statement PDF to Excel. Opens a private review workspace, optionally with an attached PDF. Does not download or analyze the file until the user consents and runs extraction. AI beta supports up to 3 MB, 3 pages, and 60 transactions. Every row must be reviewed before export. Keep your response brief; financial rows stay private in the widget.
record_workbook_event
ChatGPTUsed by the workbook widget to record that a notice was shown or a link was selected. Never call automatically.
show_example_fix
ChatGPTUse this when the user has just connected Formula Genius, greets it, asks what it can do or how to start, or wants to see it work before sharing their own data. Shows one built-in example: a broken spreadsheet formula, the fixed formula, and sample rows checked before and after. Uses no credits and none of the user's data. Do not use it when the user already gave a formula or a concrete task; handle that task instead. The example renders 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.