Auto-Generate AI Travel Itineraries from n8n Form to Google Doc

User submits departure, destination, dates, and travelers via n8n form → parallel scraping of Booking.com hotels, Google Flights, and OpenAI recommendations → merged into a formatted Google Doc with returned link

Who

Travel agencies, freelance travel planners, or anyone automating personalized trip planning

You get

Submit a form and automatically receive a Google Doc link with flights, hotels, restaurants, attractions, and a day-by-day itinerary

You need

n8n · apify · google-docs

Steps

1. Trigger and normalize input

   Deploy the Travel Form node in n8n to collect departure airport IATA code, destination city, destination airport IATA code, check-in date, check-out date, and number of travelers. Then use the Set Variables node to normalize form fields into departureAirport, destination, destinationAirport, checkinDate, checkoutDate, and travelers for downstream use.

2. Fetch three data streams in parallel

   From Set Variables, split into three parallel branches: 1. **Booking.com hotel scraping**: Apify node calls Actor `oeiQgfg5fsmIJB7Cn` (Booking Scraper), passing destination, checkinDate, checkoutDate, and travelers, with maxItems=5 and sortBy=bayesian_review_score. Then an HTTP Request node reads results from `https://api.apify.com/v2/datasets/{{ $json.defaultDatasetId }}/items` using HTTP Query Auth (parameter name: token). 2. **Google Flights scraping**: Apify node calls Actor `1dYHRKkEBHBPd0JM7` (Google Flights Scraper), passing departureAirport, destinationAirport, checkinDate, checkoutDate, and travelers. Then an HTTP Request node reads flight results from `{{ $json.output.flightResults }}` with the same HTTP Query Auth. 3. **OpenAI travel recommendations**: Basic LLM Chain node (AI Recommendations) connected to OpenAI Chat Model node (gpt-4o-mini) runs the travel-expert prompt to generate restaurants, attractions, local tips, and a day-by-day itinerary.

   Execution prompt · Source text。AI Recommendations node (Basic LLM Chain) text/prompt field

   Copy prompt

   =You are a travel expert. Please provide comprehensive travel recommendations for {{ $('Set Variables').item.json.destination }}.
   
   Travel dates: {{ $('Set Variables').item.json.checkinDate }} to {{ $('Set Variables').item.json.checkoutDate }}
   Number of travelers: {{ $('Set Variables').item.json.travelers }}
   
   Please provide:
   
   1. **TOP 10 RESTAURANTS** - Include a mix of local cuisine, fine dining, and casual options. For each restaurant provide:
      - Name
      - Type of cuisine
      - Price range ($, $$, $$$, $$$$)
      - Brief description
      - Must-try dish
   
   2. **TOP 10 MONUMENTS & HISTORICAL SITES** - Include famous landmarks and hidden gems. For each provide:
      - Name
      - Brief history/description
      - Best time to visit
      - Estimated visit duration
      - Entry fee (if any)
   
   3. **TOP 10 PLACES TO VISIT** - Include parks, neighborhoods, markets, viewpoints, etc. For each provide:
      - Name
      - Description
      - Best time to visit
      - Tips for visitors
   
   4. **LOCAL TIPS** - Provide:
      - Best transportation options
      - Local customs to be aware of
      - Safety tips
      - Best neighborhoods to stay in
      - Common scams to avoid
   
   5. **SUGGESTED ITINERARY** - Create a day-by-day suggested itinerary based on the travel dates.
   
   Format your response in a clear, organized manner with proper sections and bullet points.

3. Merge and structure data

   The Merge All Data node (3 inputs) combines hotel, flight, and AI recommendation streams into a single item. The Process All Data node (Code, JavaScript) cleans and structures: extracts top 5 hotels from HTTP Request Hotels (name, rating, price, address, URL); extracts top 5 flights from HTTP Request Flights (airline, price, duration, departure/arrival times); extracts recommendation text from AI Recommendations; outputs a standardized object with tripDetails, hotels, flights, recommendations, and generatedAt.

4. Generate Google Doc and return link

   The Create Document node creates a new doc in the specified Google Drive folderId, with a dynamic title: "Travel Plan - {departureAirport} to {destinationAirport} for {travelers} people". The Prepare Document Content node (Code) formats the structured data into plain text with dividers and emoji. The Update Document node inserts the content. The Prepare Form Ending node extracts the documentUrl, and the final Form Ending node shows a completion page to the user with the doc link and content summary.

You are assisting with reproducing the n8n template "Plan AI-powered travel itineraries with Apify, OpenAI, and Google Docs". First confirm you have the following credentials and permissions:
1. Apify account and API token (create both "Apify API" and "HTTP Query Auth" credentials, with parameter name: token)
2. OpenAI API key (OpenAI credential)
3. Google account with OAuth2 authorization (Google Docs credential), plus a Drive folder ID
4. n8n instance (1.0+ recommended)

Once confirmed, import workflow.json or build manually per the node instructions, paying special attention to Set Variables field mapping, Apify Actor IDs, and the Create Document folderId. Test each parallel branch with sample data before the first full run.