Query Files to Database Rows
Define a search query (like all PDFs, all client contracts, all 2024 content) and Notis finds matching files in Google Drive. Each match automatically becomes a row in your Notion inventory database, ready to track and manage.
Trigger
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``.
Action
Query database
Queries a notion database for pages (rows), where rows are pages and columns are properties; ensure sort property names correspond to existing database properties.
Why this helps
You have hundreds of files scattered across Google Drive matching certain criteria (contracts, invoices, designs, content drafts) but no central list of them. Tracking these files requires manually searching Drive each time. You forget which files exist or miss important documents.
- Create a searchable, centralized database of all files matching your criteria
- Know exactly what files you have without manually searching Google Drive
- Track file status, owner, and details directly in Notion instead of Drive
- Reduce time hunting for specific file types or documents
Setup
Build it in a few focused steps.
- 1Connect your Google Drive and Notion accounts to Notis.
- 2Create an automation with the prompt: 'Find all files in my Google Drive matching this query: [your search criteria like "filetype:pdf" or "name contains contract"]. Create a Notion database row for each file with the file name, file type, creation date, and a link to the file.'
- 3Select 'New File Matching Query' as the trigger and specify your search criteria.
- 4Choose your notification channel.
- 5Test by running the automation and confirming all matching files appear as rows in your Notion database.
Questions about this workflow
How specific can my search query be?
Very specific. You can search by file name, type, folder, owner, modification date, and more. Examples: 'all PDFs in my Contracts folder', 'all Docs created in 2024', 'all Sheets shared with external collaborators.'
Will this duplicate entries if files match multiple times?
Notis checks for duplicates before creating new rows. If a file already exists in your Notion database, it won't create another entry.
Can I set this to run on a schedule to find new matching files?
Yes. Ask Notis to 'run this query daily' or 'run this query weekly' in your automation prompt, and it will add new matching files to your Notion database automatically.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Notion. A trigger fires from one place; an action lands in another.
Google Drive triggers
Notion actions
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Add multiple content blocks (bulk, user-friendly)
Efficiently adds multiple standard content blocks to a notion page in a single api call with automatic markdown parsing. the 'content' field in notionrichtext blocks now automatically detects and parses markdown formatting including headers (# ## ###), bold (**text**), italic (*text*), strikethrough (~~text~~), inline code (`code`), links ([text](url)), and more. ideal for bulk content creation, ai agents, and replacing multiple individual add page content calls. supports automatic text formatting, content splitting, and up to 100 blocks per request.
File Created
Triggers when a new file is created in Google Drive.
Add content to Notion page
Deprecated: appends a single content block to a notion page or a parent block (must be page, toggle, to-do, bulleted/numbered list, callout, or quote); invoke repeatedly to add multiple blocks.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Append complex blocks (advanced, full control)
Appends complex blocks with full notion block structure to a parent block or page. use for advanced scenarios requiring precise control: code blocks, tables, embeds, nested children within blocks, or when working with pre-built notion block objects. requires full notion api block schema - use add multiple page content for simpler content creation.
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.
Archive Notion Page
Archives (moves to trash) or unarchives (restores from trash) a specified notion page.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Create comment
Adds a comment to a notion page (via `parent page id`) or to an existing discussion thread (via `discussion id`); cannot create new discussion threads on specific blocks (inline comments).
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Create Notion Database
Creates a new notion database as a subpage under a specified parent page with a defined properties schema; use this action exclusively for creating new databases.
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``.
Create Notion page
Creates a new empty page in a notion workspace.
Delete a block
Archives a notion block, page, or database using its id, which sets its 'archived' property to true (like moving to "trash" in the ui) and allows it to be restored later.
Connect any two apps with Notis in the middle.
Not just Google Drive and Notion. 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 Notion.