Query from PayPal into Google Sheets
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.
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
Choose App and Service:
Select PayPal from the list of applications.
Select service as Query.
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.
Configure the destination settings to save the executed data.
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.
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.
Click on execute to pull the data into sheet.
Click save to save the service.
Entity
Select the entity object that you need to post to
Select Apply Template or Setup Mapping
Select Apply Template to add a default template.
Select Setup Manually to select manually.
Source Sheet
Choose the sheet that contains post records.
Enter the Start at cell value
(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)
Select the Status column
If status column is not there, simply click the +button to add the status header on your sheet(A status column will be created in Spreadsheet)
Select the Result column
If result column is not there, simply click the +button to add the result header on your sheet(A result column will be created in Spreadsheet)
Mapping
After selecting the entity it will ask for intelligent mapping
If you need to do intelligent mapping click on yes
Intelligent mapping will map the matching fields automatically
You can do manual mapping by selecting Column drop down
You can delete the field by click on delete icon on top of each filed map
You can't delete mandatory* fields
Click on execute will ask for confirmation
Click save to save the service
It will show the number of records ready to post
Click post now to post the records on PayPal
It will show the count of number of records posted successfully and failed to post.