Add and update rows with values or formulas to the worksheet. Nice and easy, little code required.
Where do I find Spreadsheet ID
docs.google.com/spreadsheets/d/[Spreadsheet_ID]/edit
$.'Search results'.values.[0]
(for the first search result), $.'Search results'.values.[1]
(for the second), and so on.null
for this column in the output Search results.=SUM(A1:A3)
.Comment
value will not be added to the sheet.