salesforce

What This Skill Does

The Salesforce skill provides an robust interface for interacting with Salesforce CRM environments directly through the Salesforce CLI (sf). It enables developers and data analysts to automate complex workflows including querying records via SOQL, manipulating data objects (Create, Read, Update, Delete), managing metadata, and executing Apex code. By integrating directly with the sf binary, the agent acts as a powerful middleware between natural language requests and the Salesforce API layer, handling everything from individual record updates to bulk data imports.

Installation

To install this skill, run the following command in your terminal within the OpenClaw environment: clawhub install openclaw/skills/skills/arvorco/salesforce

Ensure that the Salesforce CLI is globally installed on your system using npm install -g @salesforce/cli. Once installed, you must authenticate the agent by executing sf org login web or one of the supported headless authentication methods (such as JWT for CI/CD pipelines) to establish a secure connection to your specific Salesforce org.

Use Cases

• Automated Reporting: Generate daily summary reports on Opportunity pipelines or Lead conversion rates using complex SOQL queries.
• Data Management: Streamline CRUD operations for bulk record processing, such as updating thousands of contact records based on external CSV files.
• Metadata Deployment: Automatically synchronize local development changes to Salesforce sandboxes or production environments.
• CI/CD Integration: Integrate Salesforce deployments into existing DevOps pipelines, allowing the agent to handle metadata deployment and Apex testing dynamically.
• Health Checks: Quickly inspect organization limits, monitor API usage, and query custom metadata objects to troubleshoot issues.

Example Prompts

1. "Find all Opportunities closed in the last 30 days that have a value over $50,000 and output the results as a JSON list."
2. "Update the email address for all contacts associated with the 'Acme Corp' account to include the new company domain suffix."
3. "List all Apex classes in the current org and display their current status, excluding those that are currently inactive."

Tips & Limitations

• Formatting: Always include the --json flag in your CLI requests to ensure the agent receives structured data that it can parse accurately.
• Tooling API: When working with code or metadata (like ApexClass, Triggers, or Visualforce), remember to use the --use-tooling-api flag, as standard REST queries will not return these objects.
• Security: Be mindful when using verbose flags on production systems as they may output sensitive tokens or authentication details. Use environment variables for credentials where possible in automation scripts.