IMPORTXML in Google Sheets: Pull Website Data into Spreadsheets

The Google Sheets IMPORTXML allows you to pull data in from other websites. The function imports data from various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

The syntax of the formula requires a URL and xpath_query to run on the structured data.

As a note: if you're having issues, many websites have anti-scraping measures or are dynamically generated by javascript which block this function from working.

Video Timeline
0:00: Introduction to IMPORTXML
0:19: Why You Might Be Having IMPORTXML Issues
0:51: Pulling Data with the IMPORTXML Formula
4:00: Using Inspect to Copy XML Path

Any questions? Comment below; we have Google Sheets experts on the other side.

#googlesheets #googlesheetstutorial #xml #importxml #coefficient

[mmaammn]

Is it possible to just scrape a specific word which is also a link on the website over to sheets? when i try it keeps saying imported data is empty

[chrisder]

hello I have two ideas, could this allow me to recover the data from my Amazon seller account and recover the titles of certain public YouTube videos?

new:
Do you use no code software like make?

In fact I'm asking myself questions to try to understand the differences between custom GPT, chrome and WordPress extensions, automation software like browser automation studio and make

I had an idea of ​​creating an SEO and image editing but I don't know how to go about it I thought of several solutions either with make or by creating a Chrome or WordPress plugin or by using a existing plugin but I don't think it exists to do what I want or even with a custom GPT

seo:
OK and what do you think about rank math?

I understand that this extension allows me to scan my pages and find the keywords to replace, from my back end, have I understood correctly?
And I also understood that this does not allow me to ask it to scan my entire website?
I mean if I understood correctly it scans the pages but one by one and I have to do everything by hand?

This is why I wondered if I could not create an extension to which I would give the URL of my website and have it scan all the pages and tell me which keywords to replace
And I even wondered if I wouldn't be able to make a robot with custom GPT or even with no code software like make in the case where an extension wouldn't be able to allow me to do it, does this idea seem good to you?


do you also create chrome or WordPress extensions?
I'm asking you this question because I'm trying to understand what I could do with custom GPT, could I do more with a chrome WordPress extension? Does it exist or not and finally what more can I do with it? make compared to its other methods

Amazon, jungle scout
I would like to use the jungle scout api but at the moment I am looking into the subject of artificial intelligence and I realized that there are several ways to use APIs and so I would like to try first to understand what is the difference between using the jungle scout api in a dent custom gpt action and I realized that I can also use the JS api in a make scenario
Could you tell me what the difference is, what could I get, using either of these two methods?

And also with the Amazon API?
I understand that Amazon has several APIs?

Do you also sell on several marketplaces?

could you give me your opinion

could I send you an email

[cgc]

hello I'm selling Amazon, do you think I could retrieve my sales history in a Google sheet?

[giangpham-wpnk]

Hello ! i want to import tronscan to google sheet, i’m using importxml but cell recognised, plz help me. thanks u

[chrisder]

yes I tried the import XML function but it doesn't work, do I need to create an API key first?

[dylanhuston]

what do you do if there is no option that lets you copy the full Xpath? Im on MacBook Air and it only allows for "copy Xpath"

[mowe]

I am using importxml and pulling prices from the web but the cell is not recognised as a number when I sum it with another cell. 🤔 any work around or is it something to do with where it has come from ?

[theDemolisher]

Question how would I import price data from a storefront site while they have a size & quantity options that could effect the price?