eBay to Google Sheets Bookkeeping Export (Runs Weekly)

PromptCreate

Every Monday at 7:00am, on a weekly cron schedule, export the prior week's eBay finances into my Google Sheets bookkeeping tab. This is a deterministic bookkeeping export: one row per record, a fixed field mapping, and no summarization or interpretation, so my accountant always has a clean weekly reconciliation feed.

First, compute the date range for the prior week (the previous Monday through Sunday, ending just before this run). Use that same date range for every eBay call below.

Call eBay Get Payouts (Finances API) for payouts that settled within that date range. Treat each payout as one record.

Call eBay Get Transactions (Finances API) for the underlying activity in the same date range: the individual sales, fees, and refunds. Treat each transaction as one record.

For every payout and every transaction, write one row to the Google Sheets bookkeeping tab using Google Sheets Append Values. Each row must contain, in a fixed column order: the date (the payout settlement date for payouts, the transaction date for transactions), the record type (for example payout, sale, fee, or refund), the order or payout reference, the gross amount, the fees, the net amount, and the currency. Append the payout rows and the transaction rows so the tab grows by exactly one row per record. Do not merge, net, or summarize records, and do not interpret the data.

Frame this for a US-marketplace seller: target the US marketplace (EBAY_US) on the eBay calls. Note that the eBay Finances API is hosted on apiz.ebay.com, and that due to EU and UK payments regulations an additional Digital Signature security verification is required for all Finances API methods made on behalf of EU or UK sellers. If this seller operates in the EU or UK, that verification must be configured for the Get Payouts and Get Transactions calls to succeed.

What does this prompt do?

Runs automatically every Monday morning and pulls in last week's eBay money movements.
Logs each payout that settled during the week alongside the individual sales, fees, and refunds behind it.
Writes one row per record to your Google Sheets bookkeeping tab with the date, type, order reference, gross amount, fees, net amount, and currency.
Gives your accountant a consistent, ready-to-reconcile feed with no manual copying or interpretation.

What do I need to use this?

An eBay seller account with payouts enabled
A Google account with a Google Sheets spreadsheet for bookkeeping
A dedicated tab (with column headers) where the weekly rows should be added
This is set up for US-based eBay sellers; sellers in the EU or UK may need an extra eBay security verification to access financial data

How can I customize it?

Change the day and time it runs, for example the first business day of each month instead of every Monday.
Point it at a different spreadsheet or tab, or reorder the columns to match your accountant's template.
Adjust the date range it covers, for example switching from last week to last month.

FAQs

Does this change anything on my eBay account?

No. It only reads your payout and transaction history. It never edits listings, orders, prices, or money.

What ends up in each row?

Each row holds one record with its date, type (payout, sale, fee, or refund), order or payout reference, gross amount, fees, net amount, and currency.

How often does it run?

By default every Monday at 7am, covering the previous week. You can change it to run daily, monthly, or on any schedule you prefer.

Will it create duplicate rows?

Each run adds the records for its date range, so keep the schedule and the date range aligned (one week per weekly run) to avoid overlapping entries.

Does it work for sellers outside the US?

It is designed for US-based sellers. EU and UK sellers can use it too, but eBay requires an extra security verification to access financial data in those regions.

Related templates

Weekly Amazon S3 bucket security audit posted to Slack

Every Monday, check every S3 bucket for public exposure, missing encryption and weak backup settings, then get the risks ranked in Slack.

Agentic Task

Turn procurement portal tenders into CRM deals each morning

Every weekday at 7am, sign in to the tender portals you track, filter new notices against your bid criteria, and open a deal for the ones worth chasing.

+1

Agentic Task

Draft polite follow-ups for emails that never got a reply

Every weekday at 4pm, spot the threads that went quiet, stage a ready-to-send nudge in your mailbox, and get a ranked Slack recap.

Agentic Task

Flag VIP client emails in Zoho Mail and alert your team

Keep a spreadsheet of your most important senders, and every email from one gets labeled, posted to your team channel, and logged automatically.

Deterministic Code

Send Yotpo review requests when Shopify orders ship

The moment an order is fulfilled, we register it with Yotpo so the review request is timed off real delivery, and we log every sync so failures never go unnoticed.