Frequently Asked Questions
No! You can use CSS selectors instead.
While XPaths offers more flexibility and allows more complex queries, CSS selectors are known by most people who have basics in HTML/CSS.
If you are unsure of how to use CSS selectors, you can read this excellent guide from CSS-Tricks
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 =IMPORTFROMWEB_meta(ref_to_your_ImportFromWeb_formula, “updateTime”) and =IMPORTFROMWEB_meta(ref_to_your_ImportFromWeb_formula, “updateDate”)
ImportFromWeb allows you to scrape pages with complex architectures by opening the page in a real browser under the hood with the jsRendering option
Fetching the same content constantly is not efficient. That is why ImportFromWeb 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.
Because the function does not work as a human, in many cases, it may need proxy servers to fetch the web pages from different IP adresses to ensure it loads the page correctly. This mechanism is called proxy rotation and is one of the biggest features of ImportFromWeb.
The function counts a request when it manages to fetch content from the source page. For instance, if fetching the page content fails or if there is no element on the page that matches the selectors, no request will be counted.
The source code of the page is cached by default for 24 hours. Therefore, until the cache expires, using the same url in other IMPORTFROMWEB functions will retrieve the cached source code and these operations will not be counted as new requests.
From the Premium plan data can be updated periodically in the background so you will see fresh data when you load your spreadsheet.
You can always choose to update the data by yourself by pushing “Update content from web” in the sidebar or the menu.
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.
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 or downgrade by filling the form here
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.
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:
We offer 100 free requests per month. Some people might find it enough, others may need more requests and may be interested in other special features.
If that is your case, you can have a look at our plans here.
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 trick 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.