Enrich prospects from Google Drive comments
A prospect detail added in a document comment can be enough to look up a person in Apollo, without leaving the review thread to start a separate search.
Trigger
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Action
Enrich person with Apollo
Enriches and retrieves information for a person from apollo.io, requiring one of: `email`, `hashed email`, `id`, `linkedin url`, or (`first name` and `last name` with `organization name` or `domain`) for matching; `webhook url` must be provided if `reveal phone number` is true.
Why this helps
Prospect details buried in document comments are easy to miss and take extra effort to look up in a CRM.
- Turn a prospect email in a comment into an Apollo person lookup.
- Keep document review and prospect research connected.
- Reduce context switching during lead review.
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Apollo once in the Notis portal.
- 2Create an automation in the portal or tell Notis from any channel.
- 3In one instruction, ask Notis to enrich the person using a prospect email included in each new comment.
- 4Pick the Google Drive Comment Added trigger and choose where run reports should go.
- 5Test with one real comment that includes a prospect email.
Questions about this workflow
What identifier should the comment include?
A prospect email is a supported identifier for person enrichment. Apollo also supports other identifiers, but the workflow should only use one when it is present in the comment or supplied in your instruction.
Will this reveal a phone number?
Not by default. Apollo requires a webhook URL when phone number reveal is requested, and this workflow does not assume one is configured.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Apollo. A trigger fires from one place; an action lands in another.
Google Drive triggers
Apollo actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Contacts to Sequence
Adds contacts to a specified apollo email sequence by initiating an asynchronous background job and returning its details.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Bulk organization enrichment
Enriches data for up to 10 organizations simultaneously by providing a list of their base company domains (e.g., 'apollo.io', not 'www.apollo.io').
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Bulk people enrichment
Use to enrich multiple person profiles simultaneously with comprehensive data from apollo's database.
File Created
Triggers when a new file is created in Google Drive.
Bulk update account stage
Bulk updates the stage for specified existing apollo.io accounts, moving them to a valid new account stage.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Create an Apollo account
Creates a new account in apollo.io; a new record is created even if a similar account exists, and provided `owner id` or `account stage id` must be valid existing ids.
File Shared (Permissions Added)
Triggers when new sharing permissions are granted to a file or folder. Uses Drive's `changes.list` endpoint with inline `permissions` in the `fields` mask so each change carries the file's current permission set provider-atomically. We diff that against `seen_permission_keys` to identify newly added grants. Drive page tokens are the primary cursor; if Drive rejects a stored token, the trigger raises `PollingTriggerError` without clearing state rather than silently re-baselining and dropping events. Limitation: truly ephemeral permissions (added and revoked between two polls without any other file modification in between) are not detected. Drive Activity API would catch those but requires an additional OAuth scope and a different payload contract.
Create Apollo contact
Creates a new contact in apollo.io; use `account id` to link to an organization and `contact stage id` for sales stage, noting that apollo does not perform automatic deduplication.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Create Apollo deal
Creates a new sales opportunity (deal) in apollo.io; all provided ids (`owner id`, `account id`, `opportunity stage id`) must be valid existing apollo identifiers.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Create Apollo Task
Creates a distinct apollo.io task for each contact id in contact ids, assigning them to user id; this action is not for free plan users and repeated calls create duplicate tasks.
Connect any two apps with Notis in the middle.
Google Drive and Apollo, 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 Apollo.