Automatically Create Weekly Data Collection Databases
Every week, Notis creates a fresh Notion database (with your predefined schema) ready for that week's data collection. Historical data stays organized by week, making it easy to compare periods and track trends over time.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
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.
Why this helps
Founders collecting ongoing data often struggle to organize it by time period. Creating new databases manually is tedious, and historical data becomes hard to navigate when it's all in one monolithic database.
- Databases automatically created on schedule
- Data organized by week for easy navigation
- Historical comparisons become trivial
- Reduces manual database maintenance
Setup
Build it in a few focused steps.
- 1Connect Notion to Notis.
- 2Create an automation: 'Every Monday (or your preferred day), create a new Notion database with this schema [describe properties] for this week's data collection.'
- 3Specify the database name format (e.g., 'Week of [date]') and parent page.
- 4Describe the database properties (columns) you want in each new database.
- 5Choose your notification channel and test by running the automation or waiting for the scheduled time.
Questions about this workflow
Can I use different schemas for different weeks?
Yes, include that logic in your prompt and Notis can vary the schema based on criteria (e.g., monthly databases have different fields than weekly).
What if I miss a week?
Notis follows the schedule you define. If you need to create databases retroactively, reach out to Notis support.
How many databases can I create this way?
Unlimited. Notion supports many databases, though your workspace may have other constraints.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Notion. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Notion actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
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.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
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.
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.
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.
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.
Archive Notion Page
Archives (moves to trash) or unarchives (restores from trash) a specified notion page.
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.
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).
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.
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.
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.
Create Notion page
Creates a new empty page in a notion workspace.
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.
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.
Google Sheets and Notion, 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 Notion.