Need Help: AI Agent to Find Local Businesses 'Google' & Export Emails to Sheets

[goekhan_celik]

Hello everyone,

I have a question and would appreciate some tips. I’m looking for a ready-made workflow or some information. I want a workflow where an AI agent, based on a given industry or a provided link for example, “Hairdressers Cologne” collects all hairdressers in the nearby area and lists all their contact details, especially email addresses, in Google Sheets. Can you help me with that? I’ve tried many things but haven’t found a working solution yet. In the German-speaking area, there is very little available when it comes to AI.

Thanks for you support guys <3

[nabossha]

Hi, I can help you with that, even in German if that will make it easier for you or look here for the German Discord Community: German Community - #33 by martin86xxx

here is a quick outline of how I already implemented a similar task:

• AI agent
• MCP Tool for querying Google Places API (you need a GCP project for that with active billing)
• with that tool you can search places around a given location, geo-coordinates etc
• query places detail to get more information about each business/place
• extract the data you need
• send it to wherever you want

[goekhan_celik]

Hi Nabossha,

thanks for the tip , i just introduced myself there.

Actually i would really Appreciate a step by step guide. My strong background is in IT security, but i havent worked much with AI yet.