This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

Description

This n8n workflow automatically scrapes Airbnb listings from a specified location and saves the data to a Google Sheet. It performs pagination to collect listings across multiple pages, extracts detailed information for each property, and organizes the data in a structured format for easy analysis.

How it Works

The workflow operates through these high-level steps:

• Search Initialization: Starts with an Airbnb search for a specific location (London) with defined check-in/check-out dates and guest count
• Pagination Loop: Automatically processes multiple pages of search results using cursor-based pagination
• Data Extraction: Parses listing information including names, prices, ratings, reviews, and URLs
• Detail Enhancement: Fetches additional details for each listing (house rules, highlights, descriptions, amenities)
• Data Storage: Saves all collected data to a Google Sheet with proper formatting
• Loop Control: Continues until reaching the page limit (2 pages) or no more results are available

Setup Steps

• Prerequisites
  n8n instance with MCP (Model Context Protocol) support
  Google Sheets API credentials configured
  Airbnb MCP client properly set up

• Configuration Steps
  --- Configure MCP Client
  Set up the Airbnb MCP client with credential ID:
  Ensure the client has access to airbnb_search and airbnb_listing_details tools
  --- Google Sheets Setup
  Create a Google Sheet with ID: 15IOJquaQ8CBtFilmFTuW8UFijux10NwSVzStyNJ1MsA
  Configure Google Sheets OAuth2 credentials (ID: 6YhBlgb8cXMN3Ra2)
  Ensure the sheet has these column headers:
  "id, name, url, price_per_night, total_price, price_details
  beds_rooms, rating, reviews, badge, location
  houseRules, highlights, description, amenities"

• Search Parameters
  Location: "London" (can be modified in the "Airbnb Search" node)
  Adults: 7
  Children: 1
  Check-in: "2025-08-14"
  Check-out: "2025-08-17"
  Page limit: 2 (can be adjusted in the "If1" condition node)

• Execution
  Use the manual trigger "When clicking 'Execute workflow'" to start the process
  Monitor the workflow execution through the n8n interface
  Check the Google Sheet for populated data after completion

• Key Features
  Automatic Pagination: Processes multiple pages without manual intervention
  Comprehensive Data: Extracts both basic listing info and detailed property information
  Error Handling: Includes JSON parsing error handling and data validation
  Batch Processing: Uses split batches for efficient processing of individual listings
  Real-time Updates: Appends new data to existing Google Sheet records

Output Data Structure

Each listing contains:

• Basic info: ID, name, URL, pricing details, room/bed count
• Ratings: Average rating and review count
  Location: Latitude and longitude coordinates
• Enhanced details: House rules, highlights, descriptions, amenities
• Metadata: Page number, check-in/out dates, badges