How to Install and Activate Flookup

On This Page

Installing Flookup

  1. Temporarily log out of any other secondary Google accounts.
    If you do not do this, Flookup might fail to authenticate correctly. See the Google account authentication guide.
  2. Install in one click from the Google Workspace Marketplace (recommended), then continue at step 5.
  3. To install from inside Sheets instead, open on your computer the Google Sheets spreadsheet in which you want to install Flookup.
  4. In the menu, click Extensions > Add-ons > Get add-ons. In the new window, search for "Flookup" or "Flookup Data Wrangler", click on it, then click "Install" and "Continue".
  5. To allow Flookup to work, read the important "Request access" message and then click the "Allow" button.
  6. When the installation completes, click the button labelled "Done" to finish.

Flookup installs as a Google Workspace add-on rather than as desktop software, so there is no installer to run and no operating system component to deploy.
An individual install needs no administrator rights, which matters on managed or locked-down machines where installing desktop applications is blocked.
A Google Workspace administrator can also install it for a whole domain or for selected groups, so nobody has to install it individually. They manage this from the Google Workspace Admin console and can target a whole domain, a single group or one user.

Because it runs inside Google Sheets, Flookup works on macOS, Windows, Linux and ChromeOS, and in the browser on Excel for the web, without a separate build for any of them.


Permissions We Request from You

Permission Granted by Google Why We Need It
See, edit, create and delete all your Google Sheets spreadsheets This permission enables Flookup to read, modify and write data in the spreadsheet when you run a cleaning function or start an authorised scheduled task. Scheduled tasks can modify their configured ranges in the background.
Allow this application to run when you are not present This permission enables the scheduling of automated cleaning tasks that run at set intervals, so your data remains current without manual intervention.
Display and run third-party web content in prompts and sidebars This permission is required to display the Flookup user interface, including the sidebar and interactive dialogs, within Google Sheets.
Connect to an external service This permission is used to verify your purchase and for AI features that connect to external services. Flookup stores the payment metadata needed to verify purchases and provide support.
See your primary email address and any public personal information Your email address is used for account identification and to activate the pass you buy. Flookup stores payment metadata, including the payment or transaction identifier, product and plan, amount, currency, timestamp and associated account details, as described in the Privacy Policy.

How to Use Flookup

See the result first, then test the full product on your own data, then keep it only if it proves suitable. Fees are on the pricing page.

Flookup provides a focused workflow for working on your own data. Standard Data Cleaning runs from the sidebar for full workflows such as fuzzy matching, deduplication and standardisation. The documentation overview explains the available workflows in detail.

Stage What to do
See the outcome before install Read the Standard Data Cleaning guide to see how Flookup handles fuzzy matching, deduplication, standardisation and profiling in your own sheet.
Test on your own data with full capability When you are ready to try Flookup in Google Sheets, install the add-on. The free tier starts immediately with no credit card, and the 7-day trial opens the menu tools without limits. AI features use your own API key from Google Gemini or OpenAI.
Retain while it proves suitable The Essential Pass is a one-time payment of $15 and includes 45 hours of processing. The Extended Pass is a one-time payment of $150 and includes 547.5 hours. Nothing renews. After purchase, activation is automatic and the confirmation email is your receipt. Full details including fees are on the pricing page.

Payments are processed by PayPal. Review the amount, currency and any additional charges shown during checkout before confirming. Refund eligibility and processing details are set out in our refund policy.

How the Free Tier, Trial and Pass Work

The free tier starts immediately with no credit card. The 7-day trial opens the menu tools without limits and includes the AI features, also with no credit card, and no payment is taken automatically when it ends. If you choose to continue, the Essential Pass is a one-time $15 payment that includes 45 hours of processing and the Extended Pass is a one-time $150 payment that includes 547.5 hours; neither renews.

1 Install and open

Install Flookup from the Google Workspace Marketplace and open it from the Extensions menu.

2 Use the free tier and trial

The free tier is active from install. The 7-day trial starts with it and opens the menu tools without limits. No credit card is required and no payment is taken automatically.

3 Add your AI key

Choose Google Gemini or OpenAI in the sidebar settings and paste the API key from your own account.

4 Buy once

Buy the $15 Essential Pass or the $150 Extended Pass when you are ready. Each includes a work balance and does not renew.

Plan Trial Trial cost Pass cost Seats AI provider
Essential Pass 7 days, menu tools and AI Free, no card $15 for 45 hours 1 Your own key
Extended Pass 7 days, menu tools and AI Free, no card $150 for 547.5 hours 1 Your own key
Team Pass 7 days, menu tools and AI Free, no card $399 for 2,737.5 hours 5 Your own key

Free forever, no credit card. Every install includes the free tier. Menu tools include one 50 row menu run per day, up to 10 runs a month, and column profiling is free and read-only. The menu tools are available during the 7-day trial and with a pass; you can also try them free in the documentation, which shows worked examples on sample data. The trial starts on first use and opens the menu tools without limits, with the AI assistant included when you add your own key.

The Essential Pass includes 45 hours of processing, the Extended Pass includes 547.5 hours and the Team Pass includes 2,737.5 hours shared by five accounts. None renew, and unused time does not expire. Row limits apply per run, not to the pass as a whole: 1,000 rows on the Essential Pass, 10,000 on the Extended Pass and 100,000 on the Team Pass. The free tier includes one 50 row menu run per day, up to 10 runs a month. See the pricing page for current purchase details.

A Tour of the Interface

These are the three screens you will spend the most time in, drawn from the current add-on. The wording, the field order and the function names match what you get from Extensions > Flookup Data Wrangler in Google Sheets; only the surrounding Sheets window is left out.

