This tutorial will teach you the steps to add PayPal transactions to Google Sheets using the help by Google Apps Script. It is possible to import regular PayPal payments as well as recurring subscriptions or donations, as well as refunds and chargebacks to Google Sheets.
After the data has been transferred into Google Sheets and you are able to export it to the format of a CSV file, and import the data in QuickBooks Accounting software. Tally customers from India are able to export PayPal transaction data to Google Sheets into XML format and then import them in bulk to Tally.
Import PayPal Transactions in Google Sheets
In this case we will import the donors' names in Google Sheets who have made the donation through PayPal.
1. Create API credentials in PayPal
Sign-in to your PayPal developer dashboard (developer.paypal.com) and create a new app in the live mode. Give your app an initial name: the Transaction Importer app for Google Sheets and then click on"Create App.
PayPal will generate an Client ID and a Client Secret key which you'll need in the next step. In the Live App settings section, select for the Transaction Search option and turn off any other options because we will only use API keys to show transactions, and not have any other functions. Click Save to proceed.
2. Create a Google Sheets Project
Visit sheets, new for the option to make a fresh Google Sheet. Select the Extensions menu, then select Apps Script to launch Apps Script editor.
Copy and paste the code in the editor. Make sure to replace the transaction number using your unique code. T0002 is a good option for PayPal Subscriptions T0014 for Donation payments, and T1107 for PayPal refunds and chargebacks.
The @OnlyCurrentDoccomment is an Google Apps Script comment that instructs Google Apps Script to only run the code in your current Google Sheet and not require access to any other spreadsheet that is stored in the Google Drive.
3. Run PayPal Import Function
In the editor for scripts, click "Run" to transfer the transactions from PayPal. It is possible that you need to authorize the script as it needs permissions to connect with the PayPal API and also write data into Google Sheets on your behalf.
That's it. If there's any PayPal transactions to import within the specified date range the script will be start then the data will be transferred in Google Sheets.
In the next section of this tutorial, you will be learning how to export PayPal transactions in Google Sheets to an XML file that can be imported to Tally the accounting program.