How to 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. If you need to establish whether the tools suit your data before installing anything, the free tools run entirely in your browser and require no account.

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 for licence verification and for AI features that connect to external services. Flookup stores the licence and 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 licence management. Flookup stores payment and licence 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 and credit allowances are on the pricing page.

Flookup provides two complementary modes. Standard Data Cleaning runs from the sidebar for full workflows such as fuzzy matching, deduplication and standardisation. Data Cleaning Spreadsheet Formulas ( FLOOKUP , FUZZYSIM , DEDUPE and ULIST ) are typed into a cell for quick lookups and spot checks. The documentation overview explains each in detail.

Stage What to do
See the outcome before install Open the demo spreadsheet to view working examples of the Data Cleaning Spreadsheet Formulas on sample data with full explanations of inputs and cleaned outputs. No install and no payment is required. The demo shows only spreadsheet formulas, also called custom functions, including FLOOKUP , FUZZYSIM , DEDUPE and ULIST . It does not demonstrate Standard Data Cleaning, Data Cleaning Automation or the Sheets AI Assistant.
Test on your own data with full capability When you are ready to test on your own data, start with the Week Pass. It gives you a 24 hour free trial with 250 AI credits, and every threshold, automation and workflow template is unlocked from the start. The $4.99/week plan price is charged at the end of the trial unless you cancel first. You test with the same capability you retain afterwards. See the pricing page for the other trial lengths.
Retain while it proves suitable Data Nova renews each billing period and you can cancel at any time. Your licence activates after payment when you submit your Profile ID at Extensions > Flookup Data Wrangler > Account Management > Profile activation. Starter, Pro and Teams differ only in credit allowance and user count. Full details including fees are on the pricing page. Your plan renews at the plan price until you cancel. Cancel from Account Management in one click.

Payments are processed by Lemon Squeezy. If a purchase does not arrive or is materially defective, contact us first, as direct resolution is usually faster. Refunds we approve for defects or billing errors within 14 days return to the original method within five to seven business days.

Access is granted instantly, so change of mind after delivery is not covered. That is why the free trial exists: you see the full result before you commit. The full terms are in the refund policy.

149K+ users on Google Workspace Marketplace and 10,000+ daily active users since 2018. Google-verified, with a free trial and one-click cancellation.

How the Subscription Works

Every plan begins with a free trial that needs a credit card. The plan price is charged when the trial ends unless you cancel first, and cancelling is one click from Account Management > Cancel plan.

1 Pick a plan

Choose Week Pass, Starter, Pro or Teams on the pricing page.

2 Add a card

A credit card starts the trial.

3 Trial runs

Full feature access for the trial length on that plan.

4 Cancel or continue

Charged at the plan price when the trial ends, unless you cancel first.

Plan Trial Trial credits Short-term Long-term Seats Credits / period
Week Pass 24 hours 250 $4.99/ week Not offered 1 1,000
Starter 3 days 2,500 $15/ month $149/ year 1 10,000
Pro 7 days 10,000 $39/ month $390/ year 1 50,000
Teams 14 days 75,000 $79/ month $790/ year 25 300,000

Cancel from Account Management › Cancel plan and you keep access to the end of the period you have already paid for. Cleaning, deduplication, standardisation and profiling are unlimited on every plan.

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 and function names match what you get from Extensions > Flookup Data Wrangler in Google Sheets, with the layout simplified to keep the labels readable.

Standard Data Cleaning
Templates
Fuzzy Match Data
Fuzzy Merge Rows
Find Duplicates
Standardize Data
Profile Column
Remove Duplicates
Extract Unique Rows

Click a cell then select a function.

Standard Data Cleaning. Unlimited on a paid plan, so the only limits are rows and cells.
Account Management

Copyright 2026 Andrew Apell. All rights reserved.
Flookup Production Build 2864
Terms and Conditions | Privacy Policy

Flookup is active.

