Copy Worksheet - Pipedream

import googleSheets from "../../google_sheets.app.mjs"; export default { key: "google_sheets-copy-worksheet", name: "Copy Worksheet", description: "Copy an existing worksheet to another Google Sheets file. [See the documentation](https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.sheets/copyTo)", version: "0.1.8", type: "action", props: { googleSheets, drive: { propDefinition: [ googleSheets, "watchedDrive", ], description: "The drive containing the worksheet to copy. If you are connected with any [Google Shared Drives](https://support.google.com/a/users/answer/9310351), you can select it here.", }, sheetId: { propDefinition: [ googleSheets, "sheetID", (c) => ({ driveId: googleSheets.methods.getDriveId(c.drive), }), ], }, worksheetId: { propDefinition: [ googleSheets, "worksheetIDs", (c) => ({ sheetId: c.sheetId, }), ], }, destinationSheetId: { propDefinition: [ googleSheets, "sheetID", (c) => ({ driveId: googleSheets.methods.getDriveId(c.drive), }), ], description: "The spreadsheet to copy the worksheet to", }, }, async run() { const request = { spreadsheetId: this.sheetId, sheetId: this.worksheetId, resource: { destinationSpreadsheetId: this.destinationSheetId, }, }; return await this.googleSheets.copyWorksheet(request); }, };

Label	Prop	Type	Description
Google Sheets	`googleSheets`	`app`	This component uses the Google Sheets app.
Drive	`drive`	`string`	Select a value from the drop down menu.
Spreadsheet ID	`sheetId`	`string`	Select a value from the drop down menu.
Worksheet ID	`worksheetId`	`string`	Select a value from the drop down menu.
Spreadsheet ID	`destinationSheetId`	`string`	Select a value from the drop down menu.

Label

Prop

Type

Description

Google Sheets

googleSheets

app

This component uses the Google Sheets app.

Drive

drive

string

Select a value from the drop down menu.