PayPal
Google Sheets + PayPal Integration
Query from PayPal into Google Sheets
What is Sheet Director?
Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho, PayPal, etc.
It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on.
What is PayPal?
Money Is Moved Automatically.
By checking out using PayPal, the winning buyer automatically triggers a transfer of funds from their preferred payment method (either credit card or bank account) into his or her PayPal account
PayPal to Google Sheets: Use Case(s)
> Pull data from PayPal objects and store it into a spreadsheet - Query
PayPal
Sheet Director
Google Sheets
Setting up PayPal in Sheet Director
Choose App and Service:
Select PayPal from the list of applications.
Select service as Query.
Connect PayPal with OAuth2
PayPal Configuration
Choose the authentication type as OAuth2
Choose the environment
Click on connect to PayPal to connect to PayPal so that you can pull data.
If PayPal is connected successfully the following screen appears.
Select the required entity
Select the Filters as required.
Filters include fields, matches, value.
Select the maximum result that is required.
Destination Settings:
Configure the destination settings to save the executed data.
Connect PayPal with Client Id/ Secret
PayPal Configuration
Choose the authentication type as Client Id/ Secret
Choose the environment
Enter your App Client Id provided by PayPal
Enter your App Client Secret provided by PayPal
Click on connect to PayPal to connect to PayPal so that you can pull data.
To get your Client App credentials
Go to https://developer.paypal.com/developer/applications/ and click on Login into Dashboard if you have not logged in.
Click on Create App in order to get the credentials.
Give any App Name & Create the app.
Click on App Name and you will see the credentials.
Click on the Show button to get the Client Secret. If the secret is not present you can generate the new one.
If PayPal is connected successfully the following screen appears.
Select the required entity
Select the Filters as required.
Filters include fields, matches, value.
Select the maximum result that is required.
Connect PayPal with Ancient(NVP/SOAP) API
PayPal Configuration
Select Ancient(NVP/SOAP API)
For this you need to provide you API credential information
Enter your API Username provided by PayPal
Enter Your API Password provided by PayPal
Enter your signature provided by PayPal
Click on "CONNECT TO PAYPAL"
To get API credential
Login to your Paypal account
Select Tools in tool bar
Select All Tools
Select API credentials on the grid
Here you have to click Manage API credentials on "NVP/SOAP API integration (Classic)"
Here you can get your credential by clicking show
If PayPal is connected successfully the following screen appears.
Select the required entity
Select Start date
Select End date
Select the Filters as required.
Filters include fields, matches, value.
Select the maximum result that is required.
Select the destination sheet to save the data or create a new sheet by clicking the Add new icon.
Click on execute to pull the data into sheet
Click save to save the service
