Add detailed ACS context to matching research files
Let a new file that matches your existing Drive query kick off an ACS 5-year lookup for the geographies and measures your prompt names.
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
Get ACS 5-Year Estimates
Tool to retrieve 5-year american community survey estimates for a specified year. use when detailed acs data by geography and variables is required.
Why this helps
A research folder can fill up with useful reports while detailed neighborhood or county comparisons remain scattered across Census searches.
- Starts from the existing Drive query trigger
- Supports detailed estimates for specified geographies and variables
- Produces one readable summary alongside the file event
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Census bureau once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name the research outcome.
- 3In one instruction, tell Notis which geographies and ACS variables to retrieve for matching files, how to compare them, and what to flag when details are missing.
- 4Pick the Google Drive New File Matching Query trigger and choose a report channel.
- 5Test with one real matching file and review the selected year, variables, and geography in the report.
Questions about this workflow
Can this trigger use my existing Drive query settings?
The New File Matching Query trigger is the legacy query-centric event and preserves Drive query configuration. Choose that trigger in Notis, then describe the desired Census analysis in your prompt.
Will Notis choose ACS variables automatically?
The workflow should name the measures you want in its prompt. If variable identifiers or valid values are uncertain, use the Census variable details action in a separate workflow or specify that Notis should surface the uncertainty.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Census bureau. A trigger fires from one place; an action lands in another.
Google Drive triggers
Census bureau actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Get ACS 1-Year Estimates
Tool to retrieve 1-year american community survey (acs) estimates for a specified geography. use when you need the most recent annual acs data for a given area.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get ACS 5-Year Estimates
Tool to retrieve 5-year american community survey estimates for a specified year. use when detailed acs data by geography and variables is required.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Get American Business Survey
Tool to retrieve annual business survey (abs) data for a specified year and endpoint.
File Created
Triggers when a new file is created in Google Drive.
Get Community Resilience Estimates
Tool to retrieve community resilience estimates for a specified year. use after selecting variables and geography to get cre data for analysis.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Get County Business Patterns
Tool to retrieve county business patterns (cbp) data for a specified year. use when you need county-level business establishment and employment statistics filtered by industry and geography.
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.
Get Decennial Census Data
Tool to retrieve decennial census data for a specified vintage and dataset. use when you need census variables for a given geography.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Get Population Estimates
Tool to retrieve population estimates program (pep) data for a specified vintage and dataset. use when you need population or demographic estimates for specific geographies.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Get Variable Details
Tool to retrieve metadata for a specific variable in a census dataset for a given year. use when you need the label, concept, data type, attribute codes, and valid-value constraints.
Connect any two apps with Notis in the middle.
Google Drive and Census bureau, 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 Census bureau.