All templates

Automated Ramp Out-of-Policy Expense Approval Queue

Every morning, WebRun opens Ramp, collects all transactions currently pending out-of-policy review, ranks them by dollar amount and exception type, appends them to a Google Sheet audit log, and posts the day's approval queue to Slack so nothing sits unapproved past 24 hours.

Runs on WebRun · Strict Lockdown policy
Every day at 8:00 AM WebRunorchestrates each step
1 Ramp collect out-of-policy transactions pending approval
2 Google Sheets append to audit log
3 Slack post ranked approval queue
In short

How do I automatically queue out-of-policy Ramp expenses for approval?

WebRun opens Ramp each morning, collects every out-of-policy transaction awaiting approval, ranks them by dollar amount, appends them to a Google Sheet audit log, and posts the queue to Slack. Finance managers get a one-click approval queue every day, and no exception ages unreviewed.

  • No out-of-policy exception sits unapproved more than 24 hours
  • Largest exceptions always reach the approver first
  • Full Google Sheet audit trail with no manual logging

Built for finance managers · controllers · CFOs · operations leaders

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 app.ramp.com/expenses in a real browser with your saved login - no setup, no API keys.

  2. 1
    Ramp - collect out-of-policy transactions pending approval
    ramp.com
    WebRun in Ramp: collect out-of-policy transactions pending approval
    WebRun opens Ramp to collect out-of-policy transactions pending approval.
    • Open Ramp and navigate to the approvals or policy exceptions view
    • Collect all transactions pending an out-of-policy approval, noting employee, amount, merchant, and exception type
    • Sort by dollar amount descending so largest exceptions are first

    Done when All pending out-of-policy items are collected and ranked by amount.

  3. 2
    Google Sheets - append to audit log
    google.com
    WebRun in Google Sheets: append to audit log
    WebRun opens Google Sheets to append to audit log.
    • Open the Out-of-Policy Approval Log sheet (or create it on first run)
    • Append a row for each new exception with date, employee, amount, merchant, exception type, and current status
    • Skip items already logged today to avoid duplicates

    Done when Sheet has a complete audit trail of all out-of-policy exceptions seen today.

  4. 3
    Slack - post ranked approval queue
    slack.com
    WebRun in Slack: post ranked approval queue
    WebRun opens Slack to post ranked approval queue.
    • Post the ranked approval queue to the finance Slack channel, highest amount first
    • Include a Ramp direct link for each item so the approver can act in one click

    Done when Finance manager has today's ranked out-of-policy approval queue in Slack.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.ramp.com/expenses
ScheduleRuns automatically on this cadence
Every day at 8:00 AM
DeliveryHow each run's result reaches you
Approval queue · Slack
OutputWhat each run produces - A Google Sheet audit log of all out-of-policy Ramp exceptions plus a daily Slack queue ranked by dollar amount with direct approval links.
Text
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

Does WebRun approve or reject any exceptions automatically?

No. WebRun only surfaces and ranks the queue. Every approval or rejection is made by a human in Ramp. The tool never changes the status of any transaction on its own.

How is the queue ranked?

By dollar amount descending, so your highest-value exceptions are at the top of the Slack list each morning and get human attention first.

Can we keep a record of all exceptions over time?

Yes. Every exception is appended to a Google Sheet on each run, building a searchable audit trail of every out-of-policy item and when it was flagged.

Put this on autopilot.

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