# Get Data from Emails to Spreadsheet (simple PayPal payment confirmation solution) **URL:** \ **Category:** Ask for Help\ **Created:** [May 14, 2021, 7:14am UTC](https://community.glideapps.com/t/get-data-from-emails-to-spreadsheet-simple-paypal-payment-confirmation-solution/26784 "2021-05-14T07:14:48Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Yevhen\_Lopukhin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yevhen_lopukhin/32/1410_2.png) [@Yevhen\_Lopukhin](https://community.glideapps.com/u/Yevhen_Lopukhin)\ **Post date:** [May 14, 2021, 7:14am UTC](https://community.glideapps.com/t/get-data-from-emails-to-spreadsheet-simple-paypal-payment-confirmation-solution/26784/1 "2021-05-14T07:14:48Z")
[https://www.youtube.com/watch?v=nI1OH3pAz6s](https://www.youtube.com/watch?v=nI1OH3pAz6s) Simple PayPal payment confirmation solution or any other payment system using confirmation of payment by email. I think this channel has earned a lot of likes. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 14, 2021, 1:05pm UTC](https://community.glideapps.com/t/get-data-from-emails-to-spreadsheet-simple-paypal-payment-confirmation-solution/26784/2 "2021-05-14T13:05:14Z")
Interesting ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 14, 2021, 1:37pm UTC](https://community.glideapps.com/t/get-data-from-emails-to-spreadsheet-simple-paypal-payment-confirmation-solution/26784/3 "2021-05-14T13:37:16Z")
I managed to do a test and it worked, but I don’t know how to make it “automatic”, whenever it updates in the input box, it updates in the script … because the trigger that he uses is manual Some of our wizards have any idea? @Darren_Murphy @ThinhDinh @Wiz.Wazeer ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 1:42pm UTC](https://community.glideapps.com/t/get-data-from-emails-to-spreadsheet-simple-paypal-payment-confirmation-solution/26784/4 "2021-05-14T13:42:05Z")
If you just need to create a trigger, I covered this in my JSON API tutorial. > [@Using App Script with a JSON API](https://community.glideapps.com/t/using-app-script-with-a-json-api/20051): > > Somebody who shall remain nameless (@SantiagoPerez - oops) asked me if I could put together a tutorial on working with API’s, so here it is. It’s my first tutorial, so please be gentle pray Whilst there is an app at the end of this, the app is not the main focus of the tutorial, so don’t expect to be impressed by that. The main focus is to give a gentle (?) introduction to Apps Script, and demonstrate how it can be used to interface with an API endpoint. I’ve tried to break down and explain t… ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 14, 2021, 1:51pm UTC](https://community.glideapps.com/t/get-data-from-emails-to-spreadsheet-simple-paypal-payment-confirmation-solution/26784/5 "2021-05-14T13:51:25Z")
I’m not used to this type of wizardry, I’m gonna have to take some time for this 😄 ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 14, 2021, 1:53pm UTC](https://community.glideapps.com/t/get-data-from-emails-to-spreadsheet-simple-paypal-payment-confirmation-solution/26784/6 "2021-05-14T13:53:08Z")
Creating triggers is easy, but just shout if you need any help