Q:

How do I write the result of a Google Apps Script to a spreadsheet instead of log?

I have a script that I am running that writes a Google Drive file inventory to a log using the Logger.log() method.
How would I modify this to write the result to a spreadsheet instead?

A:

Are you wanting to just set rows in a column to be file names? 
If you want each list to be a new sheet try
var ssNew = SpreadsheetApp.create("File List");

I assume here you're iterating through the file list capturing one file name at a time. If you keep track of the last row you wrote to and increment that each time you should be able to call get range and get cell then set value something like this.
var currentRow = 0;
var range = ssNew.getRange(1, currentRow);
range.getCell(currentRow, 1).setValue(<file name>);
currentRow++;

With apps script sheets you're always getting a 'range' and never a cell in quite the way I think of it. Hope that helps

