Daily top n8n creators report by email, Drive and Telegram

Daily top n8n creators report by email, Drive and Telegram

An n8n workflow that runs by itself every evening. An OpenAI agent reads the public stats for the ten most inserted
n8n template creators and their popular workflows, and writes a Markdown report. The workflow then saves it to Google
Drive, emails it through Gmail, and sends a top ten workflow list by email and Telegram.

How it differs from the chat report

Mindket lists a sibling workflow, Chat agent that writes a report on one n8n creator. That one waits for you, takes a
username in a chat and covers one creator. This one needs no input. It runs on a schedule, covers the top ten creators
together and delivers its results to places you read anyway. Pick this one for a standing report and the other for an
on demand lookup.

What is inside

• workflow.json: the workflow as n8n exports it, 27 nodes and 17 sticky notes. It holds no credential.
• README.md: these notes.

What we changed from the original copy

• The workflow reads two public stats files and expects each to arrive wrapped in a data field. Both are plain lists
  with no such field. We fetched them on 12 November 2026, and they held 2391 creators and 11487 workflows. The four
  steps that looked for the wrapper (Parse Creators Data, Split Out Creators, Parse Workflow Data and
  Split Out Workflows) are gone, and each sort step now takes the downloaded items directly.
• Both Gmail nodes sent to an address that belonged to the workflow's author. Each now reads <YOUR_EMAIL_ADDRESS>.
• Telegram Top 10 Workflows List read its chat from an environment variable of the author's n8n. It now reads
  <YOUR_TELEGRAM_CHAT_ID>.
• Save creator-summary.md wrote into a folder on its author's computer. The path now reads <YOUR_FOLDER_PATH>.
• Google Gemini Chat Model was set to models/gemini-2.0-flash-exp. It now reads models/gemini-3.6-flash. See Good
  to know.
• One long promotional sticky note is gone. Three others lost their links to outside pages.

Before you start

• An n8n instance, on n8n Cloud or your own server.
• An OpenAI API key, and a Google Gemini API key.
• A Google account for Gmail and Google Drive.
• Optional: a Telegram bot and the ID of the chat it should write to, and a folder on the machine that runs n8n for the
  saved file.

Set it up

1. In n8n, create a workflow, open its menu, choose Import from File and pick workflow.json. Save it. The agent's
   lookup tool is this same workflow, called by its own ID, so it must be saved first.
2. Add an OpenAI credential and select it in gpt-4o-mini.
3. Add a Google Gemini credential and select it in Google Gemini Chat Model.
4. Add a Gmail OAuth2 credential. Select it in Gmail Creators & Workflows Report and Gmail Top 10 Workflows List, and
   replace <YOUR_EMAIL_ADDRESS> in both.
5. Add a Google Drive OAuth2 credential and select it in Google Drive. The file lands in the root of My Drive. Pick
   another folder in the node if you prefer.
6. Add a Telegram credential and select it in Telegram Top 10 Workflows List. Replace <YOUR_TELEGRAM_CHAT_ID> with
   your chat's ID. To skip Telegram, delete that node.
7. To keep a local file as well, replace <YOUR_FOLDER_PATH> in Save creator-summary.md. To skip it, delete that node
   and creator-summary.
8. Press Test workflow once and check each place. Then turn the workflow on.

How a run goes

1. Schedule Trigger starts the run at 22:00 every day, in the time zone of your n8n.
2. n8n Creators Stats Agent gets the request "Prepare a report about the n8n creators". gpt-4o-mini is its model,
   with a temperature of 0.1.
3. The agent calls Workflow Tool, which runs this same workflow through When Executed by Another Workflow.
4. In that second run, Global Variables sets the address of the two stats files. stats_aggregate_creators and
   stats_aggregate_workflows download them, and each list is sorted by weekly inserters, highest first.
5. Take Top 10 Creators and Take Top 50 Workflows cut the lists down. Creators Data and Workflows Data keep the
   fields the report needs, and Merge Creators & Workflows joins creators to their workflows by username.
6. Aggregate and Workflow Response hand all of it back to the agent. Unlike the chat sibling, nothing filters it to
   one username.
7. The agent writes a Markdown report with a summary, hyperlinks to each workflow, a table, an analysis and extra
   insights. The run then splits in four:
   - creator-summary turns it into a text file, and Save creator-summary.md writes it to your folder.
   - Google Drive creates a text file named n8n Creator Stats Report with the time, in My Drive.
   - Convert Markdown to HTML makes it HTML, and Gmail Creators & Workflows Report emails it.
   - Create Top 10 Workflows List asks Gemini, at a temperature of 0.2, for a list of the ten workflows with the most
   weekly inserts, with links and no preamble. Convert Top 10 Markdown to HTML and Gmail Top 10 Workflows List
   email that list, and Telegram Top 10 Workflows List sends it to Telegram.

Change the look

• When it runs: Schedule Trigger.
• What the report holds: the instructions in n8n Creators Stats Agent.
• How many creators and workflows: Take Top 10 Creators and Take Top 50 Workflows.
• Which places receive it: delete the branches you do not want, or add nodes for Slack or another tool.
• The list's wording: the prompt in Create Top 10 Workflows List.

Good to know

• The facts below come from pages and n8n source read on 12 November 2026.
• The stats files are public, and the workflow reads them live from the address in Global Variables. If their owner
  moves or reshapes them, the lookup fails until you update that address.
• The report covers only the top ten creators and the top fifty workflows by weekly inserts, so it changes as the
  rankings move.
• The model is gpt-4o-mini. OpenAI's deprecations page gives 14 January 2027 as the shutdown date of gpt-4o,
  gpt-4o-mini, gpt-4.1 and gpt-4.1-mini, and names gpt-6-luna as their replacement. Pick another model before that
  date.
• Google's deprecations page lists the gemini-2.0-flash family as shut down on 1 June 2026, with gemini-3.6-flash as
  the replacement, and it does not list gemini-2.0-flash-exp by name. Mindket's copy uses the replacement.
• The Telegram message sets the HTML parse mode, but the list comes from Gemini as Markdown. Links may show as plain
  Markdown text there. Change the parse mode or convert the list first if that bothers you.
• A language model writes the report and can misread a number. Check anything you quote against the data.
• Billing: OpenAI and Google bill each run, and the report's table makes the calls long.
• Your data: the creators' public stats go to OpenAI and Google, and the report goes to Gmail, Google Drive and Telegram.
• Credentials: the JSON holds none.