What Do the Flookup Error Messages Mean?

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

    • !NullValue: You normalised a list and your function parameters caused the contents of this cell to be deleted.

    • !NoMatchFound: No results were found to match the criteria you entered.

    • !RankError: You entered an invalid "rank" i.e. a value that is less than one.

    • !ThresholdError: You entered a "Threshold" value that is less than zero or greater than one.

    • !IndexError: You entered invalid values for the lookup column or the column from which values are to be returned.

    • !InvalidOperation: This function is not available for the subscription plan you are currently on.

    • !SubscriptionInactive: Your trial period has ended, your paid subscription has expired or you are using a new account and have not yet subscribed.

Please note that these error messages are specific to Flookup and separate from the default Google Sheets error messages.

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:

    • Remove your spreadsheet from any shared folder in which it might be located.

    • Make sure that you are the creator of the spreadsheet you are using. If this is not the case, simply reinstall Flookup in a spreadsheet you created with your "Subscriber Email Address".

    • If you are logged into multiple accounts at the same time, Flookup might not authenticate correctly. Please ensure that you are only logged into the account you used to create that spreadsheet. You can read more about these limitations here.

Do not forget to click the "Update status" button, located at Extensions > Flookup > About Flookup, 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.

    • See, edit, create, and delete your spreadsheets in Google Drive: This allows Flookup to read from and write to the spreadsheets found in your Google Drive; spreadsheets in which you have installed and activated the add-on. Flookup cannot process data from any spreadsheet that you have not given it explicit permission to access.

    • View your primary email address: Flookup accesses your email address strictly for the purposes managing your subscription.

    • Display and run third-party web content in prompts and sidebars inside Google applications: Flookup displays prompts to communicate important messages or to initiate certain functions. This scope is necessary to accomplish that.

    • Connect to an external service: Flookup connects to a database within Google's ecosystem to store and retrieve subscription information. This information includes your email address, amount you paid, and the subscription plan you are on.

These are the only permissions that Flookup requests and they are viewable during the installation process. Should any of these change in future, we shall update the above information accordingly. To view our full website and add-on privacy policy, please click here.

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:

    • Do Flookup developers view spreadsheet data? No. It is our policy not to track users or usage patterns outside the script execution metrics [successes and failures] that Google provides by default.

    • Does Flookup store the spreadsheet data it processes? No, Flookup does not retain any spreadsheet data it processes; we do not have any need to do so. All data is stored on the user's spreadsheet.

    • Does Flookup share spreadsheet data with third party agents? No, Flookup does not share spreadsheet data to anyone. Your data is exclusively processed on the Google Apps Script server and stored in your spreadsheet.

    • How does Support treat data that is shared for with them? Any spreadsheet data you share with us for additional support is immediately deleted from our records after the reason for sharing it has been resolved. We do not retain such data for any other purpose.

Is My Spreadsheet Data 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 About GDPR?

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.