Help with web scrap data

With the web scraping, as long as the product is listed on the site it will create data.

Site A product this there grabs link
Site B product not there No data no link.
Site C product listed Link

So realisticly it could be like 5950x [Site A URL] [Site B No Data No URL] [Site C URL]
Also not every product has numbers so can I do the same Insert Number rows numbers for Text?
That would solve the last issue I’m having.

thanks Daniel this is extremely helpful!