FREQUENTLY ASKED QUESTIONS

What Limitations Does Each Flookup Plan Have?

During your free trial, you can access all Flookup functions. However, the Long Run Mode (LRM) functions, highlighting duplicates, removing duplicates and extracting unique values will timeout after 60 seconds.

After you subscribe however, this timeout allowance will extend to 240 seconds for "Flookup Standard" and 360 seconds for "Flookup Professional". This means you will potentially process 5 times more data for each function execution and, thus, get more work done.

Custom functions that are activated by typing formulas directly into a spreadsheet cell, are not affected by this policy and they will, therefore, continue to timeout after 30 seconds as per Google's policy.

Future updates will introduce an unlimited runtime for menu functions, so please stay tuned.

What Do the Flookup Error Messages Mean?

This is the full list of the default error messages you might encounter while using Flookup. None of them are severe and they will, therefore, not cause any loss of data.

How Do I Troubleshoot My Subscription?

In the event that your subscription is not active, simply try any [if not all] of the following troubleshooting steps. Be sure to click the "Update status" button, located at Extensions > Flookup > Build and status, after trying any of these steps:

What OAuth Scopes Does Flookup Request?

All add-ons that request certain sensitive OAuth scopes are subject to verification by Google.

Below is a list of the OAuth scopes that we were granted permission to use, after successfully completing the above verification, and how we use them.

How Secure Is My Spreadsheet Data?

We take the security of your data seriously and have therefore built Flookup to be as secure as possible. As fellow netizens, we ensure that our clients enjoy the same levels of privacy and confidentiality we have come to expect and demand ourselves. Here are three questions to help us address this concern:

Is Data Stored in My Spreadsheet Encrypted?

Whereas data transmitted between your spreadsheet and the Google Apps Script server is fully encrypted, data stored on your Google Sheets spreadsheet is not encrypted by default. It is, however, secured by your Google account password, meaning that only those you share that data with or those who have your login credentials, can view the same.

To learn how to encrypt your Google Docs, please click here.

How Is General Data Protection Regulation [GDPR] Handled?

Flookup itself is fully GDPR compliant. It also uses Google Cloud services that fully meet GDPR requirements.

To quote Google directly:

Where personal data will be transferred outside of the EU to third countries not covered by adequacy decisions, we commit under our data processing agreements to maintain a mechanism that will facilitate these transfers as required by the GDPR. In 2017, we gained confirmation of compliance from European Data Protection Authorities for our standard contract clauses, affirming that our contractual commitments for Google Workspace and Google Cloud Platform met the requirements to legally frame transfers of personal data from the EU to the third countries that do not provide adequate protection.

If you would like to learn more about Google Cloud services and GDPR, please click here.

How Do I Cancel My Paid Subscription?

In order to cancel your subscription, you have to use the in-app interface.

Simply navigate to the secure form located within the spreadsheet menu at Extensions > Flookup > Manage Subscription > Cancel Subscription, then enter your “Subscriber Email Address” and “Profile ID” before submitting the form.

You can get your "Profile ID" from any payment confirmation email you received from PayPal or welcome email you received from us.

If the form displays an error message instead, please contact us immediately.