Append New Data into to new rows

[Edwin_Wong]

Hi @MutedJam

I found this. It seems like last time can be works.

Fill a specific cell of a Google Sheet

Alright, here we go: In the example, I am using this method from the Google Sheets API to update the value of a cell. Things you would need to adjust on your end are: Replace 1hlRU37P03VoPkneyfhuPqaUPCB2fkbSzC_jDwUam0pg in the request URL with the ID of your Google Sheet. You can get this ID from the URL of your Google Sheet: [image] Adjust the Sheet1!B3 range accordingly if your spreadsheet has a different name or you want to write into a different cell. It has to …

By the way, based on the link at above. Is it possible to use app script to do this task?
And also, is it possible that I read the data from google sheet for specific range and then I retrieve this range to create a new spreadsheet?