Shortlist business-trip hotels into a Google Sheet

Tools

Claude in Chrome

Overview

Guides · Claude · updated jul 30, 2026

Workflow

Guides · Claude · updated jul 30, 2026 Set up Claude to control your browser and automate repetitive hotel research for business travel. Introduction Set up Claude to control your browser and automate repetitive hotel research for business travel. You’ll create a Claude in Chrome shortcut that searches current hotel pricing and availability, then returns recommended hotels in a Google Sheet. Once launched, the hotel research should take about 10–15 minutes to come back. Step-by-step 7 steps Instructions 1 Step 1 of 7 Set up Claude in Chrome Navigate to Claude for Chrome in the Chrome Web Store.Click “Add to Chrome” to install the Claude in Chrome extension. Set up Claude in Chrome Navigate to Claude for Chrome in the Chrome Web Store. Click “Add to Chrome” to install the Claude in Chrome extension. Included with Pro Download the PDF for this guide Keep a PDF copy to follow offline or share with your team. PDF Use Claude’s Chrome Extension to Quickly Book Business Trips Unlock with Pro $29/mo, cancel anytime Included with Pro Keep a PDF copy to follow offline or share with your team. PDF Use Claude’s Chrome Extension to Quickly Book Business Trips $29/mo, cancel anytime 2 Step 2 of 7 Create a hotel research shortcut Before running hotel research, create a shortcut that handles the filtering automatically. In the Chrome extension, type /shortcuts and click “Create Shortcut.”Name it /hotel-picker.Add this prompt: Prompt Copy When searching for hotels on Booking.com: 1. Property Type: Always use the “Property type” checkbox on the left sidebar to select “Hotels” only. This filters out boutique hotels, Airbnbs, vacation rentals, and full properties. Only show traditional hotels. 2. Distance from City Center: If the user specifies a distance requirement, such as “within 1 mile of downtown,” use the “Distance from city center” checkboxes on the left sidebar to select the appropriate range. 3. Property Rating: Default to 4 stars and up by using the property rating filter unless the user explicitly requests a different star rating. This ensures you’re showing reputable, quality hotels. 4. Review Quality: Find the top 10 hotels based on the user’s criteria and user reviews. Check both Booking.com reviews and cross-reference with TripAdvisor to verify quality and reputation. Prioritize hotels with high ratings, such as 8.5+ on Booking.com and 4+ stars on TripAdvisor, and recent positive reviews. 5. Search for modern, clean properties: When reviewing options, prioritize hotels that appear modern and well-maintained in photos. Look for amenities like rooftop bars, pools, fitness centers, and modern decor when available. Return the top 10 options sorted by best overall value considering price, location, reviews, and amenities. Set “Start from” to booking.com.Save the shortcut. Create a hotel research shortcut Before running hotel research, create a shortcut that handles the filtering automatically. In the Chrome extension, type /shortcuts and click “Create Shortcut.” Name it /hotel-picker. Add this prompt: Set “Start from” to booking.com. Save the shortcut. 3 Step 3 of 7 Set up your Google Sheet Go to Google Sheets.Create a new spreadsheet with the headers shown below. Copy the spreadsheet URL. Set up your Google Sheet Go to Google Sheets. Create a new spreadsheet with the headers shown below. Copy the spreadsheet URL. 4 Step 4 of 7 Test your shortcut Prompt Copy I’m traveling to [location] from [date]. Find hotels within 1 mile of downtown under [price per night]. I already have a spreadsheet set up at [YOUR SPREADSHEET URL HERE] — navigate to it and add a row for each hotel with: name, price per night, rating, distance to downtown, key amenities, and booking link. Sort by best value. It should take 10–15 minutes to get your list of hotel recommendations back. Test your shortcut It should take 10–15 minutes to get your list of hotel recommendations back.

Reported result

The source claims the automated research takes 10–15 minutes to return a ranked list of top 10 hotels. However, no actual execution data, success rates, or verified outcomes are provided in the text. A measurable acceptance check would be to time the process and verify that the Google Sheet contains exactly 10 rows with valid booking links and prices matching the current site data.

Human role

The original post does not say how a person stayed involved.

Limitations

Requires a Claude Pro subscription ($29/mo) and the Chrome extension. The workflow depends on Booking.com's UI structure; changes to the site may break the shortcut. Users must avoid interacting with the active tab to prevent errors. Anti-bot protections may require manual intervention to slow down typing. Source reliability is secondary as it is a guide, not a case study.

Try it

Act as a travel assistant using Claude in Chrome. I need to find hotels for a business trip to [replaceable: City Name] from [replaceable: Start Date] to [replaceable: End Date]. My budget is [replaceable: Price] per night. I have a Google Sheet ready at [replaceable: Spreadsheet URL] with headers: Name, Price, Rating, Distance, Amenities, Link. Please use the /hotel-picker shortcut to search Booking.com. Filter for 'Hotels' only, within [replaceable: Distance] of downtown, and 4+ stars. Cross-reference reviews with TripAdvisor. Populate the sheet with the top 10 options sorted by value. Do not book anything. First, perform a dry run for [replaceable: Sample City] and show me the output format before proceeding with the actual trip. If the site layout has changed or anti-bot measures trigger, pause and ask for guidance.

More cases · Everyday life

• Scrub your phone number from data brokers to stop spam
• Search flights with airline constraints using Comet
• Decide between points and cash for every trip
• Extract school dates from forwarded emails and flyers
• Search for a wedding flight to New York