MULTI-APP TOOLKIT
Build with Google Sheets + monday
Connect a user's Google Sheets and monday accounts and expose tools for both apps directly in your product or your agent.
- Multi-app
- One MCP session
- 60 actions
- 18 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every Google Sheets and monday 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": "google_sheets,monday",
},
},
},
)
const mcp = new Client({ name: "my-agent", version: "1.0.0" })
await mcp.connect(transport)
const { tools } = await mcp.listTools()
// One list, both toolsets: Google Sheets and monday tools arrive
// together, each keyed by its own app's slug.
// e.g. run Add Single Row:
const result = await mcp.callTool({
name: "google_sheets-add-single-row",
arguments: {
drive: "Drive",
sheetId: "Spreadsheet ID",
},
})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 [googleSheetsTools, mondayTools] =
await Promise.all([
pd.components.list({ app: "google_sheets" }),
pd.components.list({ app: "monday" }),
])
// 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=google_sheets" \
-H "X-PD-Environment: production" \
-H "Authorization: Bearer {access_token}"
curl "https://api.pipedream.com/v1/connect/{project_id}/components?app=monday" \
-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
Google Sheets
Connected account
monday
Connected account
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
TOOLS
monday tools
The monday tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 18
-
Create an Update
actionPost an update (a comment) on an item, or reply to an existing update. Use to add a note to an item's activity feed; this changes no column value — use Update Column Values for that. SetBoard ID,Item IDandUpdate Body, and setParent Update IDonly when replying to an existing update rather than starting a new thread. Example: Update BodyDesign approved, moving to build. Returns the new update's ID as a string. Use Get Board Items Page to find anItem ID. See the documentationWritev0.0.19 -
Create Board
actionCreate a new board in a workspace. Use when you need a new board before adding groups, columns or items to it. SetBoard NameandBoard Kind(public,privateorshare); if you omitWorkspace IDthe board is created in the Main Workspace. Example: Board NameQ3 Campaigns, Board Kindpublic. Returns the new board's ID as a string (e.g.2419687965), not the full board object — call List Boards if you need its details. Use List Workspace ID Options to find a validWorkspace ID. See the documentationWritev0.0.16 -
Create Column
actionAdd a column to an existing board. Use when a board is missing a field you need before setting values with Create Item or Update Column Values. SetBoard ID,TitleandColumn Type(e.g.status,text,date,numbers).Custom Labels (Defaults)is accepted only whenColumn Typeisstatusordropdownand is rejected for any other type. Example: TitlePriority, Column Typestatus, Custom Labels{ "1": "High", "2": "Low" }. Returns the new column's ID as a string (e.g.status_1). Call List Columns afterwards to confirm the ID and the labels it accepts. See the documentationWritev0.1.8 -
Create Group
actionCreate a group (a titled section of rows) on a board. Use when you need somewhere to put new rows before calling Create Item, which takes an optionalGroup ID. SetBoard IDandGroup Name. Example: Board ID2419687965, Group NameIn Progress. Returns the new group's ID as a string (e.g.new_group12345) — pass that value asGroup IDto Create Item. Use List Board ID Options to find a validBoard ID. See the documentationWritev0.0.17 -
Create Item
actionCreate an item (a row) on a board. Use for a top-level row; use Create Subitem for a row nested under an existing item. SetBoard IDandItem Name, and optionallyGroup IDandColumn Values. Call List Columns first to get the column IDs and the labels astatusordropdowncolumn accepts. Example: Item NameWebsite redesign, Column Values{ "status": "Working on it", "date4": "2026-09-02", "numbers": 42 }. SetItem Create Labelstotrueto allow missingstatus/dropdownlabels to be created, which requires permission to change the board structure. Returns the new item's ID as a string (e.g.9876543210). See the documentationWritev0.1.9 -
Create Subitem
actionCreate a subitem nested under an existing item. Use when the row belongs to a parent item; use Create Item for a top-level row. SetBoard ID(the parent item's board),Parent Item IDandItem Name. Gotcha: subitems live on a separate subitems board, soColumn Valuesmust use that board's column IDs — run List Columns against the subitems board, not the board selected here. Example: Item NameDraft copy, Column Values{ "status": "Done" }. Returns the new subitem's ID as a string. See the documentationWritev0.1.9 -
Get Board Items Page
actionList every item (row) on a board, following the API's cursor automatically so all pages are returned in a single call — you do not need to paginate. Use when you want the whole board; use Get Items By Column Value to filter server-side by one column, which is far cheaper on a large board. SetBoard ID, and optionallyQuery Paramsto filter or sort. Example: Query Params{ "rules": [{ "column_id": "status", "compare_value": ["Done"], "operator": "any_of" }] }. Returns an array of items withid,name,state, timestamps and column values. Gotcha: a large board returns every row in one response, so expect a slow call and a large payload. See the documentationRead-onlyv0.0.7 -
Get Column Values
actionRead the column values of one item. Use when you already have anItem IDand want its field values; use Get Items By Column Value to search for items by a value instead. SetBoard IDandItem ID; leaveColumn IDsempty to return every column, or pass specific column IDs from List Columns. Example: Item ID9876543210, Column IDs["status", "date4"]. Returns an array holding the item and acolumn_valuesarray of{ id, value }pairs, wherevalueis the column's display text when one exists and the raw JSON value otherwise. See the documentationRead-onlyv0.0.14
Triggers top 4 of 10
-
Column Value Updated (Instant)
triggerEmit new event when a column value is updated on a board. See the documentationInstantv0.0.15 -
Name Updated (Instant)
triggerEmit new event when an item's name is updated. See the documentationInstantv0.0.15 -
New Board Created
triggerEmit new event when a board is created in Monday. See the documentationv0.0.16 -
New Item Created (Instant)
triggerEmit new event when a new item is added to a board. See the documentationInstantv0.0.15
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
- google_sheets,monday
- Primary app
- Google Sheets (google_sheets)
- Second app
- monday (monday)
- Authentication
- OAuth + API key
- Available actions
- 60
- Available triggers
- 18