How to Activate Flookup
Installing Flookup
-
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. - Install in one click from the Google Workspace Marketplace (recommended), then continue at step 5.
- To install from inside Sheets instead, open on your computer the Google Sheets spreadsheet in which you want to install Flookup.
- 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".
- To allow Flookup to work, read the important "Request access" message and then click the "Allow" button.
- 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 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 read-only
demo spreadsheet
to view examples of the Data Cleaning Spreadsheet Formulas on sample data, with explanations of inputs and outputs. No install or 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 try Flookup in Google Sheets, the free tier starts immediately with no credit card. AI features include a 7-day AI trial and use your own API key from Google Gemini or OpenAI. The public demo spreadsheet runs the spreadsheet custom functions fully on sample data. |
| Retain while it proves suitable | The 1-Month Pass is a one-time payment of $1.99 for 30 days and the 1-Year Pass is a one-time payment of $12 for 365 days. Nothing renews. After purchase, submit the Profile ID from your confirmation email at Extensions > Flookup Data Wrangler > Account Management > Profile activation. 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, AI Trial and Pass Work
The free tier starts immediately with no credit card. AI features include a 7-day AI trial, also with no credit card, and no payment is taken automatically when it ends. If you choose to continue, the 1-Month Pass is a one-time $1.99 payment for 30 days and the 1-Year Pass is a one-time $12 payment for 365 days; neither renews.
Install Flookup from the Google Workspace Marketplace and open it from the Extensions menu.
The free tier is active from install. The 7-day AI trial starts with it. No credit card is required and no payment is taken automatically.
Choose Google Gemini or OpenAI in the sidebar settings and paste the API key from your own account.
Buy the $1.99 1-Month Pass or the $12 1-Year Pass when you are ready. Each lasts its duration and does not renew.
| Plan | Trial | Trial cost | Licence cost | Seats | AI provider |
|---|---|---|---|---|---|
| 1-Month Pass | 7 days, AI features | Free, no card | $1.99 for 30 days | 1 | Your own key |
| 1-Year Pass | 7 days, AI features | Free, no card | $12 for 365 days | 1 | Your own key |
Free forever, no credit card. Every install includes the free tier. Match lookups show the match score while the value stays hidden, and duplicate removal plus unique listing need the pass. Menu tools include one 50 row menu run per day, up to 10 runs a month. Column profiling is free and read-only. The public demo spreadsheet runs every formula fully on sample data. AI features carry a 7-day AI trial with your own key, then need the pass like everything else.
The pass lasts 30 days and does not renew. One 50 row menu run per day, up to 10 runs a month, is included free. 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 and function names match what you get from Extensions > Flookup Data Wrangler in Google Sheets, with the layout simplified to keep the labels readable.
Click a cell then select a function.
Copyright 2026 Andrew Apell. All rights reserved.
Flookup Production Build 2864
Terms and Conditions
|
Privacy Policy
Flookup is active.
Google Gemini key saved. Nothing is metered and nothing is billed by Flookup.
0 / 300
How to Activate Your Licence
After purchasing a pass, activate it 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 through PayPal checkout and use an email address you can access. See Payment and 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. |
Trial and Licence Details
| Detail | Information |
|---|---|
| Free tier plus AI trial | The free tier starts at install with no credit card. AI features include a 7-day AI trial, also with no credit card. |
| What is charged | No payment is taken automatically during or after the trial. If you choose to continue, the 1-Month Pass is a one-time payment of $1.99 and the 1-Year Pass is a one-time payment of $12. |
| 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 licence. |
| Nothing renews | Each pass lasts its duration and does not renew. No further payment is required. |
| Buy when ready | Buy the 1-Month Pass or the 1-Year Pass on the pricing page. |
Payment and Checkout
Use the purchase link on the pricing page to open PayPal checkout. 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. |
| After payment | Check the confirmation email for your Profile ID and use it to activate your licence in Google Sheets. See our refund policy for refund terms. |
Checking Your Activation
You can check your licence state from the Flookup dashboard in Google Sheets.
| Step | What happens |
|---|---|
| Open the dashboard | In Google Sheets go to Extensions > Flookup Data Wrangler > Account Management > Dashboard. |
| Fetch status | Click Fetch status to refresh the displayed licence state. If it still looks wrong, contact us with your Profile ID. |
| Confirm and check | After submitting your Profile ID, return to the dashboard and click Fetch status to confirm your activation state. |
How to Troubleshoot Your Plan
- Whenever you switch to a different spreadsheet or create a new one, you must navigate to Extensions > Flookup Data Wrangler > Account Management > Dashboard and click the Fetch status button. This enables Flookup functions for that specific document.
- Reinstall Flookup on individual accounts, not domain-wide as an administrator.
- Make sure that you are only logged into one account during the installation process. If that is not the case, log out of all secondary accounts or switch to incognito mode and then reinstall Flookup.
- If Flookup is still inactive after following all these steps, please contact us for immediate assistance.
When Files Outgrow the Sheet
If jobs keep failing or the data cannot leave your computer, the desktop app runs the same cleaning modules locally on Windows.
Start with the add-on guide above, then move to the
desktop app
when files outgrow the sheet.