All templates

Automated Ramp Missing Receipt Chaser

Every Monday, WebRun opens Ramp, finds all transactions still missing a receipt, drafts a polite per-employee reminder email in Gmail, logs the outstanding items in a Google Sheet for your finance team, and queues the emails for your review before they are sent.

Runs on WebRun · Strict Lockdown policy
Every Monday at 9:00 AM WebRunorchestrates each step
1 Ramp find transactions missing receipts
2 Google Sheets log outstanding receipt gaps
3 Gmail draft reminder emails for review
In short

How do I automatically chase employees for missing Ramp receipts?

WebRun checks Ramp every Monday for transactions missing receipts, logs every gap in a Google Sheet by employee and amount, and drafts a per-employee reminder in Gmail for your finance team to review and send. No reminder goes out automatically, keeping your team in control while the books stay clean.

  • Receipt gaps caught weekly instead of at month-end close
  • Finance team gets a Google Sheet log with no manual lookup
  • Reminder drafts ready to send in one click after human review

Built for finance teams · accountants · controllers · small business owners

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

  2. 1
    Ramp - find transactions missing receipts
    ramp.com
    WebRun in Ramp: find transactions missing receipts
    WebRun opens Ramp to find transactions missing receipts.
    • Open Ramp and navigate to Transactions, filter to items with no receipt attached
    • Group missing receipts by employee, noting transaction date, merchant, and amount
    • Exclude any transactions below your de-minimis receipt threshold

    Done when Every transaction missing a receipt is listed by employee with its details.

  3. 2
    Google Sheets - log outstanding receipt gaps
    google.com
    WebRun in Google Sheets: log outstanding receipt gaps
    WebRun opens Google Sheets to log outstanding receipt gaps.
    • Open the Receipt Tracker sheet (or create it on first run)
    • Append a row for each missing-receipt transaction with employee, date, merchant, amount, and status
    • Mark any items that were outstanding last week and are now resolved as cleared

    Done when Sheet reflects the current week's outstanding and newly cleared receipt items.

  4. 3
    Gmail - draft reminder emails for review
    gmail.com
    WebRun in Gmail: draft reminder emails for review
    WebRun opens Gmail to draft reminder emails for review.
    • Draft a short, polite reminder email for each employee listing their specific missing transactions
    • Leave every draft in Gmail Drafts for your finance manager to review before sending
    • Do not send any email automatically

    Done when One draft email per employee with missing receipts is waiting in Gmail Drafts for review.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
app.ramp.com/transactions
ScheduleRuns automatically on this cadence
Every Monday at 9:00 AM
DeliveryHow each run's result reaches you
Receipt gap log · Google Sheets
OutputWhat each run produces - A Google Sheet log of all open missing-receipt transactions plus one draft Gmail reminder per employee, queued for human review before sending.
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

Will it email employees automatically?

No. WebRun drafts each reminder in Gmail and leaves it for your finance manager to review and send. No email goes out without a human check.

What transactions are included in the chase?

All Ramp transactions above your de-minimis threshold that have no receipt attached as of Monday morning. You set the threshold once during setup.

Does it track which employees ignore repeated reminders?

Yes. The Google Sheet logs whether an item was outstanding the prior week, so chronic offenders are visible to your finance team at a glance.

Put this on autopilot.

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