Ready
Standard Data Cleaning
Templates
Fuzzy Match Data
Fuzzy Merge Rows
Find Duplicates
Standardize Data
Profile Column
Remove Duplicates
Extract Unique Rows
Enrich Data
Compare Similarity
Fuzzy Conditional Formatting

Free: 1 of 1 run left today · 9 of 10 left this month · See the plans

Click a cell then select a function.

Run Cancel
Standard Data Cleaning. All eleven tools sit in one list, and the selected one opens underneath. Unlimited on a paid plan, so the only limits are rows and cells.
Ready
Function
Fuzzy match by percentage
Processing Mode
Process data to the end
Configuration
Lookup values
e.g. 'Sheet1'!A1:A100
Grab selected range
Sensitivity
Threshold 0.75

Strict Match

Schedule
Frequency mode
Run every few hours
Time of day
06:00
Frequency
1
Schedule Reset
Data Cleaning Automation. Pick a function and a frequency, and the job runs on a timer without the sidebar open.
Ready
Sheets AI Assistant
Mode
Recommendation Mode
Task
Describe your spreadsheet task
Define the problem or logic you need to solve

0 / 300

Settings
AI provider
Google Gemini
API key
••••••••••••
Save key

Your key is securely stored in your own Google account and is sent only to the provider you choose.

Get solutions
Recommended Solution
Instructions will be drafted here
Sheets AI Assistant. It runs on your own Google Gemini or OpenAI key, saved once in Settings.
Flookup Data Wrangler sidebar open in Google Sheets showing fuzzy matching and data cleaning tools
The live sidebar in Google Sheets, with the functions the tour above labels.

How to Activate Your Pass

Activation needs no licence code. Your pass activates on the email address you pay with, so sign in to Google Sheets with that same address and open the dashboard. To move the pass to a different address, open Extensions > Flookup Data Wrangler > Account Management, then select Change email while signed in with the current address. Both the old and the new address receive a confirmation email when the change goes through. On a Team Pass this moves the licence owner's address: the other members keep signing in with their own Google accounts and the same licence key, so nothing changes for them and no seat is used up. Accounts that already hold a licence key from the earlier system keep working as they are. The steps below cover what to expect.

Plan Activation

Step Action
Select your plan Visit our pricing page and select your plan.
Complete purchase Complete your purchase through PayPal checkout. Your pass activates on the email address you pay with, so pay with the Google account you use in Google Sheets and an address you can access. See Payment and Checkout below.
Keep your receipt After payment, check your email for the confirmation and receipt.
Confirm in Sheets Return to Google Sheets and navigate to Extensions > Flookup Data Wrangler > Account Management, then select Dashboard and click Fetch status. Your pass applies to the Google account signed in with the email address you paid with.

Trial and Pass Details

Detail Information
Free tier plus 7-day trial The free tier starts at install with no credit card. The 7-day trial opens the menu tools without limits and includes the AI features, also with no credit card.
What is charged No payment is taken automatically during or after the trial. If you choose to continue, the Essential Pass is a one-time payment of $15 and the Extended Pass is a one-time payment of $150
AI usage AI features use your own key from Google Gemini or OpenAI, while the Flookup skills behind them run on our side at no extra cost. Any charges for API use are set by the provider and are separate from the Flookup pass.
Nothing renews Each pass includes a work balance and does not renew. No further payment is required.
Buy when ready Buy the Essential Pass or the Extended Pass on the pricing page.

Payment and Checkout

Use the purchase link on the pricing page to open PayPal checkout. Your pass activates on the email address you pay with, so pay with the Google account you use in Google Sheets. Available payment methods, currency and the amount due are shown by PayPal and may depend on your location. Review the final total, including any additional charges shown, before confirming your purchase.

Detail Information
Payment details Enter payment details only in the PayPal checkout, not in Flookup or Google Sheets. Your pass activates on the email address you pay with.
After payment Check the confirmation email for your receipt. See our refund policy for refund terms.

Checking Your Activation

You can check your activation status from the Flookup dashboard in Google Sheets.

Step What happens
Open the dashboard In Google Sheets go to Extensions > Flookup Data Wrangler > Account Management, then select Dashboard.
Fetch status Click Fetch status to refresh the displayed activation status. If it still looks wrong, contact us with the Google account email address you paid with.
Confirm and check After opening the dashboard, click Fetch status to confirm your activation state.

How to Troubleshoot Your Plan

When Jobs Outgrow One Run

If a run keeps hitting the execution limit, split the range into smaller batches or move the job to Data Cleaning Automation.
Automation works through the range in chunks in the background and resumes from the last completed row, so large or recurring jobs finish without you keeping the sidebar open.

Pulling Data In from Another System

Data Connectors bring records from Airtable, a SQL database or Salesforce into a staging sheet, so you can clean and match them in Google Sheets instead of exporting CSVs by hand. Connectors are included with the Extended Pass and the Team Pass.

Step What to do
Open Data Connectors In Google Sheets go to Extensions > Flookup Data Wrangler > Data Connectors.
Airtable Create a personal access token with data.records:read, data.records:write and schema.bases:read, paste the token into the card, then load the bases to pick a table.
SQL database Paste a JDBC connection string such as jdbc:postgresql://host:5432/db with the user name and password, then write a single SELECT query.
Salesforce Create a Connected App with the callback URL shown in the sidebar, add the api and refresh_token scopes, then paste the consumer key and secret and connect.
Pull and clean Click Pull to staging. Rows land in a hidden Flookup Staging sheet, and Airtable rows keep the source record id for write-back.
Write changes back Clean the staging sheet, then preview the differences and confirm before anything is sent. Airtable is patched field by field, SQL is updated through the key column, and Salesforce is read only.

The full setup, including the scopes each token needs and the ports Apps Script can reach, is in Data Connectors.