Looking for a pro to setup an automated CRM search and fill process

Hey there, I am wanting to setup a system that i can implement across a few companies that is 1. to check existing CRMs made in notion, to fill in missing information and to update existing information.

  1. To create a new CRM. I have companies up and coming that will need to have this done from scratch so it will need to search for the target market, find their details (Name, email, phone ect) and input into an excel sheet or similar. which i can then upload into notion and create an automated CRM emiling system through that.

My current process is as follows:

  1. define target clients
  2. scrape data in bulk from basically yellow pages (Different in different countries) after filtering for those certain people or professions.
  3. export to excel and split between a team who manually go through each line finding linkedin accounts, place of work, email, website, phone, ect.
  4. once the data work is complete I then import into notion and create a custom CRM for each companies needs.

This is a long and costly process, I have started playing with a scenario which is basically google sheet > search Apollo > find data fill data > Update google sheet. But I am not a professional on here and my scenario currently doesn’t work, it’ll take me ages to figure out the best way to do this. Also open to suggestions if you have a different or better way of creating this work flow i would really appreciate your thoughts.
Thank you in advance for your reply. If you wish to contact me privately to speak on this topic my email is summer@pt.digital.

Best Summer

1 Like

Hello @summer1 welcome to the make Hire a pro section , I would love to work with you on this, you can book a call Here to discuss the project requirements

Hello Summer

Thanks for sharing such a detailed breakdown—it’s clear you’ve put a lot of work into building a process that works, even if it’s time-consuming right now. You’re definitely on the right path with Apollo + Make + Notion.

I sent you a quick email to dive a bit deeper and chat through how I might simplify and scale what you’ve already started—especially the enrichment and CRM creation steps.

Looking forward to connecting!

Best,
Holiness
Holinessonyemaechi@gmail.com

I understand you’re looking to automate and streamline your CRM process, from gathering data for new CRMs to updating and filling in missing information in your existing Notion CRMs. With my experience in automation, I can help design an efficient solution to automate data scraping, integrate with tools like Apollo or Google Sheets, and streamline the entire workflow to save you time and reduce manual effort.

You can book a 30-minute call with me here: [https://calendly.com/farhan-aviary1103]. For more details, feel free to check my profile here: [https://www.upwork.com/freelancers/farhana401].

Hi @summer1 ! I would love to help you with this, I am doing something similar, but also using Apify to scrape Apollo leads

We are a small team of make.com experts and have developed plenty of complex integrations. This project should not be a challenge to us.

If you are interested we would love to help you, you can schedule a call in here: https://cal.com/aspirity/discovery or check our website www.aspirity.com

Hi @summer1
I’ve recently build a solution just like this,
I would be happy to demo it to you.
Have a look at my website duativ.aiand feel free to book a free discovery call.
Best Regards, Marc

This topic was automatically closed after 30 days. New replies are no longer allowed.