Task Context in Project Files
Task details shouldn't live only in Salesforce where team members forget to look. This automation posts task information as comments on related project files in Google Drive, keeping critical task context visible right where your team is actually working.
Trigger
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.
Action
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.
Why this helps
Task context is lost between Salesforce and shared project documents. Team members miss important task updates because they're not looking at Salesforce during active project work.
- Keep task context visible in active project files
- Eliminate context-switching between Salesforce and Drive
- Improve team communication during project work
- Ensure no task details are missed by the team
Setup
Build it in a few focused steps.
- 1Connect Salesforce and Google Drive to Notis in the portal.
- 2Create an automation by asking Notis 'When a task is created or completed in Salesforce, add a comment about it to the related project file in Google Drive' or use Automations -> New Automation.
- 3Set your trigger to 'Task Created or Completed' and choose your notification channel.
- 4Describe how to identify the related project file (e.g., 'Find the file with the project name matching the task description') and what information to post in plain language.
- 5Test by creating a task in Salesforce and verify a comment appears on the project file in Drive.
Questions about this workflow
How does Notis know which file to comment on?
Describe the matching method in your prompt (e.g., 'Find the file matching the task name or project code' or 'Look in the folder for this client'). Notis uses that logic.
What task information should be posted as a comment?
Specify in your prompt (e.g., 'Post the task name, due date, assignee, and description' or 'Just post the task status and who completed it'). Notis will include those details.
What if a task doesn't relate to a specific file?
Describe how to handle orphaned tasks in your prompt (e.g., 'Post them to a general project tracking file' or 'Skip them'). Notis will follow your preference.
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.