MULTI-APP TOOLKIT
Build with Gong + Google Sheets
- Multi-app
- One MCP session
- 52 actions
- 9 triggers
- Managed auth
MCP
One MCP session, both toolsets
One session gives your product or agent every Gong 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": "gong,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: Gong and Google Sheets tools arrive
// together, each keyed by its own app's slug.
// e.g. run Add New Call:
const result = await mcp.callTool({
name: "gong-add-new-call",
arguments: {
clientUniqueId: "Client Unique ID",
actualStart: "Actual Start",
},
})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 [gongTools, googleSheetsTools] =
await Promise.all([
pd.components.list({ app: "gong" }),
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=gong" \
-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
Gong
Connected account
Google Sheets
Connected account
TOOLS
Gong tools
The Gong tools this pairing puts in reach, each one running on your user's own connected account.
Actions top 8 of 9
-
Add New Call
actionCreate a call record in Gong and return its ID. Set Download Media URL so Gong can fetch and process the recording; without it the call stays pending and other Gong actions cannot return it. See the documentationWritev0.0.7 -
Get Call Transcripts
actionRetrieve the full spoken transcript of one or more calls. Returns an array of
{ callId, speakers, transcript }objects, where each transcript entry carries the speaker, the topic Gong assigned to that stretch of the call, and the sentences with theirhh:mm:ssoffset from the start of the call.Pass Call IDs to transcribe specific calls (use List Calls or Search Calls to find them), or a date range to transcribe everything recorded in that window. Speaker IDs are resolved to participant names automatically, so you can tell the rep and the customer apart.
To find where a word or phrase was said without pulling whole transcripts back, use Search Call Transcripts instead. For summaries, topics, and next steps, use Search Calls.
Transcripts exist only for calls Gong has processed; a recently uploaded call may return nothing. Results are paginated internally, so one run returns up to Limit transcripts. See the documentation
Read-onlyv1.0.0 -
List Calls
actionList recorded calls in a date range and return an array of call metadata objects. This is the cheap way to discover call IDs before acting on them. It does NOT return summaries, topics, trackers, participants, or CRM data - use Search Calls for those, and Get Call Transcripts for the spoken content. See the documentationRead-onlyv1.0.0 -
List Calls In Library Folder
actionList the calls curated into a Gong library folder and return an array. Thenoteis the comment whoever filed the call left on it, andsnippetmarks the highlighted stretch of the call when one was saved. An empty folder returns an empty array. See the documentationRead-onlyv0.0.1 -
List Library Folders
actionList the public folders in the Gong call library and return an array. The library is where teams curate calls into collections such as "Win/Loss" or "Onboarding", so this is the way to find calls a human has already picked out rather than searching the whole call history. Folders nest: a folder with aparentFolderIdofnullis a root folder. Pass a folder'sidto List Calls In Library Folder to get its calls. Private and archived folders are never returned. See the documentationRead-onlyv0.0.1 -
List Users
actionList the Gong users in your company and return an array of user objects. Gong cannot search users by name or email, so to resolve a rep to their user ID, list users and match the returnedfirstName/lastName/emailAddressfields yourself; that ID is what Search Calls needs for Primary User IDs. Pass a single value in User IDs to fetch one known user. Gong has no teams endpoint: set Manager ID to list that manager's direct reports, filtered here rather than by the API. Returns at most Limit users. See the documentationRead-onlyv0.0.1 -
List Workspace ID Options
actionList the company's Gong workspaces as{ label, value }pairs, wherevalueis the workspace ID. Most Gong accounts have a single workspace, so you usually only need this when an action's Workspace ID filter matters. Call it first to resolve a workspace name to the ID that List Calls, Search Calls, Get Call Transcripts, and List Library Folders accept. See the documentationRead-onlyv0.0.3 -
Search Call Transcripts
actionFind where a word or phrase was said across call transcripts. Returns one entry per matching sentence with the call's ID, title and URL, the speaker's name and affiliation, thehh:mm:ssoffset into the call, and the sentence itself, so you can quote what was said and link straight to that moment. Use this to answer questions like "which calls mentioned pricing" or "did anyone bring up the competitor". Narrow the search with a date range, a workspace, or specific Call IDs; the search itself runs over the transcript text. Prefer this over Get Call Transcripts whenever you are looking for a keyword rather than reading a call end to end - it scans the same transcripts but returns only the matching lines. Note that it fetches transcripts for every call in the window in order to search them, so a narrow date range is much cheaper than a wide one. See the documentationRead-onlyv0.0.1
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 43
-
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.2 -
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.2 -
Get Values in Range
actionGet all values or values from a range of cells using A1 notation. See the documentationRead-onlyv0.1.21 -
Add Conditional Format Rule
actionCreate conditional formatting with color scales or custom formulas. See the documentationWritev0.0.5 -
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.2 -
Add Protected Range
actionAdd edit protection to cell range with permissions. See the documentationWritev0.0.5 -
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.5 -
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.5
Triggers top 4 of 8
-
New Comment
triggerEmit new event each time a comment is added to a spreadsheet.v0.0.6 -
New Comment (Instant)
triggerEmit new event each time a comment is added to a spreadsheet.v0.1.8 -
New Row Added
triggerEmit new event each time a row or rows are added to the bottom of a spreadsheet.v0.1.8 -
New Row Added (Instant)
triggerEmit new event each time a row or rows are added to the bottom of a spreadsheet.v0.2.8
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
- gong,google_sheets
- Primary app
- Gong (gong)
- Second app
- Google Sheets (google_sheets)
- Authentication
- OAuth + OAuth
- Available actions
- 52
- Available triggers
- 9