Efficiently searching keywords on company sites: Is there a better way?

Hi there, Im searching for keywords on company sites, and Im sure there must be a more efficient way than the way Im doing it. Ive done a site-map search for pages that are likely to contain the keyword. I then have a scrape website column that scrapes homepage, then a find keywords column, after that there is another scrape website column, that scrapes the first result from the site-map column and only runs if there was no keyword found on the homepage, I then repeat those last 2 but with the second result from the site-map and only runs if no keywords were found on both the homepage and the first result from the sitemap. I hope that makes sense, and is there a better way to have all that logic contained within 1 scrape website/find keyword column, or am I doing it the right way? Thanks.