Everything You Need to Get Started
On This Page
Installing Flookup
- Temporarily log out of any other secondary Google accounts.
If you do not do this, Flookup might fail to authenticate correctly. Please click here to learn more. - 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 without manual intervention to ensure your data remains current. |
| 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 Try Flookup
The most effective way to evaluate Flookup is through our live demo spreadsheet. The demo provides hands-on access to every custom function with real examples, allowing you to see exactly how the tools work on actual data before you install anything. Most users find that the demo gives them the confidence they need to make an informed decision.
| What You Get | Details |
|---|---|
| Interactive Exploration | Modify parameters, adjust similarity thresholds and observe how results change in real time. The demo covers =FLOOKUP, =NORMALIZE, =DEDUPE, =FUZZYSIM and other functions with working examples. |
| No Installation Required | Access the demo immediately as a standalone Google Sheet. No add-on installation, account creation or payment information needed. The fastest way to evaluate whether Flookup meets your requirements. |
| Complete Function Coverage | Every custom function from the paid plan is demonstrated. See fuzzy matching with different thresholds, deduplication of near-duplicates, text normalisation and other capabilities across the full range of tools. |
| Realistic Datasets | The demo uses data that mirrors common challenges: messy customer names, inconsistent addresses, duplicate records and typical data quality issues you will encounter in production. |
| Next Steps | If the demo confirms Flookup is right for your needs, installation takes under five minutes. Follow the instructions above to add the extension, then apply the same functions to your own datasets. Start with a small subset before processing larger volumes. |
How to Activate Your Paid Plan
| Step | Action |
|---|---|
| Choose a plan | Visit our pricing page and select a plan. |
| Complete purchase | Follow the prompts on our secure checkout page. |
| Check your email | After payment, check your email for a confirmation that contains your unique Profile ID. |
| Activate in Sheets | Return to your spreadsheet and navigate to Extensions > Flookup Data Wrangler > Account management > Profile activation. |
| Submit Profile ID | Submit your Profile ID to unlock your plan. Your plan unlocks unlimited custom functions, schedule functions and the Spreadsheet solver for the duration of your access period. When the plan expires, functions revert to locked status. |
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.