EVERYTHING YOU NEED TO GET STARTED

On This Page

Getting Started with Flookup

This guide will walk you through installing the Google Sheets add-on and activating your Flookup plan. Flookup is a powerful data cleaning add-on.
To explore our premium custom functions before purchasing, you can use our interactive Demo Sheet. For more advanced topics, visit our detailed documentation and blog.

Installing Flookup

  1. 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.
  2. On your computer, open the Google Sheets spreadsheet in which you want to install Flookup.
  3. In the menu, click Extensions > Add-ons > Get add-ons.
  4. In the new window, search for "Flookup" or "Flookup Data Wrangler" and click on it.
  5. Click the "Install" button and then the "Continue" button.
  6. To allow Flookup to work, read the important "Request access" message and then click the "Allow" button.
  7. 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.

Core vs Premium Features

Flookup provides a mix of accessible tools and premium features.

Menu Functions [GUI-based]

The easiest way to start is with our menu-driven tools, found by navigating to Extensions > Flookup Data Wrangler in your spreadsheet menu.
These provide a simple interface for complex tasks right inside the Google Sheets sidebar and are available for use.

Custom Functions [Formula-based]

For more advanced control, our custom functions i.e. cell-based formulas, offer unparalleled flexibility. These are premium features. The Demo Sheet is the perfect environment to assess formulas like FLOOKUP, NORMALIZE and SOUNDMATCH without affecting your own data.
For a comprehensive guide, see the full list of custom functions and to view the Demo Sheet directly, click here.

How to Activate a Paid Plan

  1. Head to our pricing page and click the purchase button to get the paid plan.
  2. Follow the prompts on our secure checkout page to complete your purchase.
  3. After payment, check your email for a confirmation that contains your unique Profile ID.
  4. Return to your spreadsheet and navigate to Extensions > Flookup Data Wrangler > Manage your subscription > Profile activation.
  5. Submit your Profile ID to instantly unlock all features. You only need to do this once for each new purchase.

How to Troubleshoot Your Plan