Build WhatsApp Lead Automation with Apollo + OpenAI + Google Sheets via n8n

Project # 205160

8 Bids	budget 2,500 ILS - 5,000 ILS	bidding ends in mins	bid range 122 ILS - 250 ILS / hour 2,000 ILS - 9,500 ILS / project	average bid 190 ILS / hour 4,666 ILS / project

budget

2,500 ILS - 5,000 ILS

bidding ends in

mins

bid range

122 ILS - 250 ILS / hour

2,000 ILS - 9,500 ILS / project

average bid

190 ILS / hour

4,666 ILS / project

Email Report

Posted: 13:00, 15 May., 2025

Ends: 16:52, 4 Jul., 2025

Build WhatsApp Lead Automation with Apollo + OpenAI + Google Sheets via n8n

I'm looking for an automation expert to create a workflow in n8n that will:

Fetch leads from Apollo.io API based on filters (e.g. title, industry).
Store the leads in a Google Sheet, avoiding duplicates.
Send personalized WhatsApp messages to each lead via Wassenger API.
Monitor replies and:
Automatically answer using OpenAI when the reply is clear.
Forward replies to my email when the intent is unclear or the lead shows interest.
Update the lead’s status and response in the sheet/database.
Deliverables:

Fully working n8n workflow
Setup instructions
Sheet template

Please apply only if you have prior experience with API integrations, n8n, OpenAI, and WhatsApp automation (Wassenger preferred). This project is for internal marketing automation and will evolve over time, so clean, modular work is important.