Automate travel agent outreach with web scraping, OpenAI, and Google Sheets

🔧 Automated Workflow: Scrape Travel Agent Contacts and Send Personalized Survey Emails This workflow is designed to automate the process of scraping travel agent contact data, standardizing the information, storing it, and then sending out personalized survey emails using AI. It’s especially useful for outreach campaigns, research, or lead generation.

⚙️ Workflow Breakdown 📍 Part 1: Scraping and Storing Travel Agent Data 1. HTTP Scrape Website Type: HTTP Request (POST)

Function: Calls a third-party scraping API (https://api.firecrawl.dev...) to scrape data from a travel agent listing site.

Purpose: Extract raw HTML or structured data from a website containing contact info.

2. OpenAI Standardise Data Type: OpenAI Message Model

Function: Uses AI to clean and standardize the raw scraped data into structured JSON (e.g., name, email, agency, location).

Purpose: Ensures uniformity in formatting, making data easier to process downstream.

3. Split Out Type: Item Splitter