CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
user6076
user6076

Reputation: 15

How can I update the next row - Google Sheets

I’m new using Google sheets, and I have the following situation:

I have an external application and once a day it generates a report. I’m getting the report data(via JSON), and importing it in the Google sheets. I want to update the data from the next day in a new row. Right now, I implemented the script to import a Json but, the data are always updating the same row. How can I update the next row, after import the new data?

Upvotes: 0

Views: 188

Answers (1)

Michelle
Michelle

Reputation: 46

Put the JSON data into a variant, and then use .appendRow() method on the Sheet object.

 var ss = SpreadsheetApp.getActiveSpreadsheet();
 var ws = ss.getActiveSheet();
 var appd = wscl.appendRow([var, var, var]);

Upvotes: 2

Related Questions