Integrating Paypal Transactions Into Google Sheets
sarahbolty
Contributor
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Posted on
Feb-25-2020
11:31 AM
Hello, I would like to have Paypal transactions integrated into Google Sheets. I see that I can use workflows provided by Zapier or Automate.io but those require a paid subscription to those services. Does anyone know how I can do this without subscribing to paid solutions? Can Paypal provide this feature to its customers without us having to seek third party solutions?
1 REPLY 1
SimpleDJs
Contributor
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep-13-2020
08:20 AM
I know the 'means' which is Google Script editor. I know there IS a free 'Google Sheets AddOn' (by a third party, but free and addable) which operates as an html based sidebar. My personal use project, is trying to use script editor and get it to get my current Paypal balance, and putthat value to a cell on sheet. Part 1 get access token from paypal Part 2 use token to authenticate and get my current balance Part 3 put balance in a cell. (BTW I am very very new to coding). Sofar, (via Google Sheets, using the Script editor) I can get the 'access token' needed, (part 1.. works, check!)and I'm at a snag getting it to authenticate and get my balance, and part 3, is easy (very simple to put values in cells) I agree, I wish Paypal (official) had some kind of Google Sheets (official) integration, perhaps something that on user end, works as a sheets formula, such as (example idea) "=PAYPAL(yourpaypaluseremail)" [of course some safety confirm etc, such as an "export to GSheets" on the paypal site, where you could enter the google sheets spreadsheet URL allowed to get your balance.] Just n idea for the Official Paypal/Google to consider. Till then, you can use the addon I mentioned, or, like me, learn/make your own. (When/if I have my script fully functional, working, etc.. I'll be sure to post it)
Haven't Found your Answer?
It happens. Hit the "Login to Ask the community" button to create a question for the PayPal community.
Related Content
- Best Payment Gateway for Seamless Transactions: Does Anyone Use PayPal with CapCut Services? in PayPal Payments Standard
- Send Transactions to Google Sheet in PayPal Payments Standard
- TXN_DECLINED for all transactions made through my Stripe Integration in PayPal Payments Standard
- Javascript SDK orders complete with no error, but no transactions appear in Activity. in SDKs
- Enable recurring payments/Reference Transactions - Adyen PayPal Drop-in integration - Sandbox Env in Sandbox Environment