# Create a Daily Cross-Team Sync Orchestrator with OpenAI: n8n workflow

> Started by a clock, and works across Gmail, Notion and Slack. It hands the judgement calls to OpenAI.

Source: https://millionrounds.com/workflow/create-a-daily-cross-team-sync-orchestrator-with-openai (Millionrounds; every figure on the page links to its filing or article)

[Automation library](https://millionrounds.com/workflows) · [Data collection](https://millionrounds.com/workflows?category=Data+collection#library)

# Create a Daily Cross-Team Sync Orchestrator with OpenAI

Started by a clock, and works across Gmail, Notion and Slack. It hands the judgement calls to OpenAI. 61 steps, 2 branches: large, and worth reading before you trust it with anything live.

Large Calls a model: OpenAI

[Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fcreate-a-daily-cross-team-sync-orchestrator-with-openai)

**61 steps** Large: read it before trusting it with anything live

**2** Branches: places the flow splits

**0** Loops or waits

**3** Services it connects to

## The flow

Starts it 1 Model 6 Logic 34 Service 19

The steps in the order they run, from what starts it. The first 60 of 61.

- 1 **Monday Sync Trigger** Schedule trigger *Starts it*
- 2 **Read Settings** Notion *Service*
- 3 **Check Demo Mode** If *Logic*
- 4 **Last Week Window** Date Time *Logic*
- 5 **Get LW Priorities** Notion *Service*
- 6 **Get LW Signals** Notion *Service*
- 7 **Get LW Meetings** Notion *Service*
- 8 **Get LW Decisions** Notion *Service*
- 9 **Get LW Actions** Notion *Service*
- 10 **Get LW Emails** Notion *Service*
- 11 **Get LW Standups** Notion *Service*
- 12 **Normalize Priorities** Code *Logic*
- 13 **Normalize Signals** Code *Logic*
- 14 **Normalize Meetings** Code *Logic*
- 15 **Normalize Decisions** Code *Logic*
- 16 **Normalize Actions** Code *Logic*
- 17 **Normalize Emails** Code *Logic*
- 18 **Normalize Standups** Code *Logic*
- 19 **Set Priorities** Set *Logic*
- 20 **Set Signals** Set *Logic*
- 21 **Set Meetings** Set *Logic*
- 22 **Set Decisions** Set *Logic*
- 23 **Set Actions** Set *Logic*
- 24 **Set Emails** Set *Logic*
- 25 **Set Standups** Set *Logic*
- 26 **Merge All Data** Merge *Logic*
- 27 **Master Context** Code *Logic*
- 28 **Team Profiles** Code *Logic*
- 29 **Route to Teams** Switch *Logic*
- 30 **Filter Eng Data** Code *Logic*
- 31 **Filter Design Data** Code *Logic*
- 32 **Filter Sales Data** Code *Logic*
- 33 **Filter Support Data** Code *Logic*
- 34 **Aggregate Leadership Data** Code *Logic*
- 35 **Build Eng Context** Code *Logic*
- 36 **AI Design Brief** Open Ai *Model*
- 37 **AI Sales Brief** Open Ai *Model*
- 38 **AI Support Brief** Open Ai *Model*
- 39 **AI Exec Brief** Open Ai *Model*
- 40 **AI Strategic Recs** Open Ai *Model*
- 41 **AI Eng Brief** Open Ai *Model*
- 42 **Format Design Brief** Code *Logic*
- 43 **Format Sales Brief** Code *Logic*
- 44 **Format Support Brief** Code *Logic*
- 45 **Build Leadership HTML** Code *Logic*
- 46 **Format Eng Brief** Code *Logic*
- 47 **Post Design Slack** Slack *Service*
- 48 **Email Sales Brief** Gmail *Service*
- 49 **Post Support Slack** Slack *Service*
- 50 **Email Leadership** Gmail *Service*
- 51 **Post Eng Slack** Slack *Service*
- 52 **Save Design Brief** Notion *Service*
- 53 **Sync to CRM** Http Request *Service*
- 54 **Sync to Zendesk** Http Request *Service*
- 55 **Save Leadership Brief** Notion *Service*
- 56 **Sync to Jira** Http Request *Service*
- 57 **Merge All Outputs** Merge *Logic*
- 58 **Aggregate Deliveries** Aggregate *Logic*
- 59 **Orchestration Report** Code *Logic*
- 60 **Save Orchestration** Notion *Service*

## How it's built

- **Starts on:** A clock
- **Steps:** 61, with 2 branches
- **Size:** Large: read it before trusting it with anything live
- **Connects to:** Gmail, Notion, Slack
- **Model:** OpenAI

## Questions

What does it need to run?

An n8n account, plus your own Gmail, Notion and Slack accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included.

What starts it?

It starts on a clock.

Does it use AI?

Yes. It calls OpenAI. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 61 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

**Before you run it**

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 61 steps before you point it at anything that matters.

## Run it in n8n

- **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n)
- **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fcreate-a-daily-cross-team-sync-orchestrator-with-openai)
- **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts.

Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind.

## Connects to

Each opens the other workflows that use it.

[Gmail](https://millionrounds.com/workflows?service=Gmail#library)[Notion](https://millionrounds.com/workflows?service=Notion#library)[Slack](https://millionrounds.com/workflows?service=Slack#library)

## Workflows like it

Also data collection, with the same services where possible, closest in size first.

- [**2-way sync Google Contacts and Notion** 60 steps · Notion](https://millionrounds.com/workflow/2-way-sync-google-contacts-and-notion)
- [**Interactive knowledge base chat with Supabase RAG** 43 steps · calls a model · Gmail, Google Drive](https://millionrounds.com/workflow/interactive-knowledge-base-chat-with-supabase-rag)
- [**AI-Powered news (stock, economy...) collector with Gemini** 41 steps · calls a model · Gmail, RSS](https://millionrounds.com/workflow/ai-powered-news-stock-economy-collector-with-gemini)
- [**Score job listings and generate tailored cover letters** 39 steps · calls a model · Apify, Gmail](https://millionrounds.com/workflow/score-job-listings-and-generate-tailored-cover-letters)
- [**An email assistant to manage your Gmail inbox with Gemini** 37 steps · calls a model · Email, Gmail](https://millionrounds.com/workflow/an-email-assistant-to-manage-your-gmail-inbox-with-gemini)
- [**Find and score event and speaker opportunities with Gumloop** 35 steps · Gmail, Postgres](https://millionrounds.com/workflow/find-and-score-event-and-speaker-opportunities-with-gumloop)
