title: Google Spreadsheet: Parsing .PDF from Google Drive
body: <p>I'm still getting into google spreadsheets, recently understood how to format a <code>.txt</code> to be able to use <code>=ImportData</code> properly thanks to Tanaike's assitance, now tackling a -slightly- more challenging task.</p>
  
  <p><strong>Goal:</strong></p>
  
  <p>Automatically extracting specific data from .pdf files hosted inside of a google drive folder and arranging the information into specific cells</p>
  
  <p><strong>Challenges:</strong></p>
  
  <ul>
  <li>Being able to decode the blobs of information, as <a href="https://i.stack.imgur.com/ww3kY.png" rel="nofollow noreferrer">just the raw data</a> obtained with <code>=ImportData</code> is useless</li>
  <li>Truly learning how to use <code>google-apps-script</code> for something useful (that's on my own)</li>
  <li>Instructing a single extraction of information rather than constant online status as with <code>=ImportData</code></li>
  <li>[Second Priority] Stop Depending on an add-on (<code>Drive Direct Links</code>) to get the URL of the files</li>
  </ul>
  
  <p>To my understanding, I'll need to do some parsing. I know <code>.pdf</code> is not always straight forward, all the files will come from the same place and have the exact same format, so understanding how to do it once should be enough.
  I already know how to get the real/permanent link to the files automatically and how to arrange information segregated into cells using <code>=Index</code>, <code>=Extract</code> and others.</p>
  
  <p>Hope I'm being clear enough. Thanks a lot in advance.</p>
  
  <p>Best regards,</p>
  
  <p>Lucas.-</p>