salesforce
Query Records
Query Salesforce opportunities closed in the reporting period with amount, currency, and close date fields.
The scenario uses specific integration tools at each step, while Metorial keeps access scoped and visible.
Query Salesforce for all opportunities closed within the reporting period, including currency, amount, and close date fields.
Convert close dates to the reporting timezone to ensure transactions are assigned to the correct period without timezone boundary errors.
For each foreign currency transaction, retrieve the historical exchange rate on the close date and calculate the normalized amount in the reporting currency.
Aggregate the normalized figures by region, product line, and currency, then post the consolidated report to the finance Microsoft Teams channel.
salesforce
Query Salesforce opportunities closed in the reporting period with amount, currency, and close date fields.
salesforce
Execute an existing Salesforce revenue report to retrieve structured financial data for the period.
abstract
Retrieve historical exchange rates for each transaction date to normalize foreign currency amounts to the reporting currency.
abstract
Convert transaction timestamps to the reporting timezone to ensure period boundaries are applied correctly.
microsoft-teams
Post the consolidated revenue report to the finance Microsoft Teams channel for review.
Integration
Manage CRM data including Accounts, Contacts, Leads, Opportunities, Cases, and custom objects. Create, read, update, and delete records. Query data using SOQL and search across objects using SOSL. Perform bulk data operations for large-scale imports, exports, and migrations. Execute composite requests to batch multiple operations in a single API call. Access analytics, reports, and dashboards. Manage files and attachments associated with records. Interact with Chatter feeds, posts, and groups for social collaboration. Subscribe to real-time change events via Change Data Capture and Platform Events. Manage org metadata including custom objects, fields, layouts, and workflows. Query data using GraphQL for precise data retrieval across related objects.
Integration
Validate, enrich, and look up data through a suite of utility APIs. Validate email addresses for deliverability, format, and risk (disposable, spam trap, role-based detection). Validate and identify phone numbers with carrier, line type, and location details. Geolocate IP addresses and detect VPNs, proxies, and TOR usage. Enrich company data from domains or emails. Retrieve live and historical currency exchange rates and perform conversions. Look up public holidays by country and date. Get current time and convert between timezones. Scrape web page content from URLs. Capture website screenshots. Compress and optimize images. Generate user avatars. Validate VAT numbers and retrieve VAT rates. Validate IBAN bank account numbers.
Integration
Send, read, update, and delete messages in channels and chats. Create and manage teams, channels, and memberships. Schedule and manage online meetings, access call recordings and transcripts. Monitor user presence status in real time. Manage shifts, schedules, and time-off requests for frontline workers. Install and configure apps and tabs within teams. Send activity feed notifications to users. Subscribe to change notifications (webhooks) for messages, chats, teams, channels, memberships, presence, and meeting events. Create and manage tags for @mentioning user groups. Generate usage reports and import historical message data from other platforms.
Outcome 1
Metorial keeps the workflow connected, governed, and traceable across the systems involved.
Outcome 2
Metorial keeps the workflow connected, governed, and traceable across the systems involved.
Outcome 3
Metorial keeps the workflow connected, governed, and traceable across the systems involved.
Outcome 4
Metorial keeps the workflow connected, governed, and traceable across the systems involved.
Metorial is the governed connection layer between your AI agents and the tools your company runs on. It turns workflows like fp&a reporting support with exchange rate normalization into something you can deploy quickly, safely, and at scale.
Fast
Connect 1000+ verified integrations through one Magic MCP URL instead of building and maintaining bespoke connectors for each system in this workflow.
Secure
Protoguard inspects every message and tool call for prompt injection and policy violations before an agent touches your systems.
Enterprise
Agents act on real identity under company SSO, with per-user and per-group access policies and a complete, searchable record of everything that happens.
Team ready
Package this workflow as a skill, attach the tools it needs, and let teammates run it through Portals — governed by admins, owned by the people who do the work.
The Metorial products that connect, govern, and observe this scenario.
Connectivity
Start from 1000+ verified integrations or bring your own, and give every one a governed path to your agents under existing SSO and access policies.
Connectivity
A single URL your AI client connects to. Sign in with the login you already use and your agent reaches every integration and tool you allow — no per-app setup.
Identity
Sign in with company SSO, set policies per user and group, and let agents act on real identity across every connected system in this workflow.
Governance
Metorial’s security layer reviews every message and tool request before an agent acts — catching prompt injection and blocking anything outside your policies.
Observability
A complete, searchable record of everything your agents, team, and machines do across these integrations, so you can trust the workflow in production.
Governance
Let teammates connect agents to the integrations and skills your company already uses, with admins deciding who gets access to what.
However you adopt AI, Metorial has a path for connecting it safely.
Solution
Give the agents behind this scenario governed access to every tool and integration they need, with one connection layer instead of bespoke glue code.
Solution
SSO, granular access control, security review, and full audit trails so this workflow meets enterprise governance and compliance requirements.
Solution
Let the people who do this work connect their own AI agents to approved integrations and reusable skills — safely, without waiting on engineering.