Step 2: Connect MCP Search & Pagination Loop

Configure the Airbnb search tool call, merge loop state, and pagination checks that control repeated search requests.

1. Open Search Listings and set Tool Name to airbnb_search and Operation to executeTool.
2. Set Tool Parameters to { "location": "London", "adults": 7, "children": 1, "checkin": "2025-08-14", "checkout": "2025-08-17", "cursor": "{{ $json.cursor || '' }}" }.
3. Credential Required: Connect your mcpClientApi credentials in Search Listings.
4. In Initialize Loop State, set assignments to {{$json.loopCount || 0}}, {{$json.cursor || ''}}, and {{$json.all_listings || []}} for loopCount, cursor, and all_listings.
5. Configure Combine Inputs with Mode set to combine and Combine By set to combineByPosition to merge the search result and loop state.
6. In Pagination Check, confirm conditions: ={{$json.loopCount}} is lt 2 AND ={{ $json.cursor }} is notEmpty.
7. Note the parallel branch: Pagination Check outputs to both Initialize Loop State and Search Listings in parallel when conditions pass.

Step 3: Set Up Search Result Processing

Parse the raw search response, aggregate listings across pages, and compile a final summary object.

1. In Extract Search Results, keep the provided JavaScript to parse the search payload and emit metadata (loop count, cursor, and all listings).
2. Verify that Extract Search Results emits only metadata and routes to Pagination Check.
3. In Compile Final Output, keep the JavaScript that returns a final object with summary fields like location, checkin, and checkout.
4. Update values in Compile Final Output if you need a different summary (e.g., change "Da Nang" or date values).

Step 4: Configure Listing Flattening & Summary Output

Flatten the compiled listings into individual records and write summary data to a spreadsheet while passing IDs to the detail pipeline.

1. In Flatten Listing Items, keep the JavaScript that maps listings to flat output items.
2. Confirm the parallel flow: Flatten Listing Items outputs to both Append Summary Sheet and Map Identifier in parallel.
3. In Append Summary Sheet, set Operation to append.
4. Set Document ID to [YOUR_ID] and Sheet Name to gid=0.
5. Map columns using expressions such as ={{ $json.id }}, ={{ $json.url }}, and ={{ $json.total_price }}.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Summary Sheet.

Step 5: Configure Listing Detail Enrichment

Loop through listing IDs, fetch detailed data, transform it, and update the detail sheet.

1. In Map Identifier, ensure id is set with the expression ={{ $json.id }}.
2. Use Iterate Records to batch through IDs; it connects to Transform Listing Payload and to Fetch Listing Details for the loop.
3. In Fetch Listing Details, set Tool Name to airbnb_listing_details and Tool Parameters to { "id": "{{$json.id}}" }.
4. Credential Required: Connect your mcpClientApi credentials in Fetch Listing Details.
5. In Transform Listing Payload, keep the JavaScript that parses the listing payload and extracts fields like amenities, highlights, and description.
6. In Update Detail Sheet, set Operation to appendOrUpdate and map columns using expressions like ={{ $json.id }}, ={{ $json.amenities }}, and ={{ $json.description }}.
7. Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Detail Sheet.

Step 6: Test and Activate Your Workflow

Validate the entire pipeline end-to-end, confirm Google Sheets updates, and then activate for production use.

1. Click Execute Workflow from Manual Execution Start to run the pipeline.
2. Confirm Search Listings returns data and Extract Search Results emits metadata with loopCount and all_listings.
3. Verify Append Summary Sheet adds rows to your summary sheet and Update Detail Sheet appends/updates detail records.
4. Check the final output from Compile Final Output for total_listings and pages_processed.
5. When satisfied, toggle the workflow to Active to enable production use.