Notion Automations: Define the Trigger, Action and Exception
Plan a native Notion handoff before building it: define the event, eligible records, target, exceptions, and the evidence you need before retrying.
A practical library for building,
organizing and working in Notion.
Author
Kevin Turner writes and publishes NotionSolutions guides for freelancers and small teams, using current documentation and attributed evidence.
Plan a native Notion handoff before building it: define the event, eligible records, target, exceptions, and the evidence you need before retrying.
Turn existing projects and tasks into a weekly review: surface late work, upcoming deadlines, waiting decisions, and gaps that filters can hide.
Choose the layout from the next client-work decision, then set its source, fields, filters, dates, and access. Includes a small project example and current Chart, Form, and Dashboard conditions.
Compare a project page with a task-led client workflow, then check client permissions, recurring work, annual member costs, and who will maintain the system.
Use Basic for page-based summaries, extraction, and tagging. Choose Custom Agent for wider search or coordinated updates, with access and credit checks.
Notion AI makes the strongest case when your team already maintains its knowledge in Notion. Choose the right capability, calculate the plan and credit costs, and set a human review point before expanding.
Choose Notion when client records need working documents. Choose Airtable when linked data and tailored editing interfaces drive daily client operations.
A practical choice for document-heavy client work—once access, recurring tasks and export limits are clear.
A date difference and an inclusive calendar count answer different questions. Check the inputs, range endpoints and clock before adding one to dateBetween.
A date-looking value can be Text or a List. Trace the input type, keep date calculations as Date values, and decide whether an automation should clear or preserve its target.
A recurring page can appear without starting its follow-up automation. Check the creation path, then choose template defaults, a direct schedule, or a deliberate human action.
Choose what starts the next task: a calendar date or the actual completion of the previous cycle. Keep deadlines, task history and duplicate checks explicit.
Share a private client portal, grant access to the right records, and check the routes that can expose more. Includes current page-level rules and submission options.
Choose a guest for selected client pages or a member for ongoing workspace work. Compare access, current guest allowances, annual seat costs, and the invitation settings that can change the role.
An empty rollup needs a precise diagnosis. Trace the source value and relation, then check the calculation, unsupported inputs, access or integration retrieval.
Build a small client-work tracker with clear relation limits, one shared task list, and views that show what needs attention. Includes a setup walkthrough and checks before real use.
Start with Clients and Projects, then keep each relationship moving with a next action and review date. This guide explains the follow-up queues and limits that matter.
Connect each project to its client, then calculate only the values that answer a useful question.