Parse Received Paypal Receipts in Google Sheets

This recipe will take emails I receive from Paypal notifying me of a payment and put them into Google Sheets. The additional formulas parse out the fields in those Paypal emails. In order for this to work you need to place your field names (e.g. Customer name, Customer ID) in row 1 column E-O. The body of the email will be in column D. !!!!!Hide column D or it will be very big and unreadable.!!!! It uses MID to select the substring between the field names using find and indirect to offset. It's very hacky but it works. Hoping more sheets triggers will be added :)

by rivercitylabs

Learn more

150 Users Enabled This Applet 150
works with
  • Google Sheets

Applet version ID 281926