Bulk Google Search for Local Billboard Agencies in the US

Question for the group - does anyone know how to do a bulk google search in clay? What I’m trying to solve for is finding local billboard advertising agencies in the US. I was planning to basically run the search query “local billboard advertising agencies {insert city, state} by the top 1000 cities in each state. But to manually search each city/state takes a ton of time. I was hoping to input a csv file with all the search queries if possible…also open to other creative prospecting approaches here!