Frequently Asked Questions

Features

How to control when the data updates

Data is saved 24 hours by default. To change the behaviour, you have two options, available only from the Premium plan:

  1. Use the cacheLifespan option: You set a number of hours the cache will keep the data. Beware that although the cache will be emptied, Google Sheets doesn’t refresh the function all the time. The new data will be fetched only when Google Sheets executes the function again. (it can be when you edit or open the spreadsheet)
  2. You set up an automatic updates trigger: The trigger will force the function to execute and will fetch the data at the frequency you’ve defined. Even though the spreadsheet is closed

You can know the last time the data was fetched through the Monitor tab in the sidebar or by using =IMPORTJSON_meta(ref_to_your_ImportJSON_formula, “updateTime”) and =IMPORTJSON_meta(ref_to_your_ImportJSON_formula, “updateDate”)

What is a request?

The function counts a request when it manages to fetch a JSON from the target url. For instance, if fetching the content fails or if there is no element in the JSON that matches the filters, no request will be counted.
The JSON is cached by default for 24 hours. Therefore, until the cache expires, using the same url in other IMPORTJSON functions will retrieve the cached JSON and these operations will not be counted as new requests.

In the upcoming weeks, some plans will have a new feature to update the data in the background, so you will be able to see fresh data when you load your spreadsheet.

That said, you can always choose to update the data by yourself by pushing “Update content” in the sidebar or the menu.

What is Smart caching?

Fetching the same content constantly is not efficient. That is why ImportJSON caches the source code once loaded with the expected data.
By default, cache has a lifetime of 24 hours. Some plans allow to customize this value with the cacheLifespan option.

Caching occurs only when the content has been fetched successfully or after the function tried too many times and failed.

Installation

How can I uninstall a Google Sheets add-on?

If you are the administrator of a Google Suite domain and have installed the add-on for the whole domain, got to the second part.

Uninstall the add-on installed for individual use

  • In Google Sheets, open the apps manager from the menu Add-ons > Manage add-ons,
  • click on “Uninstall” as described in the screenshot.

Uninstall the add-on for your Google Suite domain

If are the administrator of a premium Google Suite account and have installed the app for your whole domain, you will have to follow the following steps.
Otherwise, the administrator of the domain should be able to do it.

  • From Google.com, display the services from the top right button
  • Select “Admin”
  • From the admin console, select “Apps”
  • From the Apps panel, select “Marketplace Apps”
  • A list should display the add-ons installed for the domain. Click on the add-on you want to uninstall
  • On the top right corner you should see a button with a trash icon. Click on it and confirm removal.

Note that we have no way to be aware that you uninstalled the add-on. Don’t get mad if you keep receiving our email notifications. Just unsubscribe or send us a message.

Issues

When I write =IMPORTJSON() in a cell, it shows the error #NAME?

I use multiple Google accounts in parallel

Google Sheets can have troubles to manage Chrome sessions with multiple accounts. Try to keep only one session on when you use Google Sheets add-on

I don’t use multiple Google accounts

… or the previous trip did not work.

Try a clean install:
Go to https://myaccount.google.com/permissions and remove the add-on from the lists.

Then go to the add-on page in the G Suite Marketplace, click Uninstall and reinstall it again.

If you followed all the steps with no success, please contact us.

Subscription

What happens if I find that ImportJSON is not for me.

Don’t worry, you’re in good hands! The only thing that counts for us is happy customers.
We give you the maximum guarantees to ensure that you will like the tool. Therefore we offer you a 7-day money back guarantee.
Not happy with the product? Just tell us within 7 days and we will refund your payment.

Check out the reviews in the G Suite Marketplace, you will find out that we care a lot about our customers 😉

How can I pay?

For the moment we only accept payments using credit card. Your payments are processed securely by Stripe, an international reference for payment collection. You will be charged straight after you subscribe to a paid plan and then every month/year according to the selected periodicity.

Your credit card will be automatically charged at the interval you select until you choose to unsubscribe.

We never see or store your credit card details.

What if I need more requests or if I have special requirements ?

Just contact us here and provide information about your requirements

How can I unsubscribe or downgrade?

You can decide to unsubscribe at any moment. At that point, your subscription will last until the end of the current billing cycle, which will depend on whether you chose yearly or monthly payments.

You can unsubscribe or downgrade by filling the form here

Can I use ImportFromWeb for free?

Absolutely! Our Free plan provides the main features of ImportFromWeb at no cost and for unlimited time. The main limits of the plan is that you will be limited to 100 requests per month.