Questions About Flookup

Do Flookup developers view user data?

    • No, it is our policy not track users or usage patterns outside the script execution data (successes and failures) that Google provides by default.

Does Flookup transmit spreadsheet data to any third party?

    • No, Flookup does not transmit spreadsheet data to anyone.

Does Flookup store the spreadsheet data it processes?

    • No, Flookup does not store any spreadsheet data it processes; we do not have any need to do so.

Flookup Permissions

Add-ons that request certain sensitive OAuth scopes (permissions) are subject to verification by Google.

Quote from Google: "By verifying your app with Google, you can remove the unverified app screen from your authorization flow and give your users confidence that your app is non-malicious."

Below is a list of the OAuth scopes that we were granted permission to use with Flookup (after completing the said verification) and a brief description of how we use them:

View your email address

    • Flookup views your email address strictly for the purposes managing your subscription.

Connect to an external service

    • Flookup connects to a database within Google's ecosystem (https://firebase.google.com) to store subscription information. This information, which is retrieved from PayPal, includes your email address, amount you paid and the subscription plan you are on.

Display and run third-party web content in prompts and sidebars inside Google applications

    • Flookup has functions that display prompts to communicate important messages to you or to initiate certain functions. This scope is necessary to accomplish that.

See, edit, create, and delete your spreadsheets in Google Drive

    • This prepares Flookup to read from and write to the spreadsheets found in your Google Drive, 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.

Common Spreadsheet Errors

Flookup error messages

  • $SubInactive: Your 24-hour trial period has ended or your subscription has expired.

  • $FunctionNotAvailable: This function is restricted for the plan you are currently on.

  • $FormulaError: There is an error in the formula you entered.

  • $NoResultFound: No results were found to match the criteria you entered.

  • #ERROR: Google Sheets experienced a runtime error.

Internal error executing the custom function

    • This error means that the function timed out, given that Google only allows 1 minute of execution for custom functions. Reducing workloads usually resolves the issue.

Service invoked too many times in a short time: exec qps

    • Try entering a range as an argument, instead of entering a single cell. Please see the Documentation to find out how.