title: Automate Google Spreadsheet data load from external database
body: <p>I have a shared Google spreadsheet. Some columns of a worksheet must be filled with data (SQL query) that exist in a DB server (PostgreSQL).</p>
  
  <p>Also the data load must be scheduled to be done automatically (e.g. at 1.00 o'clock every day) .</p>
  
  <p>Finally I need some tweaks in the spreadsheet (e.g after the load to put the datetime in the name of the worksheet or send a confirmation email etc)</p>
  
  <p>What is the best and easiest approach to achieve this? (I start looking Google app scripts and Google Sheets API but not sure what is more appropriate)</p>
  
  <p>Thanks</p>