n8n Workflow: Airbnb Guest Feedback Queue to Google Sheets

Airbnb Guest Feedback—Automatically Triaged into Google Sheets (No AI replies)

This n8n workflow pulls recent Airbnb guest feedback for a single public listing, reconciles coverage and billing, and upserts results into Google Sheets—highlighting low ratings that have no observed public host response while preserving review context and timestamps.

What this workflow does

• Validates inputs: requires one public Airbnb listing URL, a Google Sheets destination, and an Actor charge cap before any paid work.
• Runs and monitors one Apify task: starts one Apify run, then polls that same run until completion (no automatic paid retries).
• Verifies coverage & billing: checks that the retrieved dataset meets expected coverage, reconciles billing, and reads up to 25 recent reviews (not full history).
• Applies explicit labeling rules:
  • Labels LOW_RATING_NO_RESPONSE when ratings are low and there is no observed public host response.
  • Labels cases for missing ratings and for observed responses using explicit rules.
  • Missing ratings are never treated as negative.
• Upserts without duplicates: writes one row per listing and stable review ID. Repeated observations update existing rows instead of duplicating.
• Preserves context: keeps observation timestamps and capped labels; absent reviews are never assumed deleted.

Use cases

• Hosts/properties wanting a clear “needs attention” queue in Google Sheets for low Airbnb reviews without responses.
• Property managers running regular review monitoring across listings while keeping spreadsheet rows stable by review ID.
• SaaS operators demonstrating controlled automation with a strict Apify Actor charge cap.

Technical details

• Apify via HTTP Request nodes (header Authorization: Bearer <token>).
• Google Sheets OAuth2 integration with a dedicated “Airbnb Feedback” tab; import the companion header CSV into the first row and preserve all 15 column names.
• n8n nodes/blocks: if, set, code, wait, and supporting notes/sticky notes; manual execution can filter by reviewPriority = LOW_RATING_NO_RESPONSE for sequential runs.

Note: this workflow relies on Apify usage credits and Google Sheets access via OAuth2.