Scrape Airbnb Listings with Pagination & Store in Google Sheets

Description

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