AI Spreadsheet Solver Documentation
Overview
The Spreadsheet Solver is a context-aware AI assistant powered by advanced artificial intelligence, integrated directly into Flookup Data Wrangler. It acts as a senior spreadsheet architect, helping you navigate complex data cleaning tasks and formula construction without leaving Google Sheets.
While optimized for the Flookup toolkit, the Solver is a dynamic advisor capable of handling general Google Sheets operations. Whether you need help with native functions, complex script logic or general data auditing, it provides tailored guidance that goes beyond Flookup-specific tools.
Going beyond a general AI bot, the Spreadsheet Solver is specifically trained on the Flookup ecosystem and can see a sample of your active spreadsheet data to provide precise, working solutions.
How to Open It
In Google Sheets, go to Extensions > Flookup Data Wrangler > Spreadsheet Solver.
For the best results, select the range of data you are working with before opening the sidebar. This allows the Solver to understand your headers and data types.
Key Capabilities
| Feature | What it does |
|---|---|
| Ecosystem Intelligence | Knows when to recommend a =FLOOKUP formula versus a native Google Sheets VLOOKUP or QUERY. |
| Data Vision | Analyzes your selected range (headers and top rows) to ensure suggested formulas match your actual column references. |
| Session Memory | Maintains context across multiple prompts, allowing you to ask follow-up questions like "Can you make that formula case-insensitive?" |
| Intelligent Guidance | Will steer you away from inefficient spreadsheet patterns and suggest more robust data cleaning workflows. |
Data Privacy and Security
We take data privacy seriously. The Spreadsheet Solver uses strict sanitization protocols before sending any data to the AI model:
- Input Limit: User prompts are capped at 2,000 characters to prevent accidental leakage of large text blocks.
- Data Sampling: Only a small sample of your data (headers and a few rows) is sent to provide context.
- Text Snippets: Individual data values are truncated to 200 characters to protect sensitive information.
- Ephemeral Processing: Data is used only to generate the response and is not used to train the underlying model.
Usage Limits
The Spreadsheet Solver is available on all plans, including the free tier.
| Plan | Daily Limit | Monthly Limit |
|---|---|---|
| Free Plan | 50 Requests | 500 Requests |
| Paid Plans | No limit* | No limit* |
* Subject to fair use policies to ensure service stability for all users.
Best Practices
- Select Your Data First: Always highlight the relevant table or columns before asking a question.
- Be Specific: Instead of "Clean my data", try "I want to remove punctuation from column A and then fuzzy match it against column C".
- Iterate: If the first formula doesn't quite work, tell the Solver what went wrong. It remembers your previous messages.
- Check The Math: While highly accurate, always verify AI-generated formulas on a small sample before applying them to your entire dataset.
Frequently Asked Questions
Does the Solver edit my sheet directly?
No. The Solver provides formulas and instructions. You remain in full control and must copy/paste or apply the logic yourself.
Can I use it for script writing?
Yes. The Solver can help draft Google Apps Script snippets tailored to your needs.