# Get financial data from receipts in each user’s gmail and import it into google sheet **URL:** \ **Category:** Ask for Help\ **Created:** [March 4, 2020, 10:57pm UTC](https://community.glideapps.com/t/get-financial-data-from-receipts-in-each-user-s-gmail-and-import-it-into-google-sheet/5169 "2020-03-04T22:57:30Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Chief\_John\_Vanderpuy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chief_john_vanderpuy/32/4080_2.png) [@Chief\_John\_Vanderpuy](https://community.glideapps.com/u/Chief_John_Vanderpuy)\ **Post date:** [March 4, 2020, 10:57pm UTC](https://community.glideapps.com/t/get-financial-data-from-receipts-in-each-user-s-gmail-and-import-it-into-google-sheet/5169/1 "2020-03-04T22:57:30Z")
Hi guys I am trying to create a public personal finance app that uses the emails sent by the user’s bank to populate transaction lists. Here are the basics steps I am trying to do 1. software parses through user’s email to get transactional data and populates google sheets 2 user sees transactions on personal finance/budget app and categorized them accordingly. 1. This should work for any user that signs up Can anyone give some input on how’s to implement this? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 5, 2020, 1:10am UTC](https://community.glideapps.com/t/get-financial-data-from-receipts-in-each-user-s-gmail-and-import-it-into-google-sheet/5169/2 "2020-03-05T01:10:57Z")
It would need some sort of Zapier action. Email with #receipt would feed Google sheet. Attachment in sheet becomes a linked image. Body of email contains transaction details. App filters users by email so users only see their own transactions. It’s doable! ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 5, 2020, 1:20am UTC](https://community.glideapps.com/t/get-financial-data-from-receipts-in-each-user-s-gmail-and-import-it-into-google-sheet/5169/3 "2020-03-05T01:20:17Z")
Each user would have to manually authorize something like Zapier (probably creating there own Zapier account and setting up a zao to push emails to your sheet, which you have mentioned granted access to each user to edit your sheet. I don’t think you’ll get a lot of users to give up their email privacy to push data to a sheet they don’t own. The alternative would be to have each user forward each email to your email account and you set up the zap. Feels like a security and privacy risk to me.