Automated LinkedIn lead enrichment pipeline using Apollo.io & Google Sheets

LinkedIn to Apollo.io Lead Enrichment System with Google Sheets

Automatically capture company and store details from LinkedIn posts, enrich them with domain names and key decision-maker (KDM) data from Apollo.io, and store everything neatly in Google Sheets. This workflow turns LinkedIn post data into a complete, structured lead database — fully automated from detection to enrichment.

---

🧾 Summary

This workflow reads LinkedIn post data (in JSON format) received via a webhook, extracts company and location information using an AI agent, and progressively enriches the data in three stages: 1. Find Company Domain using Apollo.io 2. Fetch Key Decision Makers (KDMs) using the company domain 3. Find Corporate Emails for those KDMs

All results are automatically updated in Google Sheets, ensuring your lead list remains fresh, structured, and actionable.

---

⚙️ Prerequisites