Daily Sales Metrics Synchronization
Sales metrics are buried in Salesforce; your team needs a consolidated daily view. This automation syncs key Salesforce metrics to a Google Drive dashboard every day, so leadership and teams always have current visibility into pipeline, conversion, and performance without digging through reports.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Update File (Metadata)
Updates file metadata. uses patch semantics (partial update) as per google drive api v3. use this tool to modify attributes of an existing file like its name, description, or parent folders. note: this action currently supports metadata updates only. file content updates require multipart/related upload and are not yet implemented.
Why this helps
Sales metrics are buried in Salesforce. Team members need to ask for updates or hunt through reports. Manual daily reporting wastes management time.
- Provide automatic daily visibility into key sales metrics
- Reduce time spent generating daily reports
- Give teams quick access to consolidated performance data
- Improve leadership decision-making with current metrics
Setup
Build it in a few focused steps.
- 1Connect Salesforce and Google Drive to Notis in the portal.
- 2Create an automation by asking Notis 'Every day at [time], pull key Salesforce metrics and update my sales dashboard in Google Drive' or use Automations -> New Automation.
- 3Set your trigger to a daily schedule (e.g., 'Daily at 9am') and choose your notification channel.
- 4Describe which metrics to include (e.g., 'Pipeline total, conversion rate, average deal size, opportunities created, closed deals') and how to format the dashboard in plain language.
- 5Test the automation by running it manually and verifying metrics appear correctly in your Google Drive dashboard.
Questions about this workflow
What metrics should be included in the daily sync?
Describe in your prompt exactly which metrics matter to you (e.g., 'Pipeline total, active leads, conversion rate, average deal value, weekly close rate'). Notis will pull and sync those.
Should the dashboard include historical data or just today's metrics?
Include that in your prompt (e.g., 'Show today's metrics and a 30-day trend' or 'Show just today's snapshot'). Notis will format accordingly.
What time should the daily sync run?
Specify in your automation setup (e.g., '9am daily' or '5pm every business day'). Choose a time when your team needs to see the metrics.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Salesforce to Google Drive. A trigger fires from one place; an action lands in another.
Salesforce triggers
Google Drive actions
Account Created or Updated
Triggers when an Account is created or updated in Salesforce. Uses LastModifiedDate high-watermark to capture both creations and updates.
Add file sharing preference
Modifies sharing permissions for an existing google drive file, granting a specified role to a user, group, domain, or 'anyone'.
Contact Updated
Triggers when an existing Salesforce Contact record is modified. Emits changed fields alongside relevant timestamps.
Copy file
Duplicates an existing file in google drive, identified by its `file id`.
Record Updated (Generic SObject)
Triggers when monitored fields change on any Salesforce SObject. You specify the SObject type and which field values should be returned in the payload. The trigger uses SystemModstamp to detect changes regardless of which specific field changed.
Create Comment
Tool to create a comment on a file. use when you need to add a new comment to a specific file in google drive.
New Contact Trigger
Triggers when a new Contact is Created in Salesforce.
Create Shared Drive
Tool to create a new shared drive. use when you need to programmatically create a new shared drive for collaboration or storage.
New Lead Trigger
Triggers when a new Lead is created in Salesforce.
Create File or Folder
Creates a new file or folder with metadata. use to create empty files or folders, or files with content by providing it in the request body (though this action primarily focuses on metadata creation).
New or Updated Opportunity
Triggers when a Salesforce Opportunity is created or updated.
Create a File from Text
Creates a new file in google drive from provided text content (up to 10mb), supporting various formats including automatic conversion to google workspace types.
Task Created or Completed
Triggers when a Task is created or when its status changes to Completed in Salesforce. Supports optional filtering by task Status or Subject.
Create a folder
Creates a new folder in google drive, optionally within a parent folder specified by its id or name; if a parent name is provided but not found, the action will fail.
Create Reply
Tool to create a reply to a comment in google drive. use when you need to respond to an existing comment on a file.
Connect any two apps with Notis in the middle.
Not just Salesforce and Google Drive. Any combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Google Drive.