How to Install and Activate Flookup
Installing Flookup
-
Temporarily log out of any other secondary Google accounts.
If you do not do this, Flookup might connect to the wrong Google account. 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 nothing to download or install on your computer.
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.
Permissions We Request from You
| Permission Granted by Google | Why We Need It |
|---|---|
| See, edit, create and delete all your Google Sheets spreadsheets | This lets Flookup read, change and write data in your spreadsheet when you run a cleaning job or start a scheduled job. Scheduled jobs can update the ranges you chose while you are away. |
| Allow this application to run when you are not present | This lets Flookup run cleaning jobs on a schedule, so your data stays current without you starting each one. |
| Display and run third-party web content in prompts and sidebars | This lets Flookup show its sidebar and dialogs inside Google Sheets. |
| Connect to an external service | This lets Flookup check your purchase and connect to AI and data services. We store only the payment details needed to confirm your purchase and support you. |
| See your primary email address and any public personal information | Your email address identifies your account and starts the pass you buy. We store the payment details needed to confirm it and support you: the payment ID, product and plan, amount, currency, time and the account it belongs to, as described in the Privacy Policy. |
How to Use Flookup
After installation, open your spreadsheet and use Flookup from Extensions > Flookup Data Wrangler.
- Review the workflow. Read the custom functions and documentation overview to see the inputs, outputs and examples.
- Start the trial. Open Subscription Management > Dashboard and click Fetch status to start your trial. No credit card is required.
- Work on your data. Use custom functions in cells, open the Sheets AI Assistant for formula help, use Data Connectors for external data and run Data Cleaning Automation for larger jobs.
Trial, Pass and Checkout
The trial starts in Subscription Management > Dashboard > Fetch status. If you continue after the trial, buy a pass on the pricing page. Payments are processed by PayPal checkout and the pass activates on the email address you pay with, so use the Google account email you use in Sheets. Review the amount, currency and any additional charges shown before confirming. Your confirmation email is the receipt; see the refund policy for refund terms.
To check your status later, open Subscription Management > Dashboard and click Fetch status. If it still looks wrong, contact us with the Google account email address you paid with.
Troubleshooting
- If Flookup is not active in a spreadsheet, open Extensions > Flookup Data Wrangler > Subscription Management > Dashboard and click Fetch status.
- Install Flookup on individual accounts, not domain-wide as an administrator.
- During installation, use only one Google account. If needed, sign out of secondary accounts or use an incognito window, then reinstall.
- For large jobs that hit run limits, split the data or use Data Cleaning Automation.
- To work with external records, use Data Connectors and follow the setup steps for Airtable, SQL or Salesforce.
- If the issue remains, contact us with your Google account email address and the affected spreadsheet details.