Data Cleaning Documentation for Google Sheets
Flookup Data Wrangler operates through the sidebar and AI-powered guidance.
Data Processing Functions
cover fuzzy matching, deduplication, text standardisation, column profiling, enrichment, comparison and conditional formatting. They also bundle into one-click Workflow Templates for reconciliation and consolidation. You can also
train
Flookup to learn from examples.
Schedule Functions
automate recurring workflows at 15-minute, hourly or daily intervals. Auto-chaining handles large datasets across execution windows.
Sheets AI Assistant
adds AI-powered guidance in three modes. Recommendation Mode suggests formulas and cleaning steps. Execution Mode runs multi-step workflows automatically. AI Enrichment Mode adds AI context to any column at a flat cost of 10 credits.
Data Processing Functions
Open via
Extensions > Flookup Data Wrangler > Data Processing Functions.
Pick a function, configure parameters and process your data directly. All plans include these tools. Data Nova unlocks unlimited rows per run.
One-click
Workflow Templates
bundle these functions into ready-made reconciliation and consolidation jobs for Data Nova users.
Data Processing Functions
Fuzzy matching, deduplication, text standardisation, column profiling, enrichment, similarity comparison and conditional formatting. Profile your data to detect issues, then clean it with one click.
Schedule Functions
Schedule data cleaning to run every 15 minutes, hourly or daily. Process large datasets automatically with auto-chaining across execution windows. No manual intervention needed.
Sheets AI Assistant
Three modes in one assistant: Recommendation Mode suggests formulas and cleaning steps, Execution Mode runs multi-step workflows automatically and AI Enrichment Mode adds AI context to any column.
Data Cleaning Formulas
Type spreadsheet formulas such as FLOOKUP, FUZZYSIM, DEDUPE and ULIST directly into cells for quick lookups and spot checks. Included with paid plans.
Last updated: August 2026