Specialist Projects

Automated ai lead generation

Request for Quotation (RFQ) ​Project Title: Automated AI Lead Generation & Qualification Engine (Pre-Owned Vehicles) Target Throughput: System built to handle high-volume acquisition supporting 30+ completed vehicle sales per month Core Tech Stack: Make.com, AI Processing (Gemini / OpenAI), Web Scraping / Lead Capture, CRM & Outreach Engine (Instantly / WhatsApp / CRM) ​1. Project Overview & Objective ​We are launching an automated lead acquisition and qualification engine for a pre-owned vehicle operation in South Africa. Our goal is to achieve 30 completed vehicle sales per month. ​To support this volume, we need an end-to-end automated workflow that captures inbound vehicle inquiries (buyers and sellers), enriches and validates lead data, scores intent using AI, and routes qualified leads into an automated outreach and CRM pipeline. ​We are seeking an experienced Make.com & AI Automation Specialist to architect, build, test, and deploy this complete system. ​2. Scope of Work ​Phase 1: Lead Capture & Web Scraping ​Set up automated web and social scraping workflows (using tools like Browse AI, Apify, or Meta Lead Ads API) to extract incoming vehicle buyer and seller leads. ​Capture inbound submissions from web forms, landing pages, and external vehicle listing platforms. ​Phase 2: AI Lead Enrichment & Filtering (Make.com + AI) ​Build Make.com scenarios integrated with Gemini/OpenAI API to: ​Parse, clean, and format raw contact details (normalizing South African phone numbers, names, locations). ​Filter and score incoming leads based on buying/selling intent (vehicle preference, budget, urgency, financing readiness). ​Auto-filter junk or incomplete leads to keep the pipeline focused on high-converting prospects. ​Phase 3: Automated Personalization & Outreach ​Set up instant multi-channel response triggers (Email / WhatsApp API / SMS) ensuring speed-to-lead response times under 2 minutes. ​Generate contextual AI-personalized messaging based on specific vehicle models, buyer requests, or seller submissions. ​Connect scored leads to email/outreach platforms (e.g., Instantly.ai or automated messaging sequences). ​Phase 4: CRM Pipeline Integration ​Sync all processed leads automatically into a central CRM (HubSpot, GoHighLevel, or Airtable). ​Set up pipeline stage tracking from New Inbound → AI Qualified → In Progress → Closed / Completed. ​3. Key Deliverables ​Fully Automated Make.com Scenarios: Modular scenarios connecting lead capture, AI enrichment, and CRM destination. ​AI Lead Scoring System: Prompt architecture for automated lead classification and filtering. ​Outreach & CRM Sync: Seamless routing into cold email outreach / CRM pipelines. ​Handoff Documentation: Brief video walkthrough and technical documentation for scenario management. ​4. Required Freelancer Skills ​Advanced proficiency with Make.com or n8n multi-step scenarios. ​Hands-on experience integrating OpenAI / Gemini APIs via HTTP/REST nodes. ​Familiarity with lead scraping tools (Browse AI, Apify) and CRM APIs. ​Strong understanding of email deliverability, WhatsApp API tools, and pipeline management. ​5. Submission Requirements ​Please reply with your quotation including: ​Technical Architecture: Proposed tools and high-level Make.com scenario structure. ​Pricing Structure: Fixed setup/implementation fee (plus optional monthly maintenance retainer). ​Estimated Timeline: Total days required for development, testing, and deployment. ​Portfolio: 1–2 examples of previous lead generation or Make.com automation workflows built.

opportunity

Adult Creator Lead Researcher for Direct Fan Messaging App

