FLOOKUP AI DOCUMENTATION

Introduction to Flookup AI

Simplify data cleaning in Google Sheets with AI that understands and refines messy data with minimal input. Rather than relying solely on traditional algorithms, Flookup AI responds to natural language prompts to carry out corrections, formatting, and more, based on your instructions. Whether you are fixing typos, harmonising categories, or preparing sheets for analysis, this tool adapts to your intent and streamlines the process.

Note: Flookup AI is an extension but a separate feature of Flookup Data Wrangler and requires its own subscription.

• To activate Flookup AI, click here.

1. Click the link above to purchase a subscription.
2. Choose your payment method and complete the process.
3. Open the confirmation email and copy your "Activation License".
4. In Google Sheets, go to Extensions > Flookup Data Wrangler > Manage your subscription > Profile activation.
5. Submit your "Activation License" and wait for confirmation.

Data Cleaning with Flookup AI

1. Go to Extensions > Flookup Data Wrangler > Smart data cleaning using AI in your spreadsheet menu.
2. Select the data cleaning mode you wish to run (see below for explanations).
3. Enter your own OpenAI™ API key. You may store or erase the key securely within your Google account.
4. Highlight a range of data to analyse and click Grab selected range.
5. Enter your prompt, referencing columns by number (e.g., column 1 for column B).
6. Click an empty cell to indicate where results should be displayed.
7. Click Submit data cleaning prompt.

Data Cleaning Modes

• Fuzzy match: Compare data from two columns and return best matches.
• Remove duplicates: Remove duplicates and return only unique values.
• Standardise data: Adjust case, trim spaces, correct misspellings, and ensure numeric consistency.
• Transform data formats: Modify date formats, convert measurement units, and apply user-specified changes.
• Fill in missing data: Fill missing data with placeholders or computed values.
• Remove common outliers: Remove outliers and return the cleaned dataset.

How to Write Good AI Prompts

• Be clear and direct: Describe exactly what you want to clean or modify (e.g., "Remove duplicate rows").
• Do not be vague: Use precise language instead of vague terms like "fix" or "clean up". Specify what needs to be fixed and how.
• Keep it simple: Stick to one task per prompt when possible. Separate complex tasks into multiple steps.
• Use data cleaning keywords: Short, structured instructions work better than long explanations (e.g., "Remove punctuation marks from all cells").
• Specify edge cases: If certain values should be ignored or handled differently, mention that (e.g., "Do not change column headers").
• Test and refine: If results are not perfect, tweak the wording to improve accuracy.

Flookup AI Usage Policy

The way you use AI for data cleaning depends on your specific use case and data set. Experiment with different approaches to find the most effective solution. The number of rows you can clean with AI is determined by available load, but should be at least 50,000 rows per month.

Flookup AI Privacy Statement

We greatly value your privacy. Personal details are collected solely to manage your subscription and are never shared. Data processed via the add-on remains strictly within your Google Sheet and is only transmitted securely to OpenAI for AI-powered responses, never seen by us or any third party. All operations are sandboxed with encrypted transmission and no data is stored externally. You retain full rights over your data and can request deletion at any time. For concerns, please contact us.

Explore More

• How to Use Custom Functions to Clean Data
• Removing Duplicates by Text Similarity
• Highlighting Duplicates by Text Similarity