--- title: "Integration Recipes — Connect Demo Data to Your Stack" slug: "/help/api/integration-recipes" last_updated: "2026-03-10T11:56:19Z" zendesk_id: 49764189367187 zendesk_url: "https://help.walnut.io/hc/en-us/articles/49764189367187-Integration-Recipes-Connect-Demo-Data-to-Your-Stack" locale: "en-us" product: "api" displayed_sidebar: "apiSidebar" sidebar_position: 6 --- Ready-to-use recipes for connecting Walnut demo analytics to your CRM, BI tools, automation platform, or AI workflows. Each recipe includes the API call, what to do with the data, and practical tips. Pick the recipes that match your stack — you don't need all of them. --- # CRM Sync ## HubSpot — Daily Session Sync to Deals **Goal:** Every morning, pull yesterday's prospect sessions and log them as timeline events on the matching HubSpot deal. **Step 1 — Pull yesterday's external sessions:** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` **Step 2 — Match to HubSpot deals:** - Use `demo_owner_name` to find the deal owner in HubSpot - Use `demo_name` to identify which demo was sent for which deal - Use `origin_url` to trace back to the specific share link **Step 3 — Log as HubSpot timeline event or note:** - **Completed + high interaction** (`is_completed=true`, `interaction_count > 5`) → Log as "Demo: High Intent View" - **Bounced** (`is_completed=false`, `screen_views_count=1`) → Log as "Demo: Bounced" - Everything else → Log as "Demo: Viewed" 💡P**ro tip:** Create a HubSpot workflow that triggers a task for the deal owner when a "High Intent View" event is logged. Strike while the iron is hot. --- ## Salesforce — Weekly Demo Engagement Report **Goal:** Push a weekly summary of demo engagement per opportunity into Salesforce. **Step 1 — Pull last 7 days, grouped by demo:** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` **Step 2 — For your top demos, pull detail:** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` **Step 3 — Update Salesforce:** - Create a custom object "Demo Engagement" on the Opportunity - Fields: Demo Name, Sessions This Week, Completion Rate, Avg Interactions, Top Country - Or simpler: update a custom text field on the Opportunity with a weekly summary --- # BI Dashboards ## Looker / Tableau / Power BI — Trend Dashboard **Goal:** Build a demo performance dashboard with daily trends, top demos, and engagement metrics. **Data source 1 — Daily trend (for line charts):** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` This gives you `{"date": count}` pairs — perfect for a time-series chart. **Data source 2 — Summary snapshot (for KPI cards):** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` Use this for: - **KPI cards:** Total sessions, completion rate (`completed/sessions`), bounce rate (`bounced/sessions`) - **Pie charts:** `by_user_type`, `by_viewer_type`, `by_embed` - **Bar chart:** `top_demos` ranked by session count - **Map:** `top_countries` **Data source 3 — Embed vs. direct (for comparison):** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` The response uses `date|true` and `date|false` keys — split on the `|` to create two series for embedded vs. direct link trends. 💡**Refresh schedule:** Most BI tools can call REST APIs on a schedule. Set daily refresh at 6am — the data will be ready for morning standups. --- ## Google Sheets — Simple Reporting **Goal:** For teams that live in spreadsheets, pull demo data directly into Google Sheets. **Option A — Apps Script (automated):** Paste this into Extensions → Apps Script: ``` function pullDemoSummary() { var url = ""; var options = { "headers": { "x-api-key": "YOUR_API_KEY" } }; var response = UrlFetchApp.fetch(url, options); var data = JSON.parse(response.getContentText()); var sheet = SpreadsheetApp.getActiveSheet(); sheet.getRange("A1").setValue("Total Sessions"); sheet.getRange("B1").setValue(data.totals.sessions); sheet.getRange("A2").setValue("Completed"); sheet.getRange("B2").setValue(data.totals.completed); sheet.getRange("A3").setValue("Bounced"); sheet.getRange("B3").setValue(data.totals.bounced); sheet.getRange("A4").setValue("Avg Duration (sec)"); sheet.getRange("B4").setValue(data.averages.duration_seconds); sheet.getRange("A5").setValue("Avg Interactions"); sheet.getRange("B5").setValue(data.averages.interactions); } ``` Set a daily trigger (Edit → Triggers) to auto-refresh. **Option B — Manual paste:** Run the cURL from the Quick-Start Guide, paste the JSON into a sheet, and use Google Sheets' `SPLIT` and `REGEXEXTRACT` formulas to parse. --- # Automation Platforms ## Zapier / n8n — Hot Lead Alerts **Goal:** Get a Slack (or email) alert whenever a prospect completes a demo with high engagement. **Workflow:** 1. **Schedule trigger** — Run every 30 minutes 2. **HTTP Request** — Call the API: ```bash GET ``` Headers: `x-api-key: YOUR_API_KEY` 1. **Filter** — Keep only rows where: - `is_completed` = `true` - `interaction_count` > 5 2. **Deduplicate** — Check session `id` against previously seen IDs (store in a Google Sheet or Zapier Storage) 3. **Send alert** — Post to Slack: > _🔥 High-Intent Demo View_ > **Demo:** Product Overview Demo > **Owner:** Jane Smith > **Interactions:** 12 clicks, 8 screens viewed > **Location:** Dallas, United States > **Time:** 10:37 AM UTC 💡**Why 30 minutes?** Fast enough to alert sales while the prospect is still engaged. The API rate limit (50 req/s) can easily handle this frequency for hundreds of customers. --- ## Re-Engagement Trigger — Bounced Demos **Goal:** When a prospect bounces from a demo tied to an open deal, automatically notify the rep to send a shorter or more targeted demo. **API call:** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` **Filter for:** `is_bounced = true` **Action:** Send the demo owner an email/Slack message: > "A prospect bounced from your _Product Overview Demo_ today. Consider sending a shorter, more focused demo or a playlist instead." --- # AI & LLM Workflows ## MCP Integration — Ask Questions About Your Demo Data **Goal:** Connect the API to Claude (or another LLM) via MCP so your team can ask natural-language questions about demo performance. **What this enables:** - _"How many demos were completed last week?"_ - _"Which demo has the highest engagement?"_ - _"Compare embed vs. direct link performance this month"_ - _"Show me the trend for bounce rate over the last 90 days"_ **Setup:** Your Walnut account team can help configure the MCP server. Once connected, any MCP-compatible AI tool can query your demo data conversationally. --- ## AI-Powered Weekly Digest **Goal:** Generate a natural-language summary of demo performance for leadership — no dashboard login needed. **Step 1 — Pull the summary:** ```bash curl -H "x-api-key: YOUR_API_KEY" \\ "" ``` **Step 2 — Feed to an LLM with a prompt like:** > "Summarize this demo analytics data for a VP of Sales. Highlight wins, concerns, and recommended actions. Keep it to 5 bullet points." **Step 3 — Deliver via Slack or email** every Monday morning. --- # Pagination Recipe — For Large Data Pulls If you need to export all sessions (e.g., for a data warehouse), you'll need to paginate. The API returns max 10,000 rows per request. **Python example:** ``` import requests API_KEY = "YOUR_API_KEY" BASE_URL = "" LIMIT = 5000 offset = 0 all_sessions = [] while True: response = requests.get( BASE_URL, headers={"x-api-key": API_KEY}, params={ "limit": LIMIT, "offset": offset, "user_type": "external", "start_date": "2026-01-01" } ) data = response.json() all_sessions.extend(data["data"]) if data["count"] \< LIMIT: break offset += LIMIT print(f"Total sessions pulled: {len(all_sessions)}") ``` ⚠️ **Tip:** For very large datasets (100K+ sessions), run the export during off-hours and use `start_date`/`end_date` to break it into monthly chunks. --- # Which Recipe Should You Start With? | Your Priority | Start Here | Time to Set Up | | --- | --- | --- | | Sales wants faster follow-up | Hot Lead Alerts (Zapier/Slack) | ~1 hour | | Leadership wants visibility | BI Dashboard or AI Weekly Digest | ~2 hours | | RevOps wants CRM attribution | HubSpot or Salesforce daily sync | ~3 hours | | Team wants to explore data freely | MCP / AI integration | ~30 min with Walnut team | | Quick win, minimal effort | Google Sheets summary | ~15 minutes |