title: get gmail email contents and transfer to google spreadsheet and arrange accordingly
body: <p>Hi I'm just wondering if i could extract all email contents of a certain emails on a label and put them into a google spreadsheet.Its very tiring to open every email and copy and paste every data to a spreadsheet to arrange accordingly. ive tried to create a macro in vb to arrange the emails but still i would need to open each email just to get the data and put them on my excel file. </p>
  
  <p>here is the sample email content i want to arrange based on their labels and each email will be displayed per row and column:</p>
  
  <p>CO type:IV ONLY</p>
  
  <p>TYPE AUTO:Manual
  DATE:11/21/2016 1:49:11 PM 
  CAR Type: MITSUBISHI<br>
  Company address: PEAK 
  Price: 8,000.00  </p>
  
  <p>CA: Michael,John
  SPO: SINGLE
  ADD: UNIT 3 San Franciscvo, Canada
  LM : Oyster<br>
  SOI: Factory Worker
  POS: 1st mate
  ADD: UNIT 3 San Diego, California</p>
  
  <p>And what i want is to arrange them based on the headers ive created:which is before beggining of every mail until the colon(:) mark. I've already done it by searching the begining of word until the colon and by using cut and paste on excel but still takes alot of time due to manual opening and pasting of emails on my file. is there any work around for this? </p>