{"product_id":"n8n-workflow-airbnb-guest-feedback-queue-to-google-sheets","title":"n8n Workflow: Airbnb Guest Feedback Queue to Google Sheets","description":"\u003ch3\u003eAirbnb Guest Feedback—Automatically Triaged into Google Sheets (No AI replies)\u003c\/h3\u003e\n\u003cp\u003eThis 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 \u003cem\u003eno observed public host response\u003c\/em\u003e while preserving review context and timestamps.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates inputs\u003c\/strong\u003e: requires one public Airbnb listing URL, a Google Sheets destination, and an \u003cstrong\u003eActor charge cap\u003c\/strong\u003e before any paid work.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns and monitors one Apify task\u003c\/strong\u003e: starts one Apify run, then polls that same run until completion (no automatic paid retries).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eVerifies coverage \u0026amp; billing\u003c\/strong\u003e: checks that the retrieved dataset meets expected coverage, reconciles billing, and reads up to \u003cstrong\u003e25 recent reviews\u003c\/strong\u003e (not full history).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApplies explicit labeling rules\u003c\/strong\u003e:\n    \u003cul\u003e\n      \u003cli\u003eLabels \u003cstrong\u003eLOW_RATING_NO_RESPONSE\u003c\/strong\u003e when ratings are low and there is no observed public host response.\u003c\/li\u003e\n      \u003cli\u003eLabels cases for \u003cstrong\u003emissing ratings\u003c\/strong\u003e and for \u003cstrong\u003eobserved responses\u003c\/strong\u003e using explicit rules.\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eMissing ratings are never treated as negative\u003c\/strong\u003e.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts without duplicates\u003c\/strong\u003e: writes \u003cstrong\u003eone row per listing\u003c\/strong\u003e and \u003cstrong\u003estable review ID\u003c\/strong\u003e. Repeated observations update existing rows instead of duplicating.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePreserves context\u003c\/strong\u003e: keeps observation timestamps and capped labels; absent reviews are never assumed deleted.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eHosts\/properties wanting a clear “needs attention” queue in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e for \u003cstrong\u003elow Airbnb reviews without responses\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eProperty managers running regular review monitoring across listings while keeping spreadsheet rows stable by review ID.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators demonstrating controlled automation with a strict Apify \u003cstrong\u003eActor charge cap\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e via HTTP Request nodes (header Authorization: \u003cem\u003eBearer \u0026lt;token\u0026gt;\u003c\/em\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e OAuth2 integration with a dedicated “Airbnb Feedback” tab; import the companion header CSV into the first row and preserve all \u003cstrong\u003e15 column names\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/blocks: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, and supporting notes\/sticky notes; manual execution can filter by \u003cstrong\u003ereviewPriority = LOW_RATING_NO_RESPONSE\u003c\/strong\u003e for sequential runs.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eNote:\u003c\/strong\u003e this workflow relies on \u003cstrong\u003eApify usage credits\u003c\/strong\u003e and \u003cstrong\u003eGoogle Sheets access\u003c\/strong\u003e via OAuth2.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45974306947251,"sku":"N8N-19302","price":42.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ss1DMZ-8aFKjz0Ge8JX2E_XS9ACwV1.png?v=1788771999","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-airbnb-guest-feedback-queue-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}