Copy PayPal transactions into Google Sheets automatically

Short answer: Use a free Google Apps Script that copies your PayPal business transactions into a Google Sheet every hour, with the amount, status and payer email. It runs in your own Google account; nothing is sent to us. Setup takes 4 steps: Make a PayPal app; Add your key; Paste the script; Run it.

How to set it up

1. Make a PayPal app. At developer.paypal.com, log in with your business account, choose Apps and Credentials, switch to Live and create an app. Make sure Transaction search is ticked in its features.
2. Add your key. In the Apps Script editor, open Project Settings and add the Script properties PAYPAL_CLIENT_ID and PAYPAL_SECRET. Copy both values from your app's page. Keys stay in the script, never in the sheet.
3. Paste the script. Open Extensions, then Apps Script, paste in the code from our email, and save. Reload the sheet and a PayPal menu appears.
4. Run it. Choose PayPal, then Copy transactions. The PayPal tab fills in with the date, transaction ID, amount, currency, status, payer email and note for the last 30 days. Choose Copy transactions every hour to keep it up to date.

Want this set up for your business? Free written scope in 20 minutes

Get the script

Good to know

• PayPal adds transactions to this report up to 3 hours after they happen, so the newest ones appear on a later run.
• Each transaction is added once, matched on its ID.
• Fees and refunds come through as their own rows.

Questions

What does this script do?

It is a free Google Apps Script that copies your PayPal business transactions into a Google Sheet every hour, with the amount, status and payer email.

How do I set it up?

In 4 steps: 1. Make a PayPal app; 2. Add your key; 3. Paste the script; 4. Run it. The full steps are on this page.

Is it free, and does it send my data anywhere?

It is free: enter your email on this page and we email you the script (Code.gs). It runs in your own Google account; nothing is sent to us.

Can you install it for me?

Yes. We set it up in your Google account in a short Connect session, connect it to your sheet and check that it runs.

Want it wired into QuickBooks, your CRM or your payment system? Send us a short brief.