Hi Team,
I’m interested in subscribing to Make.com because of its speed and great reviews. However, I need your assistance in creating an automation to help me decide if your platform is the right fit for my needs.
I’ve already tried the AI assistant on your platform, but the results were confusing and not accurate enough for what I need. I hope you can guide me through creating the following automation steps:
- Copy website links from a Google Sheet and paste them into Apollo.io. I have a saved company search in Apollo.io with filters applied to find companies located in the US, UK, or Cana
da with 1-10 employees. I want to enter the website links into the company section on Apollo.io, go to “Include,” and input the website links there (I have attached a screenshot for reference). Since I have thousands of website links, I only want to process 250 at a time due to my Apollo.io free account limitations. - Scrape the results from Apollo.io and save the data into a new tab within the same Google Sheet.
- Open each website, navigate to their offerings or services page (or similar, like What We do), extract the HTML of the website, and convert it into text.
- Use ChatGPT to:
- Analyze the HTML content (converted to text) from each website to identify the services offered.
Based on the services listed, qualify each company using these criteria:- If their op 3 services include website services(I have a list of website services terms to look for) and they also offer SEO services or SEO-related terms (e.g., Search Engine Optimization, SEO Audit, Link Building, etc.), mark it as “Already have services.”
- If website services are not in their top 3, but digital marketing services are listed (I have a list of digital marketing services to look for), mark it as “Qualified.”
- If website services are listed in their top 3 services but they don’t offer SEO services, mark it as “Qualified”.
- If neither website services nor digital marketing services are mentioned, mark it as “Not relevant.”
- Analyze the HTML content (converted to text) from each website to identify the services offered.
- Also, use chatGPT to analyze the extracted text to find decision-makers’ names (e.g., Owner, Founder, President) and get links to the “Contact Us” and “About Us/Team/Leadership” pages.
- For websites where the owner’s name isn’t available, I want to use Apollo.io, Clearbit, and RocketReach to find this information, including their LinkedIn profile. Please note that I’m using free accounts for all these tools so i want to process 100 at a time.
Can you guide me on how to set up this automation effectively? Your help will make a big difference in my decision to subscribe.
Thank you so much!