Pricing Updates Auto-Sync: Keep Opportunity Line Items Fresh
Update your pricing sheet in Drive, and Notis automatically adds or updates line items in the matching Salesforce opportunity. Deals stay accurate without manual updates.
Trigger
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Action
Add product to opportunity
Adds a product (line item) to an opportunity. the product must exist in a pricebook entry that's associated with the opportunity's pricebook.
Why this helps
You update pricing in a Drive sheet, but the line items in Salesforce stay outdated. Your sales team quotes old prices, or finance chases discrepancies at close.
- Opportunity pricing always matches your latest sheet
- Stop manual line-item creation and updates
- Reduce pricing errors and discrepancies
- Keep deals accurate through close
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Salesforce to Notis.
- 2Tell Notis: 'When our pricing sheet updates, add or update line items in the matching opportunity.'
- 3Point Notis to your pricing document.
- 4Notis will extract product names, quantities, and prices automatically.
Questions about this workflow
Does Notis read pricing tables in Google Sheets?
Yes. Notis parses tables and extracts product, quantity, and price columns.
What if the product doesn't exist in our Salesforce pricebook?
Tell Notis to create it or skip it. You can customize this rule.
Can I handle multiple pricing tiers or currencies?
Yes. Tell Notis how to handle tiers and it will apply the right line items.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Salesforce. A trigger fires from one place; an action lands in another.
Google Drive triggers
Salesforce actions
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Create Salesforce Account
Deprecated: creates a new salesforce account using a json post request, requiring 'name'; specific fields (e.g., custom, dunsnumber) may have org-level prerequisites.
File Created
Triggers when a new file is created in Google Drive.
Add contact to campaign
Adds a contact to a campaign by creating a campaignmember record, allowing you to track campaign engagement.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Add lead to campaign
Adds a lead to a campaign by creating a campaignmember record, allowing you to track campaign engagement.
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.
Add product to opportunity
Adds a product (line item) to an opportunity. the product must exist in a pricebook entry that's associated with the opportunity's pricebook.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Apply lead assignment rules
Applies configured lead assignment rules to a specific lead, automatically routing it to the appropriate owner based on your organization's rules.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Associate contact to account
Associates a contact with an account by updating the contact's accountid field.
New File Matching Query
Triggers when a new Google Drive file matches a provided query. This is the legacy query-centric trigger: it preserves Drive API query config such as ``corpora`` / ``driveId`` aliases and emits the historical ``file_matching_query`` event type. ``FileCreatedTrigger`` covers the broader "new file" case and emits ``file_created``.
Clone opportunity with products
Clones an opportunity and optionally its products (line items). creates a new opportunity with the same field values and products as the original.
Clone record
Creates a copy of an existing salesforce record by reading its data, removing system fields, and creating a new record. optionally apply field updates to the clone.
Connect any two apps with Notis in the middle.
Not just Google Drive and Salesforce. 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 Salesforce.