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

  • 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