Import Webpage Data into Google Sheets Using IMPORTXML

Learn how to pull XML structured data such as HTML, CSV, TSV, RSS, and ATOM feeds into your spreadsheet. You will see an example with federal holidays and one with hyperlinks.

Timestamps:
0:00 Intro
0:25 Import Federal Holidays
1:07 URL
3:30 Finding the XPath
5:05 Import a list of hyperlinks
6:11 Playlist of Date Functions

#googlesheets #importxml #webscraping

[BallBusta]

Good tutorial. Thanks for the heads up on "#N/A – Could not fetch URL" error, I've been seeing that a lot when trying to scrape from various sites and this tutorial was the only one that said, "yea, you're going to need to find a different source because reasons".

[chrisder]

hello could this allow me to recover the titles of public YouTube videos and also to recover data from my Amazon seller account

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

[bitchslapper]

When double-clicking in the cell I do not see the entire function. What am I doing wrong?