Copy a Sheet Between Spreadsheets
A 3-step recipe with Google Sheets. We can help you get access.
Recipe · 3 steps
Copy a Sheet Between Spreadsheets
with Google Sheets
Copy a single sheet from one spreadsheet into another and confirm it.
- Read the source spreadsheet to confirm it exists before copying from it.
- Copy the named sheet from the source spreadsheet into the destination spreadsheet and capture the new sheet's properties.
- Read the destination spreadsheet back to confirm the copied tab is present.
What you'll need to have ready
- accessToken: OAuth 2.0 bearer access token with the spreadsheets scope.
- sourceSpreadsheetId: The ID of the spreadsheet to copy a sheet from.
- sheetId: The numeric ID of the sheet within the source spreadsheet to copy.
- destinationSpreadsheetId: The ID of the spreadsheet to copy the sheet into.
For your developer
Arazzo workflow google-sheets:copy-sheet-between-spreadsheets, 3 operations: getSpreadsheet → copySheet → getSpreadsheet. Specs on APIs.io.