Link Your Sheets and Drive Files with Auto-Shortcuts

Create a new sheet tab for a project. Notis creates a shortcut in Drive pointing back to that sheet, so your file folder and your data sheet are just one click apart.

Trigger

Worksheet Names Changed

Triggers when the set of worksheet/tab names changes in a Google Spreadsheet. Detects when sheets are added, deleted, or renamed.

Google Drive logo

Action

Create Shortcut to File/Folder

Tool to create a shortcut to a file or folder in google drive. use when you need to link to an existing drive item from another location without duplicating it.

Why this helps

You have project files in Drive and tracking sheets in Sheets, but they're disconnected. Team members have to search for both separately.

  • Files and sheets are instantly connected without manual linking
  • Team can navigate between related resources in one click
  • Reduces cognitive load of remembering where the sheet is

Setup

Build it in a few focused steps.

  • 1Connect both integrations to Notis
  • 2Tell Notis: 'When I add a sheet tab, create a shortcut in my Drive folder pointing to that sheet'
  • 3Specify which Drive folder should contain the shortcuts
  • 4Choose your notification channel
  • 5Test by adding a new sheet tab and verifying a shortcut appears in Drive

Questions about this workflow

Can I name the shortcut differently from the sheet tab?

Yes. You can customize the shortcut name or let Notis use the sheet tab name.

What happens if I rename a sheet tab?

Notis can update the shortcut name to match, or create a new shortcut with the new name.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Google Sheets to Google Drive. A trigger fires from one place; an action lands in another.

Google Sheets logo

Google Sheets triggers

Google Drive logo

Google Drive actions

Aggregate Metric Changed

Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.

TriggerPolling

Add file sharing preference

Modifies sharing permissions for an existing google drive file, granting a specified role to a user, group, domain, or 'anyone'.

ActionInstant

Cell Range Values Changed

Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.

TriggerPolling

Copy file

Duplicates an existing file in google drive, identified by its `file id`.

ActionInstant

Conditional Format Rule Changed

Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

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.

ActionInstant

Data Validation Rule Changed

Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

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.

ActionInstant

Developer Metadata Changed

Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

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

ActionInstant

Filtered Range Values Changed

Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.

TriggerPolling

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.

ActionInstant

New Rows in Google Sheet

Simple polling trigger that monitors Google Sheets for new rows. Detects when new rows are added and returns the complete row data. Perfect for triggering any workflow based on new sheet entries.

TriggerPolling

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.

ActionInstant

New Sheet Added in Google Spreadsheet

Polling trigger that detects when a new sheet is added to a Google Spreadsheet.

TriggerPolling

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.

ActionInstant

Connect any two apps with Notis in the middle.

Not just Google Sheets and Google Drive. Any combination from 985+ 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.