Frequently Asked Questions
Data is saved 24 hours by default. To change the behaviour, you have two options, available only from the Premium plan:
- 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)
- 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”)
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.
Premium and High Volume plans offer the cacheLifespan option to customize the period during which the data is kept into the cache.
That said, you can always choose to update the data by yourself by pushing “Update content” in the sidebar (Actions screen) or the menu.
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.
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.
- In Google Sheets, open the apps manager from the menu Add-ons > Manage add-ons,
- click on “Uninstall” as described in the screenshot.
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.
From Google Sheets,
Go to Add-ons > ImportJSON > 🛠 Open Sidebar
Then select the Profile tab and click on “Manage your account”
Finally click on “Add a payment method” and enter your details
All the process is managed through Stripe, one of the leading payment platforms of the market.
We cannot view your card details.
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 😉
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.
Just contact us here and provide information about your requirements
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 directly from the add-on sidebar. Go to the Profile tab and click on Manage your account.
If you need to downgrade or have specific requirements, you can also fill the form here.
This is usually caused because Google limits the number of external requests you can send in one day (by using the appsScript UrlFetch function).
Free Google Workspace accounts are given 20,000 requests per day.
This is not exactly related to the number of ImportJSON functions you use:
If you have many ImportJSON functions, the spreadsheet cache is not big enough so it temporarily keeps the data on our server.
If you edit the spreadsheet, Google Sheets triggers recalculations pretty often and the functions use UrlFetch to get the cached data from our servers.
It’s a daily quota. Unfortunately, Google doesn’t give more details on what time it will reset the quota.
- Try to lower the number of functions in your spreadsheet. ImportFromWeb allows you to fetch a range of URLs in one function. You can also put a range of selectors if you need to fetch several elements from the target pages.
- The UrlFetch limit goes up to 100,000/day with Google Workspace paid accounts.
- If you use many functions in one spreadsheet, try to limit your activity in the spreadsheet so Google Sheets does not trigger recalculations so often.
More information about Google quotas is available here
The error #MONTHLY_QUOTA_REACHED means that you have reached your quota of requests for the month.
You can check the current status in the sidebar:
You can have a look at our plans here.
In general, if you use a new spreadsheet, you will need to activate the add-on through the Google Sheets menu > Add-ons > ImportJSON > Activate add-on
If it doesn’t load the function, try to enable the add-on through the Add-ons manager in the Google Sheets menu > Add-ons > Manage add-ons.
Find the add-on in the list and uncheck / check again the option “Use in this document”
Google Sheets can have troubles to manage sessions with multiple accounts. Try to keep only one session on when you use Google Sheets add-on or log in to your Google account connected to the add-on from a new Incognito window.
You can find more information on how the issue affects G suite add-ons here.
… or the previous tricks 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.
Don’t forget to reload your spreadsheet too.
If you followed all the steps with no success, please contact us.