Automate Sales Outreach: OpenAI, Tavily & Google Sheets Prospect Research

This n8n workflow streamlines sales outreach by triggering on new call bookings (manual for testing). It pulls prospect details from Google Sheets tabs like 'Meeting Data', researches the company, tech stack, and updates via Tavily API, then matches relevant products from your 'Products' sheet and success stories from 'Success Stories'.

OpenAI generates tailored email confirmations (subject + body) and SMS messages incorporating testimonials for relevance. All generated content updates back to the sheet for easy follow-up and tracking. Pre-configured nodes minimize setup—just connect APIs and duplicate the sample sheet.

Benefits include massive time savings (10-15 min setup vs. hours manual research), hyper-personalized outreach boosting response rates, and scalable prospecting for sales teams. Ideal for B2B sales reps, SDRs, or agencies handling leads—perfect for CRM-like automation without complex tools.

Use cases: Onboard new leads from calendars/forms, prep sales calls with intel, automate follow-ups, or integrate with booking tools like Calendly. Handles research, personalization, and logging in one flow.