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. - On your computer, open 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" and click on it.
- Click the "Install" button and then the "Continue" button.
- Install the Flookup Data Wrangler add-on from the Google Workspace Marketplace.
- 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 data cleaning functions.
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 data cleaning tasks, which run at specified intervals.
This ensures 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 license verification and to enable 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 license management.
Your personal information is never shared, as detailed in our Privacy Policy. |
How to Use Flookup
Flookup is designed to help you reconcile and clean data in minutes rather than hours, with fewer manual errors and more consistent results. The most reliable way to assess fit is to see the result first, then to test the complete product on your own data, then to retain it only if it proves suitable for your work. Fees and credit allowances are shown only on the pricing page.
Flookup provides two complementary modes.
Data Cleaning Tools run from the sidebar at Extensions > Flookup Data Wrangler > Data Cleaning Tools for full workflows such as fuzzy matching, deduplication and standardisation.
Data Cleaning Spreadsheet Formulas are typed directly into a cell for quick lookups and spot checks, including FLOOKUP, FUZZYSIM, DEDUPE and ULIST. The documentation overview explains each in detail.
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 Data Cleaning Tools.
Test on your own data with full capability
When you are ready to test on your own data, use the Weekly Access pass. It provides the full product for 7 days and 1,000 credits, each credit is approximately one row processed. Every feature is enabled including fuzzy matching at any threshold, deduplication, standardisation, scheduled automation, workflow templates and Sheets AI Assistant. It is a single purchase with no auto renewal and nothing to cancel. It is not a restricted preview. You test with the same capability you retain after purchase. See the pricing page for the current fee.
Many free plans limit rows and reserve features for paid tiers. The Weekly Access pass lets you evaluate without that limitation.
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.
Your purchase is protected. Every payment is processed by PayPal and may be eligible for PayPal Buyer Protection. If a purchase does not arrive or is materially defective, PayPal may provide a refund under its own rules. Please contact us first, as direct resolution is usually faster.
If a defect on our side prevents Flookup from working as described or if a billing error occurs, we will review a request made within 14 days of purchase. Where a refund is approved, funds are returned to the original payment method within 5 to 7 business days. Change of mind after delivery is not covered, as access is granted instantly. This is why a short term full access pass is offered for testing. Full terms are in the refund policy.
How to Activate Your Paid Plan
After purchasing the Weekly Access plan 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 license 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