We are looking for a creator outreach / lead research specialist to help us find adult-friendly content creators for a new direct fan messaging app. The app is built for creators who want to communicate directly with their fans, monetize private conversations, and keep more control over their audience — without fans feeling like they are talking to an agency, bot, or fake operator. We are looking for creators from platforms and communities such as: * OnlyFans * Fansly * Fanvue * Webcam creator communities * Instagram * X/Twitter * TikTok * Reddit creator communities * Link-in-bio creator profiles * Adult-friendly influencer communities Your main task will be to find qualified creators and build a clear lead list. For each creator, we need: * Creator name / handle * Country or language if visible * Platform links * Main social profile * Contact method * Follower count if available * Creator type: OnlyFans, Fansly, webcam, Instagram, etc. * Notes on why they could be a good fit * Whether they seem suitable for direct fan messaging You may also help with outreach using our approved message, but the first priority is high-quality research and lead generation. Important rules: * Only 18+ creators. * No minors or questionable accounts. * No scraping private information. * No fake reviews. * No spam. * No misleading messages. * No pretending to be an independent user. * Respect the rules of every platform, subreddit, group, and community. Ideal candidate: * Experience with influencer research, creator outreach, adult creator recruitment, webcam creator research, or social media lead generation * Comfortable working around adult/NSFW creator communities * Good English * Able to work independently * Able to provide clean daily updates in a spreadsheet * Knowledge of OnlyFans, Fansly, webcam, Reddit, X/Twitter, Instagram, TikTok, Telegram, Discord, or Facebook creator groups is a plus First test milestone: Please quote your price for: * 100 qualified creator leads * 20 relevant communities, groups, forums, or subreddits where creators can be found or researched * 20 manually contacted creators using our approved outreach message * A short report explaining which markets look most promising and why When applying, please answer: 1. Have you done creator or influencer outreach before? 2. Have you worked with adult/NSFW creators before? 3. Which platforms would you use to find creators? 4. Which markets do you know best? USA/UK, Latin America, Romania/Eastern Europe, or other? 5. How many qualified creator leads can you find per day? 6. Can you contact creators manually and track everything in a spreadsheet? 7. Do you understand that we do not want spam, fake reviews, fake testimonials, or rule-breaking outreach? 8. What is your price for the first test milestone?

opportunity

Excel automate, Power Query, data mapping, dashboard development

I am looking for an experienced Excel and Power Query specialist to complete a multi-level governance and assurance system for a health and social care organisation. The organisation has five service divisions. The workbooks, registers and overall structure have already been designed; I am not looking for someone to start again. I need someone who can review the existing files, improve the formulas and functionality, make the registers smarter and create reliable connections across the system. The required reporting flow is: Service/Practice Observation → Regional Governance → Divisional Governance → Group Governance/Master Dashboard Each division requires its own governance workbook and dashboard. Service and regional information must feed into the relevant divisional workbook, with key information from all five divisions feeding into one Group-level Master Dashboard. Smart governance registers The project includes a suite of existing registers covering areas such as: Risk Safeguarding Incidents and serious incidents Complaints and compliments GDPR and data breaches Restrictive practice Governance actions Service user feedback Audits and improvement Regulatory actions Training and workforce compliance The exact number of files will be confirmed with the successful freelancer following an initial review. The registers need to become functional, consistent and easy to use, rather than simply formatted spreadsheets. Depending on the register, this may include: Unique reference numbers Automated status calculations Open, closed and overdue indicators Due-date and review alerts Automated risk ratings and RAG indicators Dropdown lists and controlled data entry Conditional formatting Automated totals and summary metrics Monthly, quarterly and annual reporting Filtering by service, region, division, category, status and reporting period Identification of themes, recurring issues and required escalations Formula protection without restricting data entry Summary pages or dashboards Connections to the appropriate regional, divisional and Group dashboards The registers will remain the source of truth for individual records. Only relevant totals, themes, trends, risk ratings and outstanding actions should feed into higher-level dashboards. Main requirements The successful freelancer will be required to: Review and inventory the existing workbooks and registers Produce a clear data map showing how information should move through the system Make the registers smarter, more automated and easier to maintain Add, correct and protect formulas across multiple files and tabs Standardise dropdowns, identifiers, categories and reporting periods where required Create calculated metrics, alerts and RAG indicators Link Practice Observation data to Regional Governance workbooks Link Regional Governance workbooks to the relevant Divisional Governance workbook Complete dashboards for each of the five divisions Link all five Divisional Governance workbooks to the Group Master Dashboard Link relevant register data to the correct reporting level Use Power Query or another reliable Excel-based method where appropriate Ensure files work reliably within Microsoft 365/SharePoint Reduce the risk of broken links when files are moved, updated or refreshed Test the complete data flow from source registers through to the Master Dashboard Ensure the system is straightforward for managers with varying levels of Excel experience Deliverables Smart, functioning governance registers Functional Practice Observation templates Regional Governance and Assurance workbooks Five Divisional Governance workbooks and dashboards One Group Governance workbook and Master Dashboard Reliable connections between all relevant files Working formulas, validation, dropdowns, alerts and RAG ratings A complete data map/data dictionary Testing of the full reporting flow Simple refresh and maintenance instructions Final handover and correction of any errors identified during testing Confidentiality The work relates to confidential organisational systems. A Non-Disclosure Agreement must be signed before any files are shared. Anonymised or test data will be used wherever possible. Please include in your proposal: Your experience of creating smart Excel registers and trackers Your experience of linking Excel files stored within SharePoint/Microsoft 365 Your Power Query experience How you would minimise broken connections How you would approach mapping and testing this system Examples of comparable work What you can deliver within the approximate £1,000 budget