title: How to import multiple csv files (of identical format) and create charts automatically in a Google Spreadsheet?
body: <p>I have about 25 csv files, all of the same format (identical number of rows and columns).  I would like to import these into separate sheets (tabs) of a google docs spreadsheet, and create charts (about 10) in each of the sheets.  </p>
  
  <p>Is there a convenient script or some automatic way of populating the spreadsheet, given the format and chart templates for one sheet?  </p>
  
  <p>One solution is to (a) import one csv file into a sheet, (b) create all the charts in the sheet, (c) make several copies of the sheet, which also creates the charts in each copy, and (d) import the remaining csv files into the other copies.  Is there a less painful or more scalable solution?  Thanks!</p>