Scrape Airbnb listings with pagination & store in Google Sheets
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 airbnbsearch and airbnblisting_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, pricepernight, totalprice, pricedetails 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
By Alex HuyAutomate LinkedIn requests & icebreaker with Browserflow and Google sheets
Disclaimer: As this workflow uses a Community node, it is available only to self-hosted installation of n8n Who is this for? This n8n template is designed for professionals, recruiters, and marketers who need to automate LinkedIn data population and contact request processes. It is particularly useful for those looking to streamline their outreach efforts and manage LinkedIn connections more efficiently. What problem is this workflow solving? / Use Case The workflow addresses the challenge of manually managing LinkedIn connections and sending contact requests followed by an AI generated ice-breaker. By automating these tasks, users can save time, reduce errors, and ensure consistent follow-ups with potential clients, partners, or candidates. What this workflow does: This template extract LinkedIn adresses from a google sheet, check if they already are connected to you, and send them a contact request if hey are not. Then it sends to them an AI generated Ice breaker messages, which take into account the personal and company posts, and your company description, to find common points of interest. You can contact up to 50 persons for free. Setup Copy this google sheet to your Google account Enter your data in "Set your Data Here": Google sheet URL: Paste here the URL of your google sheet Your activity: Define here what your company is about (used to match your activity with the users activity) Your name: Enter your name (used to sign your mail) Your company: Enter here your company name Your email: Used to send your email Maxitems: The number of maximum posts to download from LinkedIn Set an account on Rapid API, you are allowed for free to 50 credits (5$ for 500) and most of the calls cost 1 credit. Setup an account at Browserflow You will benefit from a 7 days free trial. And then you will have to pay $17.95. With this account you'll be able to send 1920 connection invites and 3204 messages. Install n8n-nodes-browserflow from your n8n Settings > Community Nodes. (it means for now that you'll need a self-hosted installation of n8n). and paste the API key you copied earlier as a credential. Execute it regularly to check if your connections have accepted your connection request. How to customize this workflow to your needs Customize Contact Messages: Personalize the AI agent prompt that generates the icebreaker Integrate with Other Tools: Add additional nodes to integrate with CRM systems or other marketing tools for enhanced functionality. Monitor and Optimize: Regularly review the workflow's performance and make adjustments to improve efficiency and effectiveness. By following this setup and customization guide, users can leverage this n8n template to enhance their LinkedIn outreach and connection management processes.
By PollupAI