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 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. OpenAI Standardise

Help me set up the n8n workflow "Automate Travel Agent Outreach with Web Scraping, OpenAI, and Google Sheets" (https://n8n.io/workflows/4606). It uses: Send Email, Google Sheets, HTTP Request, OpenAI. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.