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

Google Sheets + PayPal Integration

What is Sheet Director?

What is PayPal?

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

Connect PayPal with OAuth2

Destination Settings:

Connect PayPal with Client Id/ Secret

To get your Client App credentials

Connect PayPal with Ancient(NVP/SOAP) API

To get API credential

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.