Make.com Expert for Automated Outreach Workflow
Budget: €250 – €750 EUR
I am looking for an experienced Make.com specialist to build a clean, reliable, and automated outreach workflow for my recruitment agency.
The system needs to pull job postings daily, parse the data using AI, trigger automated email campaigns, and cleanly log data into Google Sheets for manual follow-up.
The Workflow Logic:
1. Trigger (Apify): Daily trigger to fetch new job postings from an Apify Indeed Scraper dataset (targeting sales jobs in the Netherlands).
2. AI Processing (OpenAI GPT-4o) + Strict JSON & Error-Handling:
• Send the raw job description text to OpenAI to parse and extract the following specific data fields: Company Name, Job Title, Contact Person's First Name, Email Address, and Mobile (06) Number.
• Crucial: The OpenAI module must be structured to return strict JSON output to make the router filters 100% reliable. You must include an error-handling layer around OpenAI so that malformed or weird job descriptions do not silently break or stop the entire scenario.
1. Advanced Duplicate Check:
• Before routing anything, implement a duplicate check system (using a Make Datastore or a lookup step) to ensure we never process or outreach to the same lead twice. The machine must check against BOTH the unique Job URL and the extracted Email Address.
1. Router / Action Routes:
• Route A (If Email is found): Automatically push the lead data into Instantly.ai via API to trigger an email sequence, and log the complete lead data into a Google Sheet.
• Name Personalization Logic: If OpenAI finds a first name, push it to the First Name field (properly capitalized). If NO first name is found, leave the First Name field completely empty/blank. This allows me to use Instantly's native fallback variables (e.g., using "Goedendag {{First Name | }}," in my email template).
• Route B (If No Email, but Mobile/06 Number is found): Automatically log the lead data into a specific tab in the Google Sheet named "WhatsApp Follow-up" so I can reach out and follow up manually.
• Route C (If No Contact Data is found): Route these leads to a separate "Manual Review" tab in the Google Sheet instead of breaking or discarding the scenario silently.
What I will provide:
• Access to my Make.com account.
• API keys for OpenAI and Instantly.ai.
• Access to the Google Sheet.
Please provide your estimated time to complete, how you plan to approach the error-handling/JSON part, and a fixed price. Looking forward to your proposals!
The system needs to pull job postings daily, parse the data using AI, trigger automated email campaigns, and cleanly log data into Google Sheets for manual follow-up.
The Workflow Logic:
1. Trigger (Apify): Daily trigger to fetch new job postings from an Apify Indeed Scraper dataset (targeting sales jobs in the Netherlands).
2. AI Processing (OpenAI GPT-4o) + Strict JSON & Error-Handling:
• Send the raw job description text to OpenAI to parse and extract the following specific data fields: Company Name, Job Title, Contact Person's First Name, Email Address, and Mobile (06) Number.
• Crucial: The OpenAI module must be structured to return strict JSON output to make the router filters 100% reliable. You must include an error-handling layer around OpenAI so that malformed or weird job descriptions do not silently break or stop the entire scenario.
1. Advanced Duplicate Check:
• Before routing anything, implement a duplicate check system (using a Make Datastore or a lookup step) to ensure we never process or outreach to the same lead twice. The machine must check against BOTH the unique Job URL and the extracted Email Address.
1. Router / Action Routes:
• Route A (If Email is found): Automatically push the lead data into Instantly.ai via API to trigger an email sequence, and log the complete lead data into a Google Sheet.
• Name Personalization Logic: If OpenAI finds a first name, push it to the First Name field (properly capitalized). If NO first name is found, leave the First Name field completely empty/blank. This allows me to use Instantly's native fallback variables (e.g., using "Goedendag {{First Name | }}," in my email template).
• Route B (If No Email, but Mobile/06 Number is found): Automatically log the lead data into a specific tab in the Google Sheet named "WhatsApp Follow-up" so I can reach out and follow up manually.
• Route C (If No Contact Data is found): Route these leads to a separate "Manual Review" tab in the Google Sheet instead of breaking or discarding the scenario silently.
What I will provide:
• Access to my Make.com account.
• API keys for OpenAI and Instantly.ai.
• Access to the Google Sheet.
Please provide your estimated time to complete, how you plan to approach the error-handling/JSON part, and a fixed price. Looking forward to your proposals!
Related categories:
PHP
Python
Web Scraping
Google App Engine
Automation
API Development
API Integration
OpenAI
Make.com
AI Development