cant seem to get [spreadsheets.sheets.copyTo] to work..

[hirokun2016]

Hi,
I cant seem to get the spreadsheets.sheets.copyTo to work. I have followed everything in the documentation but it still wont work. I am able to successfully perform other commands such as batchUpdate or Create. Can anybody tell me what is wrong with my code or how to make this work? Here is a snippet of my code:

    function copySheet(auth) {
    var sheets = google.sheets('v4');
    var spreadsheetID_foo = 'some spreadSheet ID';
    var spreadsheetID_test = 'another spreadSheet ID';
    sheets.spreadsheets.sheets.copyTo({
        auth: auth,
        spreadsheetId: spreadsheetID_test,
        sheetId: 0,
        resource: {destinationSpreadsheetId: spreadsheetID_foo}
    }, function(err,response){
        if(err) {
            console.log(err);
        }
        console.log('Data :', response);
    });
}

[jmdobry]

Just to confirm, sheet 0 exists in 'another spreadSheet ID' and you're trying to copy it to 'some spreadSheet ID'?

Your code looks correct to me, what is the error you're getting?

[jmdobry]

Any updates on this?

[lukesneeringer]

Hi @hirokun2016,
We noticed this ticket has been around for awhile with no answer. I am going to go ahead and close it, but feel free to reopen with more information if you wish.