Automate travel agent outreach with web scraping, OpenAI, and Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and OpenAI. It also calls api.firecrawl.dev over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Google Sheet Data Store (Google Sheets): uses Google Sheets
- OpenAI: uses OpenAI
- Google Sheet Update Records (Google Sheets): update
- Send Email: sends an email over SMTP
- HTTP Scrape Website (HTTP Request): calls api.firecrawl.dev (POST)
- OpenAI: uses OpenAI
- Split Out: splits a list into separate items
- Google Sheet - Data Store (Google Sheets): append
Services it uses
HTTP calls to: api.firecrawl.dev
Uses Firecrawl. New users get 10% off with our link.
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Split Out
n8n-nodes-base.splitOut - Send Email
n8n-nodes-base.emailSend - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - HTTP Request
n8n-nodes-base.httpRequest
From the author
🔧 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…