FLOOKUP DOCUMENTATION OVERVIEW
Introducing the Intelligent Instructor
The Intelligent Instructor is a context-aware AI assistant integrated directly into the Flookup Data Wrangler. It serves as an expert consultant for complex spreadsheet logic and advisorural planning.
Access the tool in your spreadsheet menu via Extensions > Flookup Data Wrangler > Intelligent Instructor. Describe your goal in plain language and the Advisor will draft an engineered logic solution specifically tailored to your current sheet's structure.
Key Capabilities
| Capability | Description |
|---|---|
| Ecosystem intelligence | Natively trained to identify when to use Flookup tools versus native Google Sheets functions. |
| Session memory | Allows follow-up questions and refined logic iteratively without losing context. |
| Data vision | Analyzes real-time data samples to ensure suggested formulas are syntactically compatible with your data types. |
| Intelligent guidance | Provides advice to steer ambiguous or logically flawed requests toward more robust solutions. |
Introduction to Custom Functions
Custom functions are a feature of the Data Edge plan that integrate directly into your spreadsheet cells, operating like native Google Sheets functions e.g. =SUM(A1, B1). They are designed for dynamic, real-time data processing, offering a formula-based approach to advanced data cleaning tasks.
Introduction to Menu Functions
Discover our menu functions, accessible via Extensions > Flookup Data Wrangler.
These tools, detailed in this guide, have a robust 6-minute timeout, making them ideal for handling large datasets and complex data cleaning operations. Each page below offers specific guides on how to use its respective function.
Intelligent Data Cleaning
Harness the power of AI to clean and enrich your datasets with semantic matching and intelligent cleaning.
Schedule Functions
Set your data cleaning on autopilot. Schedule Flookup to run hourly or daily, ensuring your large datasets are always up-to-date without manual effort.
Remove Duplicates
Automatically remove duplicate entries from your dataset while preserving data integrity and structure.
Highlight Duplicates
Identify and highlight duplicate or similar entries in your data with customizable similarity thresholds.