MULTI-APP TOOLKIT
Build with Box + Google Sheets
Connect a user's Box and Google Sheets accounts and expose tools for both apps directly in your product or your agent.
- Multi-app
- One MCP session
- 61 actions
- 11 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every Box and Google Sheets tool at once — connect once, list tools, and call them like any single-app session.
// accessToken: mint a short-lived token with the Connect SDK — see the MCP guide
const transport = new StreamableHTTPClientTransport(
new URL("https://remote.mcp.pipedream.net/v3"),
{
requestInit: {
headers: {
Authorization: `Bearer ${accessToken}`,
"x-pd-project-id": "{project_id}",
"x-pd-environment": "production",
"x-pd-external-user-id": "{external_user_id}", // any stable ID for this user in your system
"x-pd-app-slug": "box,google_sheets",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// One list, both toolsets: Box and Google Sheets tools arrive
// together, each keyed by its own app's slug.
// e.g. run Add Comment:
const result = await mcp.callTool({
name: "box-add-comment",
arguments: {
folderId: "Parent Folder",
fileId: "File",
},
})import { PipedreamClient } from "@pipedream/sdk"
const pd = new PipedreamClient({
projectId: process.env.PIPEDREAM_PROJECT_ID!,
clientId: process.env.PIPEDREAM_CLIENT_ID!,
clientSecret: process.env.PIPEDREAM_CLIENT_SECRET!,
projectEnvironment: "production",
})
const externalUserId = "{external_user_id}" // any stable ID for this user in your system
const [boxTools, googleSheetsTools] =
await Promise.all([
pd.components.list({ app: "box" }),
pd.components.list({ app: "google_sheets" }),
])
// One external user owns both connected accounts, so either app's tools
// run on their behalf with the same externalUserId.curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=box" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=google_sheets" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
# Connect both accounts to the same external_user_id, then
# configure and invoke either app's tools on that user's behalf.ARCHITECTURE
One user, two connected accounts
Your user connects each account once, under whatever ID they already have in your product. The two stay independent — either can be revoked on its own — and your code reaches both through that one user.
Your product
external_user_id
{external_user_id}Pipedream Connect
Managed identity
Auth · tools · routing
Box
Connected account
Google Sheets
Connected account
TOOLS
Box tools
The Box tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 19
-
Add Comment
actionAdds a comment to a Box file. To mention a user, include@[user_id:name]in the message and Box will notify them by email. Use Get Comments to read existing comments on a file. See the documentation.Writev0.0.2 -
Create Box Sign Request
actionCreates a Box Sign signature request and sends it to the listed signers. Requires at least one signer, plus the document(s) to sign passed viaAdditional Options— eithersource_files(e.g.[{"id": "123456789", "type": "file"}]) or atemplate_id; Box rejects requests with no document source. The signed document and signing log are saved to theParent Folder. See the documentation.Writev0.0.9 -
Create Collaboration
actionAdds a collaboration for a user or group on a file or folder, granting them access with a role (editor, viewer, previewer, uploader, previewer uploader, viewer uploader, or co-owner). Item Type must befileorfolder. Invite users by email or user ID; groups must be invited by group ID only. Can View Path applies only to folder collaborations. Use Delete Collaboration to revoke access. See the documentation.Writev0.0.2 -
Create Folder
actionCreates a new empty folder within the specified parent folder. Parent folder ID0is the root (All Files). Folder names must be 1-255 characters, use only Unicode Basic Multilingual Plane (BMP) characters, and cannot contain non-printable characters,/or\, leading or trailing spaces, or be.or... Names must be unique within the parent (case-insensitive). Use List Folder Items to inspect contents, or Move Folder / Delete Folder to reorganize afterward. See folder name restrictions. See the documentation.Writev0.0.2 -
Create Shared Link
actionCreates or updates a shared link for a file or folder. Access levels:open,company, orcollaborators. A password can only be set when access isopen; download permission applies only when access isopenorcompany. A resource can have only one shared link at a time. See the documentation.Writev0.0.2 -
Delete Collaboration
actionRemoves a collaboration, revoking a user's or group's access to a file or folder. Use Create Collaboration to grant access first and obtain a collaboration ID from its response. See the documentation.Writev0.0.2 -
Delete Folder
actionDeletes a folder by moving it to trash (or permanently when enterprise settings require). Set Recursive totrueto delete non-empty folders and all contents; without it, deleting a non-empty folder fails. Deleting a large folder can take longer than Box's request timeout — Box then returns HTTP 503 while the deletion continues in the background, which this action reports as accepted (accepted: true). This cannot be undone from this action — use List Folder Items to verify contents first. See the documentation.Writev0.0.2 -
Download File
actionDownloads a file from Box to your workflow's/tmpdirectory and returns the saved file path. Use Get File Metadata to check the file's name and size first, or Get File Text to extract text content without downloading. See the documentationWritev0.0.12
Triggers
-
New Event
triggerEmit new event when any of the selected event types occurs on the target file or folder, via a Box webhook. See the documentationInstantv0.0.10 -
New File Event
triggerEmit new event when a file is uploaded to, or moved into, the target folder (FILE.UPLOADED), via a Box webhook. Box fires this trigger for both cases, so moving an existing file into the folder also emits an event. See the documentationInstantv0.1.5 -
New Folder Event
triggerEmit new event when a folder is created within the target folder (FOLDER.CREATED), via a Box webhook. See the documentationInstantv0.0.10
TOOLS
Google Sheets tools
The Google Sheets tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 42
-
Add Single Row
actionAdd a single row to a Google Sheet. By default the row is appended to the end. To INSERT the row at a specific position instead — pushing the rows at and below that position DOWN without overwriting them — set Row Index (e.g. Row Index 2 inserts directly below a header row). Use this tool (not Update Row or Update Multiple Rows) whenever the goal is to insert a row between existing rows or add a row while keeping every current row: the Update tools overwrite cells in place and do NOT shift rows down. See the documentationWritev3.0.1 -
Add Multiple Rows
actionAppend multiple rows to a Google Sheet in one call. Providerowsas a JSON array of arrays — each inner array is one row, with cell values in column order (e.g.[["Alice","alice@ingen.test","Engineering"],["Bob","bob@ingen.test","Paleontology"]]). Use Get Spreadsheet Info first to see the column order. Rows are appended after the last row with data. To add a single row, or to insert at a specific position, use Add Single Row instead. See the documentationWritev0.3.1 -
Get Values in Range
actionGet all values or values from a range of cells using A1 notation. See the documentationRead-onlyv0.1.20 -
Add Conditional Format Rule
actionCreate conditional formatting with color scales or custom formulas. See the documentationWritev0.0.4 -
Add Conditional Formatting
actionAdd a conditional formatting rule to a range in Google Sheets, so cells style themselves based on their contents — highlight values over a threshold, flag blanks, color-code by text, or apply a red-to-green color scale. Use this when the user wants formatting driven by the data ('highlight anything over 100', 'make overdue rows red', 'heat-map the revenue column'). For formatting that applies to cells regardless of their value, use Format Cells instead. Use Get Spreadsheet Info to discover worksheet names and Read Rows to see the values you're writing a rule against.rangeis A1 notation WITHOUT the worksheet name (B2:B100,C:C).valuessupplies the numbers/text the condition compares against: one value for most conditions, two forNUMBER_BETWEEN, none forIS_BLANK/IS_NOT_BLANK/COLOR_SCALE, and a formula starting with=forCUSTOM_FORMULA. Example: to highlight revenue cells above 10000 with a light green fill, call with sheetName="Financials", range="B2:B100", condition="NUMBER_GREATER", values="10000", backgroundColor="light green" → returns the rule that was created and its index on the sheet. See the documentationWritev0.0.1 -
Add Protected Range
actionAdd edit protection to cell range with permissions. See the documentationWritev0.0.4 -
Add Rows
actionAppend one or more rows to a Google Sheets worksheet. Pass rows as a JSON array. Preferred format: array of objects with column header keys (e.g.,[{"Name": "Alice", "Email": "alice@example.com"}]). Use Get Spreadsheet Info first to discover the exact column header names — keys must match headers exactly (case-sensitive). Alternatively, pass rows as arrays of positional values matching column order. New rows are appended after the last row with data.Writev0.0.4 -
Add Worksheet
actionAdd a new worksheet (tab) to an existing spreadsheet. Optionally set column headers. Use Get Spreadsheet Info to see existing worksheets before creating.Writev0.0.4
Triggers top 4 of 8
-
New Comment
triggerEmit new event each time a comment is added to a spreadsheet.v0.0.5 -
New Comment (Instant)
triggerEmit new event each time a comment is added to a spreadsheet.v0.1.7 -
New Row Added
triggerEmit new event each time a row or rows are added to the bottom of a spreadsheet.v0.1.7 -
New Row Added (Instant)
triggerEmit new event each time a row or rows are added to the bottom of a spreadsheet.v0.2.7
MULTI-APP
Works with more apps
The combinations customers connect alongside these two — nothing here is limited to a pair.
REFERENCE
Toolkit details
- x-pd-app-slug
- box,google_sheets
- Primary app
- Box (box)
- Second app
- Google Sheets (google_sheets)
- Authentication
- OAuth + OAuth
- Available actions
- 61
- Available triggers
- 11