Get clear creator and workflow reports in minutes. The system reads public stats, turns them into plain language, and saves a markdown file you can share. It fits community and marketing teams that need weekly highlights fast.

It listens for a chat message or a call from another workflow. Global settings point to JSON files. HTTP steps pull creator and workflow data, then the flow splits, sorts, and limits records to focus on top creators and popular workflows. A smart agent uses OpenAI to write a readable report for a single username or a top list summary. The file is saved with a time stamped name and the response is also returned to chat.

Use an OpenAI key or a local Ollama model. Set the data path so the request nodes can reach your JSON source. Expect report prep to drop from hours to minutes and get steady weekly updates for posts, newsletters, and community shout outs. Teams can track growth, highlight leaders, and keep sponsors informed without manual number crunching.

• Webhook chat trigger collects a username request and starts the run
• Execute by another workflow to embed the report tool in larger systems
• Global variables set the base path and filenames for the JSON feeds
• HTTP requests fetch creators and workflows using dynamic URLs
• Split, sort, and limit nodes pick the top creators and top workflows
• Filter by username to focus the report on one person when needed
• OpenAI model writes a clear markdown summary with key facts
• Convert to file and save steps create a local markdown file with a time stamped name

• Reduce manual report work from 2 hours to 5 minutes
• Streamline leaderboard prep by 80 percent with one run
• Improve data accuracy by pulling from a single JSON source
• Handle 10 times more creators without extra effort
• Connect AI writing with live stats for fast content

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with OpenAI and Ollama. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create an OpenAI credential. Generate an API key in your OpenAI account, then select the OpenAI node and choose your credential in the dropdown.
4. If you plan to use a local model, install and run Ollama on your machine. In the n8n credentials manager, create an Ollama credential and set the host and port. Select it on the Ollama model node if you switch from OpenAI.
5. Open the Global Variables node and confirm the path and filenames. These values must form valid URLs to your JSON sources when combined.
6. Open each HTTP Request node and click Execute Node to verify you receive a JSON response with a data array. Fix the path values if you see a 404 error.
7. Review the Split, Sort, and Limit nodes. Adjust the Top 25 creators and Top 300 workflows values to match your reporting needs.
8. Check the Filter By Creator Username node. Leave case sensitivity as needed or change it if your usernames vary in case.
9. Open the OpenAI chat model node and confirm your credential is selected and temperature is set to 0.1 for consistent results. Use the Ollama node only if you configured a local model.
10. Update the Save file path in the Save markdown node to a folder that your n8n instance can write to. For n8n Cloud, replace the save step with a cloud storage node or use the binary data download.
11. Test the internal trigger by running When Executed by Another Workflow with the sample JSON that includes a username. Confirm the Summary Report and the markdown file are produced.
12. Copy the chat webhook URL from the chat trigger and send a message with a username. Check that a report is returned and a file is saved with a time stamped name.
13. Troubleshoot common issues. If HTTP calls fail, check the path. If AI calls fail, verify the API key. If no results appear, review the filter and sorting nodes.