📋Save PayPal Email Receipts in Google Spreadsheet

1. Overview

\[ \begin{array}{l} \textbf{You can automatically save PayPal email receipts into a Google Spreadsheet --} \\ \text{using Google Apps Script to read Gmail messages and extract transaction details.} \\ \textbf{This creates a central record of PayPal payments --} \\ \text{that can be sorted, analyzed, and filtered directly in Google Sheets.} \end{array} \]

2. Core Steps

\[ \begin{array}{ll} \mathbf{Step\ 1:} & \text{Create a new Google Spreadsheet for storing PayPal receipts.} \\ \mathbf{Step\ 2:} & \text{In Gmail, ensure PayPal receipts are easily searchable (label them if possible).} \\ \mathbf{Step\ 3:} & \text{Open Apps Script from Google Sheets (Extensions} \rightarrow \text{Apps Script).} \\ \mathbf{Step\ 4:} & \text{Write a script to search Gmail for PayPal receipt emails.} \\ \mathbf{Step\ 5:} & \text{Extract details like date, amount, and sender from the email body.} \\ \mathbf{Step\ 6:} & \text{Append the extracted data into the spreadsheet.} \\ \mathbf{Step\ 7:} & \text{(Optional) Set a daily trigger to keep the sheet updated automatically.} \end{array} \]

3. Sample Google Apps Script

<!-- Apps Script to save PayPal email receipts into Google Sheets -->
function savePayPalReceipts() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  sheet.appendRow(["Date", "Amount", "Sender", "Subject"]);
  
  // Search for PayPal receipts in Gmail
  var threads = GmailApp.search('from:[email protected] subject:"Receipt"');
  
  for (var i = 0; i < threads.length; i++) {
    var messages = threads[i].getMessages();
    for (var j = 0; j < messages.length; j++) {
      var msg = messages[j];
      var date = msg.getDate();
      var subject = msg.getSubject();
      var body = msg.getPlainBody();
      
      // Example: Extract amount using regex
      var amountMatch = body.match(/\$\d+(\.\d{2})?/);
      var amount = amountMatch ? amountMatch[0] : "Not Found";
      
      sheet.appendRow([date, amount, msg.getFrom(), subject]);
    }
  }
}

4. Important Notes

\[ \begin{array}{l} \text{• The Gmail search query can be adjusted for your PayPal account language or format.} \\ \text{• Regex extraction may need updates if PayPal changes its email template.} \\ \text{• Be mindful of GmailApp daily quota limits.} \\ \text{• Consider storing the message ID to avoid processing the same receipt multiple times.} \end{array} \]

5. Conceptual Flow (in LaTeX)

The process can be described as:

\[ \text{Gmail (PayPal Receipts)} \xrightarrow{\text{Apps Script}} \text{Google Sheets Transaction Log} \]

Where: \[ \text{Logged Data} = \{\text{Date}, \text{Amount}, \text{Sender}, \text{Subject}\} \]