A list of local businesses with contacts

You set queries and cities in a spreadsheet, and the scenario finds businesses on maps and collects their emails — as rows back in the spreadsheet.

• Searches businesses by query and city
• Visits sites and pulls out emails
• Puts contacts into a spreadsheet
• Marks what's done to avoid repeats

Google Sheets