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
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.