Quick overview
Quick overview This workflow manually audits Closed Won Salesforce opportunities against billed amounts in Google Sheets, uses Google Gemini to analyze any revenue gap, then alerts a Slack user and writes an audit note back to the Salesforce opportunity. How it works Starts when you run the workflow manually. Fetches up to 20 Salesforce opportunities where the stage is "Closed Won" and processes them in batches with a short delay to reduce API pressure. Looks up matching billing rows in Google Sheets and totals the billed amount for the same Deal ID, then calculates the missing revenue versus the Salesforce Amount. For deals with a positive revenue gap, sends the discrepancy details to Google Gemini to classify severity and generate a root cause, recommendation, and Salesforce-ready audit note. Parses the Gemini JSON response and builds a formatted Slack message containing the deal, gap, severity, and recommended action. Sends the Slack alert and updates the Salesforce opportunity description with the audit note and the expected, billed, and missing amounts. Setup Add credentials for Salesforce OAuth2, Google Sheets OAuth2, Google Gemini (PaLM) API, and Slack OAuth2. In Salesforce, ensure opportunities have Amount, AccountId, StageName, and Name populated and that you want to audit only deals in the "Closed Won" stage. Update the Google Sheets document and sheet to your billing ledger, and ensure it contains columns named "Deal ID" and "Billed Amount" that match Salesforce AccountId values. In Slack, select the target user (or change the node to post to a channel) and verify the connected workspace has permission to send messages. Optionally adjust the Salesforce fetch limit, batch size, and wait duration to fit your deal volume and API limits. Additional info How To Customize Nodes Salesforce Node** Modify filters (e.g., include other deal stages) Add more fields if required Google Sheets Node** Adjust column mapping if your sheet structure differs Code Node (Comparison Logic)** Modify calculation logic for discounts, partial payments, or refunds Gemini Node** Update prompt to refine analysis or severity rules Slack Node** Change recipient from user to channel if needed Adjust message format Salesforce Update Node** Add custom fields or extend audit information Add-ons (Enhancements) Add a Schedule Trigger for automatic daily execution Store discrepancies in a database (e.g., PostgreSQL, Airtable) Send email notifications in addition to Slack Build dashboards for tracking revenue leakage trends Integrate with ERP systems for deeper validation Add retry logic for failed API calls Use Case Examples Detect missing invoices after deal closure Identify delays in billing processes Audit revenue discrepancies across systems Monitor high-value deals for financial gaps Automate internal financial compliance checks There can be many additional use cases depending on business needs. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No data from Salesforce | Incorrect credentials or filters | Verify OAuth connection and StageName filter | | No match in Google Sheets | Deal ID mismatch | Ensure Deal ID matches Salesforce AccountId | | AI parsing fails | Invalid JSON from Gemini | Ensure prompt enforces strict JSON output | | Slack message not sent | Incorrect user ID or permissions | Verify Slack OAuth and user ID | | No output after comparison | Missing amount is zero | This is expected behavior | | Salesforce not updated | Incorrect field mapping | Verify Opportunity ID and field permissions | | Workflow stops during execution | API rate limits | Increase delay in Wait node | Need Help? If you need help setting up or customizing this workflow, you can reach out to our n8n workflow developers at WeblineIndia. Support includes: Integration setup (Salesforce, Google Sheets, Slack, AI) Workflow customization Advanced automation development Production-level optimization Contact WeblineIndia to build or extend similar automation workflows tailored to your business needs. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
Others in the same category, ranked by how often they are opened.
