Joel Warren
asked on
Instant Conversion of CSV Attachment from Gmail into row of Google Sheets
We are a private lender for borrowers of single-family residential investment properties. Our company uses G-Suites, Drive and Google Apps for Business. We purchase leads from a third-party platform. I am trying to automate the delivery of lead data we receive from them via Gmail, into Google Sheets in Drive so that we have a Lead Database. The leads come in one at a time in HTML and CSV (attachment). We have used email parser workaround, but do not like relying on this solution.
Is there a way to automatically convert the CSV attachment from Gmail, in real-time, to populate a new row of lead data in a Google Sheet for our Leads? The goal is to get the lead data into Drive and Google Sheets.
Is there a way to automatically convert the CSV attachment from Gmail, in real-time, to populate a new row of lead data in a Google Sheet for our Leads? The goal is to get the lead data into Drive and Google Sheets.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
If you need a non automated way to do that. Google sheets offer import feature. Goto: File > Import > then choose the CSV file from Drive or upload it from your PC. A dialog similar to the attached picture will appear for you, select the appropriate options and click "Import data".
Import-data-Gsheets.PNG