Skip to content
Notis

Put county business data beside newly shared market research

When market research is shared with your team, have Notis look up relevant county business patterns and return a short, sourced-by-vintage summary.

Trigger

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.

Action

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.

Why this helps

Shared market research can prompt follow-up questions, but finding comparable business establishment or employment statistics takes another manual research pass.

  • Adds business establishment context to newly shared research
  • Uses the industries and geographies identified in readable file content
  • Calls out missing industry or county details for review

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, with a name for the market snapshot.
  • 3Tell Notis in one instruction to inspect newly shared market material, identify relevant counties and industries, retrieve County Business Patterns for the specified year, and summarize the results.
  • 4Pick the Google Drive File Shared trigger and choose a report channel.
  • 5Test with one real share event and confirm the year, county, industry, and limitations appear in the report.

Questions about this workflow

Does the share event include the document content?

The trigger represents new sharing permissions. Notis needs readable file context to identify counties and industries, so the prompt should tell it to flag inaccessible or insufficient material.

Can I use this for a specific industry?

Yes. Include the industry or industry-selection rule in the automation instruction. County Business Patterns supports year, industry, and geography inputs.

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.

TriggerScheduled

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.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

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.

ActionInstant

Comment Added (Docs/Sheets/Slides)

Triggers when a new comment is added to Google Docs, Sheets, or Slides.

TriggerPolling

Get American Business Survey

Tool to retrieve annual business survey (abs) data for a specified year and endpoint.

ActionInstant

File Created

Triggers when a new file is created in Google Drive.

TriggerPolling

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.

ActionInstant

File Deleted or Trashed

Triggers when a file is moved to trash or permanently deleted in Drive.

TriggerPolling

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.

ActionInstant

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.

TriggerPolling

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.

ActionInstant

File Updated

Triggers when a file's metadata or content changes in Google Drive.

TriggerPolling

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.

ActionInstant

Google Drive Changes

Triggers when changes are detected in a Google Drive.

TriggerPolling

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.

ActionInstant

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.