Scrape travel agency data and send personalized emails

This automation template extracts travel agency information from websites, structures it using AI, and triggers personalized email campaigns — all without manual copy-pasting. Designed for marketers, researchers, and business analysts who need to scale data collection and outreach quickly.

## Who it´s for
- Marketers conducting surveys among travel agencies
- Researchers gathering data on tourism companies
- Business analysts automating web content processing
- Agency owners looking to scale outreach campaigns

## What the automation does
- Manually triggered to scrape data from a specified website via HTTP request
- Sends raw text to OpenAI for normalization (name, email, website)
- Stores structured data in Google Sheets
- Iterates through each record and generates personalized emails using AI
- Sends emails via SMTP server
- Updates row status in Google Sheets to ´Sent´ after delivery

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic (manual trigger)
- Integrations with Google Sheets API, Firecrawl API, OpenAI API, and SMTP
- Basic setup and adaptation guide

## Requirements for setup
- n8n instance with workflow editing access
- Google Sheets account with read/write permissions
- OpenAI API key
- SMTP server with login and password
- Target website URL containing travel agency data

## Benefits and outcomes
- Saves time on manual data collection and entry
- Eliminates errors from copying data by hand
- Enables personalized messaging based on real company data
- Reusable for new campaigns across regions or niches
- Clear tracking of email status directly in Google Sheets
- Fast deployment of similar workflows for other use cases

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.