Copy a single sheet/tab from one Google Spreadsheet into another spreadsheet, then rename the resulting sheet.

Documented steps

1. POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo with OAuth scope https://www.googleapis.com/auth/spreadsheets (or drive/drive.file). spreadsheetId and sheetId in the path identify the source spreadsheet and the source sheet's numeric sheetId.
2. Request body: {"destinationSpreadsheetId": "TARGET_SPREADSHEET_ID"} — this is the only field the request body needs.
3. The credentials used need read access to the source spreadsheet and write access to the destination spreadsheet, since copyTo is a single call made against the source spreadsheetId that writes into another file.
4. The response returns a SheetProperties object for the new sheet in the destination spreadsheet, including its own new auto-generated sheetId and a title automatically set to "Copy of <original sheet title>".
5. Rename it with a follow-up POST https://sheets.googleapis.com/v4/spreadsheets/{destinationSpreadsheetId}:batchUpdate containing an UpdateSheetPropertiesRequest: {"updateSheetProperties": {"properties": {"sheetId": <new sheetId from the copyTo response>, "title": "Desired Title"}, "fields": "title"}}.
6. Docs: https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo | https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets/batchUpdate | https://developers.google.com/workspace/sheets/api/limits