title: How to integrate Google Docs/Excel with Jenkins to automatically populate Pass/Fail field
body: <p>Im relatively new to this industry, and Ive just received my first assignment. Im not looking to take up too much of anyone's time, Im just looking for a little guidance.</p>
  
  <p>I need to create a spreadsheet with "Ticket ID", "Test Case ID", "Pass/Fail" and "Comments" columns.</p>
  
  <p>We have builds running on/managed by Jenkins, and we have failed builds more often than not. </p>
  
  <p>Id like to link/integrate this spreadsheet with Jenkins, so that way the document is automatically populated with data.</p>
  
  <p>(Please see attached image for a better visual of what Im trying to realize)</p>
  
  <p>If a build passes, populate "Pass/Fail" column in spreadsheet with "Pass" and "Comments" column with "Build passed"</p>
  
  <p>If a build fails, say "Failed" and import the "Comments" from Jenkins why the build the failed</p>
  
  <p>Any advice would be much appreciated, thank you. Also, if you have a suggestion of a better way to do this, please let me know.</p>
  
  <p><a href="https://i.stack.imgur.com/Ka033.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Ka033.png" alt="Spreadsheet"></a></p>