Fetch status Cancel plan
Account dashboard, where cancelling takes one click.
Sheets AI Assistant

37,420 AI credits remaining, next allowance 1 Oct 2026

Mode
Recommendation Mode
Describe your spreadsheet task
Define the problem or logic you need to solve

0 / 300

Get solutions
Recommended Solution
Instructions will be drafted here
Sheets AI Assistant. The only part that spends AI credits, and it is included on every Data Nova plan.

How to Activate Your Paid Plan

After purchasing the Week Pass or a Data Nova plan, activate your licence by following the steps below.

Plan Activation

Step Action
Select your plan Visit our pricing page and select your plan.
Complete purchase Complete your purchase on our secure Lemon Squeezy checkout page and enter any email address. See Paying at Checkout below.
Retrieve Profile ID After payment, check your email for a confirmation that contains your unique Profile ID.
Submit in Sheets Return to Google Sheets and navigate to Extensions > Flookup Data Wrangler > Account Management > Profile activation and submit your ID.

Free Trial, Then Renews Until You Cancel

Detail Information
Free trial, credit card required Every plan starts with a free trial: 24 hours on the Week Pass, 3 days on Starter, 7 days on Pro and 14 days on Teams. A card is required to start.
What is charged Your card is charged the full plan price when the trial ends. Cancel before then and you are not charged.
Credits added each period Each billing period adds a fresh AI credit allowance to your balance. On Starter, Pro and Teams unused credits carry over, while Week Pass credits expire 7 days after they are added. Cleaning and deduplication are unlimited and never run out.
Auto-renewal Your plan renews automatically. Cancel from the billing portal that Manage plan opens and you keep access to the end of the period you have paid for.
Purchase again when ready If you need more credits, simply purchase a new plan on the pricing page.

Paying at Checkout

Every plan is bought through Lemon Squeezy. A credit card is all you need and no separate account is created for you.

Detail Information
Pay by card At checkout choose card payment and enter your card details. The card is stored by Lemon Squeezy for renewals and you can change it at any time from the billing portal.
Other payment methods Lemon Squeezy also offers PayPal, and depending on your country and device, Apple Pay, Google Pay, Cash App Pay, WeChat Pay and Alipay at the same checkout. Lemon Squeezy shows each customer only the methods available to them. The plans, prices and trial lengths are identical on every route.
Manage after buying Open Flookup in Google Sheets, go to Account Management and choose Manage plan. This opens the Lemon Squeezy billing portal, where you can upgrade, downgrade, pause or cancel, and update your payment details. Our own refund policy applies in full, including the 14 day review window.

Changing Your Plan

You can move between plans whenever you want, in either direction. Your Profile ID stays the same, there is no reinstall, and nothing you have already cleaned is lost.

Step What happens
Open the dashboard In Google Sheets go to Extensions > Flookup Data Wrangler > Account Management > Dashboard .
Click Manage plan The Lemon Squeezy billing portal opens in a new tab.
Sign in Use the email address you bought with. Lemon Squeezy emails you a sign-in link, so there is no password to remember.
Choose the plan The portal shows the new price and the amount credited for the time you have already paid for, before you confirm anything.
Confirm and check Your new plan applies straight away. Return to Sheets and click Fetch status to see the new plan and your credit balance.

How the money works when you change plan. Lemon Squeezy prorates every plan change. The change itself is immediate, so the new plan and its AI credit allowance apply as soon as you confirm, and the new allowance is added to the balance you already have. The unused part of the plan you are leaving is credited, and the difference for the time you have left is added to your next invoice rather than charging you twice for the same period. Moving between the weekly, monthly and yearly plans recalculates your billing date, and that change can be invoiced immediately.

If you pay by PayPal, the billing portal can still update your payment details and cancel your subscription, but PayPal does not allow a subscription to move to a different product. Each Flookup plan is a separate product, so contact us with your Profile ID and we will move you across.

How to Troubleshoot Your Plan