title: How can I connect to Heroku Postgres from a Google Spreadsheet
body: <p><strong>I'd like to use a Google spreadsheet to display my database analytics</strong></p>
  
  <p>I'd like to be able to do summary queries on my Heroku Postgres database using Google Apps Script and then display and chart them in a Google spreadsheet. </p>
  
  <p>Heroku offers a number of ways to connect to Heroku Postgres:
  <a href="https://devcenter.heroku.com/articles/heroku-postgresql" rel="noreferrer">https://devcenter.heroku.com/articles/heroku-postgresql</a></p>
  
  <p>Likewise Google Apps script offers access to a number of different external services
  <a href="https://developers.google.com/apps-script/defaultservices" rel="noreferrer">https://developers.google.com/apps-script/defaultservices</a></p>
  
  <p>I've never attempted this before and so am interested in what is simplest. </p>
  
  <p><strong>JDBC seems possible but are there any other options?</strong></p>
  
  <p>As far as I can see, the only overlap between the two is JDBC which I have no experience with but feels like a bit of a heavyweight third protocol to use to get between the systems. </p>
  
  <p>IS JDBC the best way to get the data across or is there something simpler I'm missing?</p>