Q: Scraping and enriching data
Can this be use to accomplish the following?
Workflow:
1. I provide the product link in Gsheets (column a)
2. It gathers the following data columns
-Manufacturer
-Product Name
-Price
-Features
-Description
-Specs
-Download product images and video to Gdrive folder for each product.
Not every product has these specific fields of information so it would be up to an AI model to decide where to fill in each column of information.
Curran35278
Mar 5, 2025A: Best way to do this would probably be to scrape the whole page using =visit() function and then use the =aitext() function on the scraped page to try to find that info.
The download of project images directly to GDrive is not a thing that SheetMagic does though, but it can grab all the images from a page if you want and give you the link.
mikeg