Log Shopify Payments Payouts to Google Sheets Weekly

3 min setup
No coding required
Runs automatically

Reconciling Shopify Payments deposits against your bank means copying payouts out of the admin. This workflow does it every week: it pulls the week's payouts with their gross, fees and net amounts and adds them to a Google Sheet for your bookkeeper.

schedule icon
Every Monday morning
Get last week's payouts from Shopify Payments
google sheets logo icon
Add each payout as a row in Google Sheets

How it works

3 steps to keep a running payout log ready for bookkeeping

schedule icon

Every Monday morning

App connector: Schedule • Time to complete: 1 minute

Runs once a week.

Get last week's payouts from Shopify Payments

App connector: Shopify • Time to complete: 1 minute

Get payouts dated in the previous 7 days, with date, status, amount and the summary of charges, refunds, adjustments and fees.

google sheets logo icon

Add each payout as a row in Google Sheets

App connector: Google Sheets • Time to complete: 1 minute

Add one row per payout: payout date, ID, status, gross charges, refunds, fees, adjustments and net amount.

Trusted by 1,000+ merchants
Logo: Rothy's Logo: Adidas Logo: Allure Logo: GQ Logo: DraftKings Logo: Chubbies Logo: Made In Cookware Logo: MUD/WTR

Ready to keep a running payout log ready for bookkeeping

Get setup in 3 minutes.

Use this template →

FAQs

Will payouts be added twice?

No. Each run only pulls payouts from the previous 7 days.

Can I backfill older payouts?

Run it once by hand with a wider date range to fill in history.

Does it work with QuickBooks or Xero?

This writes to Sheets. You can add a QuickBooks or Xero step to record each payout as a deposit.

Personalize this template

Customize this workflow even further:

Set custom delays
Schedule actions to trigger after a set time period, such as sending follow-up emails 3 days after an event.
Chain multiple actions
Connect several steps together in one workflow, like tagging data, updating records, and notifying your team simultaneously.
Store data in tables
Save order details, customer preferences, or custom metrics in your own database for reference and reporting.
Deploy AI agents for smart decisions
Let AI agents evaluate complex scenarios and choose the right action path based on your defined rules.

You're in good company

"MESA has been a game changer for us. And, if you ever get stuck, their support team is always super helpful."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
PetFriendly

"It's like Zapier but exactly designed for Shopify. I have been able to complete all the workflows that I've needed."

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Zailys

"The MESA team has been amazing at helping us set up our automations. We would highly recommend this app!"

  • Ico star
  • Ico star
  • Ico star
  • Ico star
  • Ico star
Rothy's

keep a running payout log ready for bookkeeping

3 min setup • Fully supported if you need help