spreadsheetId: 'xxxx',
resource: {
requests: [
{
copyPaste: {
source: {
sheetId: xxxx,
startRowIndex: 0,
endRowIndex: 1,
startColumnIndex: 0,
endColumnIndex: 1,
},
destination: {
sheetId: xxxx,
startRowIndex: 0,
endRowIndex: 1,
startColumnIndex: 1,
endColumnIndex: 2,
},
pasteType: 'PASTE_VALUES',
pasteOrientation: "NORMAL",
}
}
]
}
}
}