Hey guys, I'm having some problems regarding the setup of an automation data extraction.
I will try to explain in the best possible way, if not enough info is offered i will edit the main post as requested in order to clear the goal.
The main goal : From a website with N sections, to select one (by me). The selected section has Y items on Z pages.
Questions :
The website is : https://xyz.como/supermarket/supermarket
For this example i will choose the first section : //xyz.com/supermarket/bio/#1
There are more than 8 pages with products.
1) How i can access each item (Y) from each Page (z) and how do i know how to stop?
2) From the items i will download the Picture, extract the name , price and some values from the second tab.The problem is :
From the second available tab named : "Products", i retrieve every info as a full sentence. How i can retrieve each data as a table like presented in the website table?
The main goal is for each item to create a new Sheet, doesn't matter the name Sheet(n) with the following data:
Thank you for your time,
I've attached the file in order to see the progress.
Bookmarks