Lesson: Course Lesson: Using a Salesforce Report as a Data Source in Noca AI
Learn how to connect a live Salesforce report directly to a Noca AI bot, allowing your bot to query CRM data—such as accounts with expiring SLAs—in real time through natural language prompts.
Prerequisites
Before getting started, make sure you have:
-
An active Salesforce account with at least one configured report (e.g., Account SLA About to Expire).
-
An active Noca AI account with a bot already created.
Step 1: Create a New Salesforce Data Source Node
-
Open your workspace and navigate to your existing bot (e.g., Accounts Bot).
-
Click Add Node or Create a New Data Source.
-
Select Salesforce from the list of available integrations.
Step 2: Configure the Report Source
-
Under Set up your Connection, choose your active Salesforce connection.
-
In the Select a Source section, choose Report instead of Object.
-
From the Select a Report dropdown menu, find and select your report (e.g.,
Private Reports / Account SLA About to Expire).
Step 3: Define Query & Mapping Fields
-
Under Query Fields and Mapping Fields, select All to ensure the bot can retrieve and map all relevant data from your Salesforce report.
-
Rename your node to something descriptive, such as
SLA Expiration Report.
Step 4: Publish Your Workflow
-
In the top toolbar, click Go Live (or publish the version).
-
Add a version comment (e.g.,
SLA Expiration Report - [Date]). -
Click Confirm to publish the live version.
Step 5: Attach the Data Source to Your Bot
-
Return to your Bot Settings panel in the main bot builder.
-
Under Data Sources, click the + (Add) icon.
-
Select your newly created SLA Expiration Report from the list to attach it to the bot.
Step 6: Test & Debug Your Bot
-
In the upper-right corner, open the menu and select Debug draft version.
-
Once the chat window initializes, enter a natural language query, such as:
“What accounts are about to expire their SLA?”
-
The bot will query your Salesforce report in real time and return a structured table containing the account names, SLA tiers, and expiration dates!