Data Cleaning Documentation for Google Sheets
Standard Data Cleaning
covers fuzzy matching, deduplication, text standardisation, column profiling, enrichment and conditional formatting, bundles those steps into one-click Workflow Templates for reconciliation and consolidation, and lets you train Flookup to learn from examples.
Standard Data Cleaning
runs fuzzy matching, similarity checks and deduplication from the sidebar, with results written safely to your selected range.
Data Cleaning Automation
runs recurring workflows at 15-minute, hourly or daily intervals and handles large datasets across execution windows, even in your absence.
Sheets AI Assistant
adds AI-powered guidance in one sidebar, where the Data Cleaning Guide suggests formulas and cleaning steps in Recommendation Mode and runs multi-step workflows automatically in Execution Mode.
Data Connectors
pull Airtable, SQL and Salesforce records into a staging sheet from the same sidebar, keep record ids so write-back updates only the rows you changed and never deletes anything, and are included with the Extended Pass and the Team Pass.
Try Flookup on your own sheet with the free tier, which keeps one 50 row menu run per day and starts without a credit card.
Worked example. The sidebar workflow these pages document, from opening the menu to reading the results, is shown on real rows in Clean Google Sheets Without Formulas Using Flookup.
Run from the Sidebar
Standard Data Cleaning
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.
Data Cleaning Automation
Schedule data cleaning to run every 15 minutes, hourly or daily.
Process large datasets automatically with auto-chaining across execution windows. No manual intervention is required.
Sheets AI Assistant
One sidebar in one menu item: the Data Cleaning Guide suggests formulas and cleaning steps in Recommendation Mode and runs multi-step workflows automatically in Execution Mode. Direct AI clean applies AI-powered cleaning to your range from a plain language description.
Pull Data In
Airtable Connector
Connect a base with a personal access token, keep record ids for safe updates, and write changed fields back without touching the columns you did not edit.
SQL Database Connector
PostgreSQL, MySQL, SQL Server and Oracle through a read-only query, with a key column so write-back can update the right rows and never delete any.
Salesforce Connector
Authorise with OAuth through a Connected App, choose objects and fields, run SOQL and pull records into the staging sheet. Read only.
Work on Your Data
Pass Time and the Work Meter
A pass holds a balance of active processing time, not a countdown on the calendar. The meter counts menu runs, scheduled chunks and workflow steps only while they execute. Review, editing and idle time do not use the balance. Each run is capped at 6 minutes, and failed runs that process no rows are not charged. Google execution quotas are separate and can stop scheduled work sooner.
The Essential Pass includes 45 hours, the Extended Pass includes 547.5 hours and the Team Pass includes 2,737.5 hours shared across five accounts. Unused balance does not expire.
Open Extensions > Flookup Data Wrangler > Account Management and choose Dashboard to see the time left. The card shows the equivalent in work days at 90 minutes each, the exact balance, the number of runs it still covers, and a progress bar for the pass. Older passes that predate the meter show their remaining calendar days instead.
When the balance reaches zero the free tier applies again. Nothing renews and no card is kept on file.
Focused Guides
Workflow Templates
One-click workflows for AP vendor reconciliation, order-to-shipping reconciliation and user list consolidation. Each template chains Standardize, Find Duplicates and Fuzzy Match, then writes the results to a review sheet so your source data is not modified.
Fuzzy Conditional Formatting
Colour-code near-duplicate groups in place so you can review them before deleting rows. Covers the matching modes, the threshold rules, the colour schemes and how to remove the highlighting afterwards.
Learn from Examples
Teach the Standardize operation a transformation by giving it dirty and clean example pairs. It derives the rule from your examples and applies it to every row, with no formulas to write.