Frequently Asked Questions

Features

Do I need to know XPaths to use ImportFromWeb?

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

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 =IMPORTFROMWEB_meta(ref_to_your_ImportFromWeb_formula, “updateTime”) and =IMPORTFROMWEB_meta(ref_to_your_ImportFromWeb_formula, “updateDate”)

What means rendering Javascript content?

More and more websites require Javascript to load the page content. However, basic web scrapers don’t know how to render Javascript pages.
ImportFromWeb allows you to scrape pages with complex architectures by opening the page in a real browser under the hood with the jsRendering option

What is Smart caching?

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.

What are rotating proxies

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.

What is a request?

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.

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 =IMPORTFROMWEB() 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 ImportFromWeb 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.