Building a Find Companies Table Using SERP Tools and Keywords

Has anyone built a “find companies” table that leverages Google Search, SerpAPI, or similar services to generate SERP results based on specific keywords and locations…? I’m having issues integrating my SerpAPI results to clay. I’m aiming to create a list of businesses by searching terms like “roofing companies near me” and extracting company names from links found on Page 2 and beyond. Any insights or examples would be greatly appreciated! I’ve done a bit of research into it online and seems there aren’t too many resources on this…