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", version: "0.1.1", 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), }), ], description: "The spreadsheet containing the worksheet to copy", }, worksheetId: { propDefinition: [ googleSheets, "worksheetIDs", (c) => ({ sheetId: c.sheetId, }), ], type: "string", label: "Worksheet", description: "The worksheet to copy", }, destinationSheetId: { propDefinition: [ googleSheets, "sheetID", (c) => ({ driveId: googleSheets.methods.getDriveId(c.drive), }), ], description: "The spreadsheet to copy the worksheetsheet 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	`sheetId`	`string`	Select a value from the drop down menu.
Worksheet	`worksheetId`	`string`	Select a value from the drop down menu.
Spreadsheet	`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.

Spreadsheet

sheetId

string

Select a value from the drop down menu.

Worksheet

worksheetId

string

Select a value from the drop down menu.

Spreadsheet

destinationSheetId

string

Select a value from the drop down menu.

More Ways to Use Google Sheets#

Triggers#

New Row Added (Instant) from the Google Sheets API

Emit new events each time a row or rows are added to the bottom of a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Row Added (Shared Drive, Instant) source instead.

Try it

New Row Added (Shared Drive, Instant) from the Google Sheets API

Emit new events each time a row or rows are added to the bottom of a spreadsheet in a shared drive

Try it

New Updates (Instant) from the Google Sheets API

Emit new event each time a row or cell is updated in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Updates (Shared Drive, Instant) source instead.

Try it

New Updates (Shared Drive, Instant) from the Google Sheets API

Emit new event each time a row or cell is updated in a spreadsheet in a shared drive

Try it

New Worksheet (Instant) from the Google Sheets API

Emit new event each time a new worksheet is created in a spreadsheet. To use this source with a spreadsheet in a Shared Drive, use the New Worksheet (Shared Drive, Instant) source instead.

Try it