Hotel Review Management Template for n8n | Automate Review Scraping from Booking.com & Tripadvisor to Track Guest Feedback

✅ Purpose

This workflow automatically scrapes reviews from Booking.com and Tripadvisor, analyzes them using Google Gemini, and logs the processed data into Airtable with AI-generated improvement suggestions.

🔧 Setup Instructions

1. API Keys Required

• Apify API Key
  📌 Get it from: https://www.apify.com?fpr=12vqj🔑 Assign to the Apify API Key node (replace "=your apify key" with your actual key).
• Google Gemini API Key
  📌 Get it from: https://aistudio.google.com/app/apikey🔑 Add it to Google Gemini Chat Model node.
• Airtable API Token
  🔗 Make sure your Airtable credentials are configured and connected in n8n.How to get Airtable token:
  
  

🧱 Workflow Structure Overview

▶️ Trigger

• Schedule Trigger: Automates scraping every week at 8 AM.

🏨 Hotel Input Links

• Set manually in these nodes:
  • Booking.com link of the hotel
  • Tripadvisor.com link of the hotel1

📝 These should contain the direct hotel URLs to scrape: