Tripadvisor reviews to Notion with n8n

Method

1. Get an Apify token

   Sign in to Apify and copy a personal API token from Console: Settings, API and integrations. The workflow keeps it in an n8n credential, never in the file.

2. Import the workflow

   In n8n choose Workflows, Import from file, or paste the JSON onto an empty canvas.

   • Run by hand
   • Every day
   • Run Apify Actor
   • Only records not sent before
   • Keep main fields
   • Send to Notion

   n8n workflowtripadvisor-reviews-to-notion.n8n.json

   Copy Download Actor on Apify

   Show the file (207 lines)

   {
     "name": "Tripadvisor reviews to Notion",
     "nodes": [
       {
         "id": "0b145732-ae7e-42a4-a2c9-4f69043c2747",
         "name": "Run by hand",
         "type": "n8n-nodes-base.manualTrigger",
         "typeVersion": 1,
         "position": [
           0,
           0
         ],
         "parameters": {}
       },
       {
         "id": "c6b6d832-acba-4332-afb0-124fc3fdc0cf",
         "name": "Every day",
         "type": "n8n-nodes-base.scheduleTrigger",
         "typeVersion": 1.2,
         "position": [
           0,
           200
         ],
         "parameters": {
           "rule": {
             "interval": [
               {
                 "triggerAtHour": 8
               }
             ]
           }
         },
         "notes": "Activate the workflow to run on this schedule."
       },
       {
         "id": "fe15593e-e4a3-47bb-affc-d726b1d5f6a3",
         "name": "Run Apify Actor",
         "type": "n8n-nodes-base.httpRequest",
         "typeVersion": 4.2,
         "position": [
           260,
           100
         ],
         "parameters": {
           "method": "POST",
           "url": "https://api.apify.com/v2/actors/vexaloom-labs~tripadvisor-guest-review-and-rating-extractor/run-sync-get-dataset-items",
           "authentication": "genericCredentialType",
           "genericAuthType": "httpHeaderAuth",
           "sendBody": true,
           "specifyBody": "json",
           "jsonBody": "{\n  \"startUrls\": [\n    \"https://www.tripadvisor.com/Hotel_Review-g60763-d675616-Reviews-The_Plaza_New_York-New_York_City_New_York.html\"\n  ],\n  \"maxReviews\": 5,\n  \"sortBy\": \"mostRecent\"\n}",
           "options": {
             "timeout": 310000
           }
         },
         "notes": "Actor: vexaloom-labs/tripadvisor-guest-review-and-rating-extractor. Select a Header Auth credential: name Authorization, value Bearer + your Apify token. Edit the JSON body to change the input.",
         "notesInFlow": false
       },
       {
         "id": "a0400b22-6128-4900-ac87-6119570a55a7",
         "name": "Only records not sent before",
         "type": "n8n-nodes-base.removeDuplicates",
         "typeVersion": 2,
         "position": [
           500,
           100
         ],
         "parameters": {
           "operation": "removeItemsSeenInPreviousExecutions",
           "logic": "removeItemsWithAlreadySeenKeyValues",
           "dedupeValue": "={{ $json.reviewUrl }}",
           "options": {
             "scope": "node",
             "historySize": 10000
           }
         },
         "notes": "Remembers each reviewUrl it has passed on (up to 10,000) across runs, so a record is sent once. Needs n8n 1.64 or later."
       },
       {
         "id": "3c3e29a2-9bae-4c7e-a40e-0587c886543b",
         "name": "Keep main fields",
         "type": "n8n-nodes-base.code",
         "typeVersion": 2,
         "position": [
           740,
           100
         ],
         "parameters": {
           "jsCode": "// Keeps the Actor's main fields as flat, spreadsheet-safe values.\nconst columns = [\"placeName\",\"reviewRating\",\"reviewTitle\",\"reviewDate\",\"tripType\",\"reviewerName\",\"ownerResponse\",\"reviewUrl\"];\n// A dotted name such as author.name reads the nested value.\nconst read = (obj, key) => (key in obj ? obj[key] : key.split('.').reduce((v, part) => (v && typeof v === 'object' ? v[part] : undefined), obj));\nreturn $input.all().map((item) => {\n  const row = {};\n  const present = columns.filter((key) => read(item.json, key) !== undefined);\n  // A record shaped differently from the published schema keeps its own fields rather than arriving blank.\n  for (const key of present.length >= 2 ? present : Object.keys(item.json)) {\n    const value = read(item.json, key);\n    row[key] = value === null || value === undefined ? '' : typeof value === 'object' ? JSON.stringify(value) : value;\n  }\n  return { json: row };\n});"
         }
       },
       {
         "id": "f7e7ff2a-214a-452e-a3d0-c1affe72dadf",
         "name": "Send to Notion",
         "type": "n8n-nodes-base.notion",
         "typeVersion": 2.2,
         "position": [
           980,
           100
         ],
         "parameters": {
           "resource": "databasePage",
           "databaseId": {
             "__rl": true,
             "value": "",
             "mode": "list"
           },
           "title": "={{ [$json.placeName, $json.reviewTitle].filter((v) => v !== undefined && v !== null && v !== '').join(': ') || 'Untitled' }}",
           "propertiesUi": {
             "propertyValues": []
           },
           "blockUi": {
             "blockValues": [
               {
                 "type": "paragraph",
                 "textContent": "={{ [[\"reviewRating\", $json.reviewRating], [\"reviewDate\", $json.reviewDate], [\"tripType\", $json.tripType], [\"reviewerName\", $json.reviewerName], [\"ownerResponse\", $json.ownerResponse], [\"reviewUrl\", $json.reviewUrl]].filter(([, v]) => v !== undefined && v !== null && v !== '').map(([k, v]) => k + ': ' + (typeof v === 'object' ? JSON.stringify(v) : v)).join(' | ').slice(0, 1900) || ' ' }}"
               }
             ]
           },
           "options": {}
         },
         "notes": "Pick your Notion database. Each page gets the record's main fields as its content; map extra database properties if you want to filter on them."
       },
       {
         "id": "7ce0aa8a-0f6b-415e-ae59-a947be4626eb",
         "name": "Setup",
         "type": "n8n-nodes-base.stickyNote",
         "typeVersion": 1,
         "position": [
           0,
           -370
         ],
         "parameters": {
           "content": "## TripAdvisor Guest Review & Rating Extractor\n\nSource: [vexaloom-labs/tripadvisor-guest-review-and-rating-extractor](https://apify.com/vexaloom-labs/tripadvisor-guest-review-and-rating-extractor) on Apify.\n\n1. In **Run Apify Actor**, create a Header Auth credential: name `Authorization`, value `Bearer YOUR_APIFY_TOKEN` with your token.\n2. Open **Send to Notion** and connect your Notion account.\n3. Edit the JSON body of **Run Apify Actor** to change the input.\n\nGenerated by recipeforagents.com. Validated, not executed: runs are billed to your Apify account.",
           "height": 340,
           "width": 460,
           "color": 6
         }
       }
     ],
     "connections": {
       "Run by hand": {
         "main": [
           [
             {
               "node": "Run Apify Actor",
               "type": "main",
               "index": 0
             }
           ]
         ]
       },
       "Every day": {
         "main": [
           [
             {
               "node": "Run Apify Actor",
               "type": "main",
               "index": 0
             }
           ]
         ]
       },
       "Run Apify Actor": {
         "main": [
           [
             {
               "node": "Only records not sent before",
               "type": "main",
               "index": 0
             }
           ]
         ]
       },
       "Only records not sent before": {
         "main": [
           [
             {
               "node": "Keep main fields",
               "type": "main",
               "index": 0
             }
           ]
         ]
       },
       "Keep main fields": {
         "main": [
           [
             {
               "node": "Send to Notion",
               "type": "main",
               "index": 0
             }
           ]
         ]
       }
     },
     "pinData": {},
     "active": false,
     "settings": {
       "executionOrder": "v1"
     },
     "meta": {
       "templateCredsSetupCompleted": false
     },
     "tags": []
   }

   Validated, not executed: 11 of 11 checks pass

   • It has a nodes array and a connections object
   • Every node has a name, type, typeVersion, position and parameters
   • Node names are unique
   • Every node type is a known n8n core node (or the Apify node)
   • Every node uses a typeVersion that n8n ships
   • Every connection points at an existing node
   • At least one trigger starts the workflow
   • Every working node is reachable from a trigger
   • Apify calls use POST and a credential for the token
   • Actor input matches the Actor's published input schema
   • No token or credential value is embedded

3. Add the Apify credential

   Open Run Apify Actor. Under Credential, create a Header Auth credential with the name Authorization and the value Bearer, a space and your token.

4. Set the input

   The request body holds the Actor input. It starts from the Actor's Store prefill; change startUrls, maxReviews, sortBy to match your search.

   {
     "startUrls": [
       "https://www.tripadvisor.com/Hotel_Review-g60763-d675616-Reviews-The_Plaza_New_York-New_York_City_New_York.html"
     ],
     "maxReviews": 5,
     "sortBy": "mostRecent"
   }

   Every input field is documented on the TripAdvisor Guest Review & Rating Extractor page.

5. Only new records go through

   The Only records not sent before node (n8n's Remove Duplicates, set to remove items processed in previous executions) remembers each reviewUrl it has passed on, so a record reaches Notion once even when the next run returns it again. It needs n8n 1.64 or later; clear its history from the node to resend everything.

6. Connect Notion

   Open Send to Notion, select your Notion credential and pick the database. The page title comes from placeName and reviewTitle and the page body holds the other fields; map database properties if you want to filter on them.

7. Run once, then turn it on

   Click Execute workflow and check the first records in Notion. When they look right, activate the workflow so the daily trigger runs it at 08:00 in your instance's timezone.

Where it breaks

• Tripadvisor access restrictions or service rate limits can interrupt collection; a slow source request can also exceed the HTTP timeout.
• Changes to reviewUrl or other mapped names can break duplicate filtering or leave Notion page content incomplete.
• A Notion connection without access to the selected database cannot create review pages.
• Duplicate history is finite and sits before delivery to Notion: cleared history can allow repeated pages, while a failed Notion write can leave a review marked as already seen.
• The workflow uses Apify's synchronous endpoint, which waits up to 300 seconds. Bigger runs answer HTTP 408: lower the limit or switch to an asynchronous run.
• Each run is billed to your Apify account at the Store price ($0.99 per 1,000 results (pay per event)).

Make or Zapier: In Make or Zapier, map the same flow to an authenticated Apify source request, persistent reviewUrl tracking and Notion page creation, with database properties mapped separately.

Bigger runs: the long-run workflow starts the run, waits for it and reads the dataset, so it never hits the 300-second limit.

If the workflow fails

Why does the workflow or script stop with HTTP 408?

The synchronous endpoint waits at most 300 seconds. After that it answers 408 while the run keeps going in Apify. Lower the result limit, or start the run asynchronously, wait for it to finish and then read its dataset.

Source: Apify API: run Actor synchronously and get dataset items

What do 400, 401, 402 and 403 from the Apify API mean?

Read error.type in the response body. 400 is invalid Actor input. 401 (user-or-token-not-found) means a token reached Apify but it is wrong or revoked. 402 with x402-payment-required means no token reached Apify at all: the n8n credential or the Authorization: Bearer header is missing, and Apify is offering its pay-per-run x402 route for agents instead; any other 402 is an exhausted usage limit on the account that pays for the run. 403 is a token without permission for that Actor or storage.

Source: Apify API: authentication; Apify documentation: agentic payments with x402; Apify API: run Actor synchronously and get dataset items

n8n says Install this node to use it after import. Why?

The workflow names a node or node version your instance does not have, usually a community node. The workflows here use only built-in nodes at versions n8n has shipped since 1.80, so they import on n8n Cloud and older self-hosted instances without community nodes.

Source: n8n issue: unrecognized node type after import

Why does the HTTP Request node time out before Apify answers?

Set the node's Timeout option to at least 300000 ms so n8n waits as long as Apify's synchronous endpoint. The workflows here already set 310000. A failure at exactly 30 seconds points to a proxy in front of n8n.

Source: n8n HTTP Request node documentation

Every fix in one place

Same data in an agent

Want Claude, Cursor or ChatGPT to call the Actor directly instead of on a schedule? The TripAdvisor Guest Review & Rating Extractor page has MCP configs for eight clients and a SKILL.md. The Tripadvisor MCP server bundles every Tripadvisor Actor in one URL.