Automated Weekly Lead Reporting
Creating weekly lead reports manually consumes hours that founders could spend on strategy. This automation generates comprehensive lead status reports in Google Drive every week, analyzing pipeline health, conversion rates, and activity so you have insights without the busywork.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
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.
Why this helps
Creating weekly lead reports manually takes hours away from sales and strategy. Leadership lacks timely visibility into pipeline health.
- Eliminate hours spent on weekly manual reporting
- Get weekly pipeline insights automatically
- Provide leadership with timely pipeline visibility
- Reclaim time for actual sales work
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 week, generate a lead status report in Google Drive analyzing this week's pipeline activity and performance' or use Automations -> New Automation.
- 3Set your trigger to run weekly (e.g., 'Every Monday at 9am') and choose your notification channel.
- 4Describe what analysis to include (e.g., 'Total active leads, new leads this week, conversion rate, average lead value, top performers, and conversion forecast') in plain language.
- 5Test the automation and review the first weekly report to ensure it includes the insights you need.
Questions about this workflow
What metrics should be in the weekly report?
Specify in your prompt exactly what you need to see (e.g., 'Active leads, new leads, conversion rate, pipeline trend, top deals, and forecast'). Notis will generate those metrics.
When should the weekly report be generated?
Specify the day and time in your automation setup (e.g., 'Monday at 9am' or 'Friday at 5pm'). Choose when it's most useful for your team.
Should the report include comparisons to previous weeks?
Yes. Include that in your prompt (e.g., 'Compare this week to last week' or 'Show 4-week trend'). Notis will include trend analysis.
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
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add file sharing preference
Modifies sharing permissions for an existing google drive file, granting a specified role to a user, group, domain, or 'anyone'.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Copy file
Duplicates an existing file in google drive, identified by its `file id`.
Account Created or Updated
Triggers when an Account is created or updated in Salesforce. Uses LastModifiedDate high-watermark to capture both creations and updates.
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.
Contact Updated
Triggers when an existing Salesforce Contact record is modified. Emits changed fields alongside relevant timestamps.
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.
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 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 Contact Trigger
Triggers when a new Contact is Created in Salesforce.
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.
New Lead Trigger
Triggers when a new Lead is created in Salesforce.
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.
New or Updated Opportunity
Triggers when a Salesforce Opportunity is created or updated.
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.
Salesforce and Google Drive, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Google Drive.