All templates

Automated PayTabs Settlement Exports

Every morning, WebRun opens the PayTabs merchant dashboard, pulls yesterday's settlement report with each transaction's amount and fees, exports the full breakdown to Google Sheets, and emails you a short confirmation once the ledger is up to date.

Deploy this workflow Browse all templates
Runs on WebRun · Strict Lockdown policy
Every day at 7:30 AM WebRunorchestrates each step
1 PayTabs pull the settlement report
2 Google Sheets export the transaction breakdown
3 Gmail email the export confirmation
In short

How do I export my PayTabs settlement report automatically?

WebRun pulls your PayTabs settlement report every morning, exports each transaction's amount and fees to Google Sheets, and emails you a confirmation once the ledger is current. It never releases funds or issues a refund itself, so your settlement records stay up to date without a manual export from the merchant dashboard.

  • Every settlement report lands in Sheets without a manual export
  • The monthly ledger total stays current day to day
  • Flagged transactions stay visible instead of buried in the dashboard

Built for merchants using PayTabs · ecommerce finance teams · MENA region retailers · payments operations

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

  2. 1
    PayTabs - pull the settlement report
    paytabs.com
    WebRun in PayTabs: pull the settlement report
    WebRun opens PayTabs to pull the settlement report.
    • Open the PayTabs merchant dashboard and pull yesterday's settlement report
    • Capture the settlement total, transaction count, and fees deducted
    • Note any transaction marked failed or under review

    Done when Yesterday's settlement report is captured with its transaction breakdown.

  3. 2
    Google Sheets - export the transaction breakdown
    google.com
    WebRun in Google Sheets: export the transaction breakdown
    WebRun opens Google Sheets to export the transaction breakdown.
    • Add a row for each transaction in the settlement with its amount and fees
    • Update the running monthly settlement total
    • Skip any transaction already exported from a prior run

    Done when Every transaction in the report has a row in the settlement sheet.

  4. 3
    Gmail - email the export confirmation
    gmail.com
    WebRun in Gmail: email the export confirmation
    WebRun emails the export confirmation through Gmail.
    • Email a short confirmation once the sheet is updated
    • Include the settlement total and any flagged transaction count
    • Send it to your own inbox as a daily record

    Done when You have an emailed confirmation the ledger is current.

Run settings

How is each run configured?

Starting pageWhere Chrome opens at the start of each run
www.paytabs.com
ScheduleRuns automatically on this cadence
Every day at 7:30 AM
DeliveryHow each run's result reaches you
Settlement export · Google Sheets
OutputWhat each run produces - A daily settlement ledger in Google Sheets with every transaction's amount and fees, plus an emailed confirmation.
Report
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 WebRun release funds or issue a refund from the settlement?

No. WebRun never sends a payment, issues a refund, or transfers funds on its own. It only reads and exports the settlement report, leaving any payout or refund action for you to approve.

Does it export a transaction twice?

No. It checks the settlement sheet before adding a row, so a transaction already exported from an earlier report is skipped.

What happens if a transaction is flagged for review?

It still exports to the sheet, marked with its flagged status, so review items stay visible in the ledger instead of getting lost.

Keep going

Related templates

Automated Adyen Settlement and Decline Digests
Every morning, WebRun checks Adyen for yesterday's settlements and declined payments, posts a digest to Slack, and pings Telegram if the decline rate spikes.
Adyen›Slack›Telegram
Automated Affirm Flagged Order Tracking
WebRun checks Affirm for orders flagged as canceled, disputed, or under review, logs each one in Airtable, and drafts a summary email so nothing sits unnoticed.
Affirm›Gmail›Airtable
Automated Afterpay Payout Reconciliation
WebRun matches each Afterpay settlement batch against your order log in Google Sheets and drafts a Gmail note for accounting whenever a payout doesn't line up.
Afterpay›Google Sheets›Gmail

Put this on autopilot.

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

Deploy this workflow Talk to us