composio-community/awesome-gtm-skills/notion-sales-pipeline

Notion Sales Pipeline

Manage a simple deal pipeline as a Notion database via Composio.

Workflow

1. Identify the database. Ask for the Notion database URL (or name + workspace). Required schema: Name, Stage (select), Account (text), Amount (number), Next Step (text), Close Date (date), Owner (person).
2. Link Notion:

``bash composio link notion ``

1. Find the DB ID:

``bash composio execute NOTION_SEARCH -d '{ "query": "Pipeline" }' ``

1. Add a deal:

``bash composio execute NOTION_CREATE_DATABASE_ITEM -d '{ "database_id": "abc...", "properties": { "Name": { "title": [{ "text": { "content": "Acme — Expansion" }}]}, "Stage": { "select": { "name": "Discovery" }}, "Amount": { "number": 45000 } } }' ``

1. Update stage:

``bash composio execute NOTION_UPDATE_PAGE -d '{ "page_id": "...", "properties": {...} }' ``

1. Weekly summary: Query DB, group by Stage, write a summary page or Slack message:

``bash composio execute NOTION_QUERY_DATABASE -d '{ "database_id": "..." }' ``

Summary template

# Pipeline — Week of <date>
Open: <n> deals · $<sum> weighted
By stage: Disco <n>/$<amt> · Eval <n>/$<amt> · Proposal <n>/$<amt>
Moved this week: <list>
Stalled > 21 days: <list>

Guardrails

• Before creating a new deal, query by Account to avoid duplicates.
• Never delete a deal page — set Stage to Closed Lost with a reason instead.
• If Stage changes to Closed Won, prompt the user to confirm amount and close date.