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.
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 is required for Flookup to read, modify and write data within your spreadsheets as part of its core cleaning functions, and we do not access or alter data without your explicit action. |
| 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 APIs. All connections are secure and encrypted. |
| See your primary email address and any public personal information | Your email address is used strictly for account identification and licence management. Your personal information is never shared, as detailed in our 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
and does not demonstrate the sidebar Standard Data Cleaning.
|
| Test on your own data with full capability | When you are ready to test on your own data, use the Week Pass. It provides the full product for seven days and 1,000 rows, and every threshold, automation and AI workflow is unlocked from the start. It is a single $1.99 payment with no renewal and nothing to cancel. You test with the same capability you would retain with Data Nova, so the work you do in those seven days is not thrown away. Many free trials limit rows and hold features back. Here you see the actual result on your own sheet before you decide. |
| Retain permanently when it proves suitable | Data Nova is a one-time purchase with credits that never expire. 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. There are no recurring charges. |
Payments are processed by PayPal and may be eligible for PayPal Buyer Protection. 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 seven-day pass 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, no auto-renewal and no subscription to manage.
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 checkout page. Enter any email address. If you do not have a PayPal account, you will be taken straight to the secure card payment form. If you do have one, you can log in to pay that way too. |
| 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. |
One-Time Purchase, No Expiry
| Detail | Information |
|---|---|
| One-time purchase | Data Nova is a one-time purchase. You will only be charged once per purchase. |
| No expiry | Your licence never expires. Credits never expire either, so they sit waiting until you actually need them. |
| No auto-renewal | Data Nova does not auto-renew, so there are no recurring charges and nothing to cancel. |
| Purchase again when ready | If you need more credits, simply purchase a new plan on the pricing page. |
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.
Last updated: August 2026