Calc: how to extract data from an Amazon page?

mirto · April 8, 2025, 5:32pm

Hi all,
I’m trying to get the product price from this Amazon page

https://www.amazon.it/UBIQUITI-USW-ULTRA-Ubiquiti-Switch-USW-Ultra/dp/B0CR1YNLXC?__mk_it_IT=%C3%85M%C3%85%C5%BD%C3%95%C3%91&crid=1GPANDG7YEQH3&dib=eyJ2IjoiMSJ9.au56subTtpZe-Mzkb9eNi-yrNbyhH_swYSvKVMUtpkCoSSYur-L9ajC0-5Sk1TaQxVG3hJZf6e98mR8Cvf7M369hbH3wl9jM1uwCCOeyWVWpMA3fY8X45_eBMEchyPbTF9VdvL7YsOL0PoPrJymS63_rP1RlC1K4E0g2GVdWDmLcVnqGNjJprgo8SH103Th_qvlXBEs3BviLsCiKC44u61RTuqJBm1-5DPBsrB_7kotFqty7l_VqLJAAw833NSzXEp5fI41bVsdBFJUX4RPzHVyxQP3AH0Ze9Ui98t-5y9w.-Mgs6g4B_uThA-BspOPEcE8WdcFz2hQZlwYYFC6zRxs&dib_tag=se&keywords=unifi+switch&qid=1744132134&sprefix=unify+switch%2Caps%2C101&sr=8-6

As the first step I tried to get the page using the WEBSERVICE function (that works for other pages) but with this page gives a #VALUE! error

How can I extract data from an Amazon page?

Villeroy · April 8, 2025, 5:44pm

fpy · April 8, 2025, 5:49pm

no magic to expect here, you’ll have to enjoy a learning curve about Web scraping - Wikipedia

Calc probably not being the simplest step, rather lookup for python+scraping+tutorial …

ps.
I doubt the link to a 9-yo github will lead you anywhere

mirto · April 8, 2025, 6:33pm

If I understand correctly, to have Amazon data in calc I have to follow a two step process

scrape Amazon to extract data and save data in a format calc can import
in calc use link to the external saved data

Correct?

fpy · April 8, 2025, 7:20pm

somehow.

many other “steps” would also be possible, will depend on your use case(s).

anyhow, make sure you get familiar/comfortable with jargon like : Deprecation of Feeds API support for XML and Flat File Listings Feeds

shantanuo · April 9, 2025, 6:37am

Any luck with LLM?

mirto · April 9, 2025, 8:56am

Never tried
I’m afraid of the steep learning curve