All templates

Automated British Airways Booking Export

Every Monday, WebRun opens British Airways, reviews every upcoming booking across the team, exports the traveler, cost, dates, and fare class to a shared Google Sheet, and emails finance a summary of committed spend.

Runs on WebRun · Strict Lockdown policy
Every Monday at 8:30 AM WebRunorchestrates each step
1 British Airways review upcoming bookings
2 Google Sheets export booking details
3 Gmail email finance the summary
In short

How do I export upcoming British Airways bookings to a shared sheet?

WebRun reviews your company's upcoming British Airways bookings every Monday, exports each one's traveler, cost, dates, and fare class to a shared Google Sheet, and emails finance a summary of committed travel spend with any balance still due. It keeps the travel budget visible without anyone compiling bookings by hand.

  • Committed travel spend is visible in one sheet, updated weekly
  • Finance sees balances due before the invoice arrives
  • No one has to manually copy booking details out of British Airways

Built for Travel coordinators · Finance and operations teams · Small business owners who travel · Executive assistants

Step by step

What does WebRun do on every run?

The exact actions WebRun takes, in order - in plain language, so you can adjust anything.

  1. WebRun signs in and gets to work

    Opens www.britishairways.com in a real browser with your saved login - no setup, no API keys.

  2. 1
    British Airways - review upcoming bookings
    britishairways.com
    WebRun in British Airways: review upcoming bookings
    WebRun opens British Airways to review upcoming bookings.
    • Open British Airways and list all upcoming bookings across the team
    • Note the traveler, cost, dates, and fare class for each
    • Flag any booking with a balance still due

    Done when Every upcoming booking has been reviewed.

  3. 2
    Google Sheets - export booking details
    google.com
    WebRun in Google Sheets: export booking details
    WebRun opens Google Sheets to export booking details.
    • Add a row for each booking with traveler, cost, and dates
    • Update the status of any booking already logged
    • Total committed travel spend for the month

    Done when The travel tracker sheet reflects every current booking.

  4. 3
    Gmail - email finance the summary
    gmail.com
    WebRun in Gmail: email finance the summary
    WebRun opens Gmail to email finance the summary.
    • Draft a summary email listing this month's committed travel spend
    • Flag bookings with a balance still due
    • Send it to finance

    Done when Finance has this month's travel booking summary in their inbox.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.britishairways.com
ScheduleRuns automatically on this cadence
Every Monday at 8:30 AM
DeliveryHow each run's result reaches you
Booking export · Google Sheets
OutputWhat each run produces - A running sheet of every upcoming booking with traveler, cost, dates, and payment status.
Sheet
Setup & safety

Secure by default

Connect once, stays signed in

WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.

Your credentials stay in your own private environment - WebRun never stores your passwords.
Strict Lockdown

Every action is checked against this policy before it runs.

Domains ALLOWLIST
Typed input ALLOW
Shell command BLOCK
File uploads BLOCK
Runs in a contained environment More on policies
Good to know

Questions, answered

Will it book or change any travel for us?

No. WebRun only reads existing bookings and reports on them. Booking, changing, or canceling a trip is left to your travel coordinator.

How current is the spend total?

It rebuilds the total from live booking data each Monday, so it reflects any booking made or changed since the last run.

What if a booking is later canceled?

The next run picks up the current status from British Airways and updates the sheet, so canceled bookings stop counting toward committed spend.

Put this on autopilot.

Turn it on in minutes - or have our team set it up for you.