Here's an example - I'm taking all carrier codes and airline names from a Google Fusion Table. Below is a small clip from the result.
"Fusion" is the name of the sheet to write the result to, the second argument is a string with your fusion developer key ( I use a function to retrieve mine from a scriptdb lockbox) - you really need to get your own, and the 3rd argument is the ID for the fusion table I want to retrieve all the data for. There is a 4th optional argument, where you can specify specific Sql if you want to play around with the data before retrieving it.
This mainly uses the Rest to Excel library, and here is the library entry
The data that is returned from Fusion includes a description of the columns, so we can use that to write the new Excel table. Here's a snippet of the beginning of the JSON response.
That's pretty straightforward to unravel as follows.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > excel to json and back > Rest to Excel library >