title: Using Google Script to Input Google Drive Files' URLs into Google Sheets
body: <p>Sorry in advance, but I think I should start by saying I'm not a dev nor do I have any dev knowledge. And I'm really hoping you could help me with this.</p>
  
  <p>Scenario:</p>
  
  <ul>
  <li><p>I have a folder in My Drive with several PDFs</p></li>
  <li><p>I have a Google sheet with 2 columns, first column is "Name" and second column is "Document". The first column is filled with several names and the second column is entirely empty</p></li>
  </ul>
  
  <p>What i want to do:</p>
  
  <ul>
  <li>Import the URLs/links of the PDFs into the "Document" columns corresponding to the names. So John's PDF document should be in the same row with John's name</li>
  </ul>