submit data from one workbook to another workbook

Question

I need to post/submit data from the source workbook to the destination workbook(id) > worksheet

I have achieved this task by using the below code, but I need help posting to a different workbook > worksheet

score 0 · Accepted Answer · answered Feb 19 '22 at 07:50

0

Try

var datasheet = SpreadsheetApp.openById('id of the target spreadsheet').getSheetByName("DataSheet")

answered Feb 19 '22 at 07:50

Mike Steelson

1 Answers1