Get a daily creator and workflow report with rankings and a short summary, then send it by email and Telegram. Ideal for community and marketing teams that publish top lists and weekly highlights without manual work.

A schedule starts the job or another workflow can call it on demand. The flow fetches two JSON files with stats using HTTP requests and a global base path, then parses, splits, sorts, and trims the lists to the top creators and workflows. It merges the results and asks AI to write a clear summary. The report is saved as Markdown, converted to HTML, stored in Google Drive, and delivered through Gmail and Telegram. A tool endpoint can also return stats for a single username.

Setup needs API keys for OpenAI and Google Gemini and OAuth for Gmail, Google Drive, and Telegram. Expect faster reporting and steady daily updates with no copy and paste. This is useful for leaderboards, community roundups, and product usage digests with clear, repeatable output.

• Scheduled runs and on demand calls using a trigger and a tool interface
• HTTP requests pull JSON stats for creators and workflows from a public source
• Global variables set the base path and filenames for easy reuse
• Split, sort, and limit steps create a top 10 creators list and a top 50 workflows list
• AI models generate a readable summary from merged stats
• Markdown output converts to HTML for clean email formatting
• Emails send through Gmail and messages post to Telegram
• Files save to Google Drive and optionally to local storage
• A tool endpoint returns stats for a single username when called by another workflow

• Reduce manual report building from 2 hours to 5 minutes
• Automate 90 percent of repetitive reporting tasks
• Improve accuracy by removing copy and paste errors
• Publish consistent daily updates to email and chat
• Handle 10 times more data without extra staff

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, Google Gemini, Google Drive, Gmail and Telegram. See the Tools Required section above for links to create accounts with these services.
3. OpenAI: Double click the OpenAI node, choose Create new credential, enter your API key from your OpenAI account, name the credential clearly, and save.
4. Google Gemini: Double click the Google Gemini node, choose Create new credential, add your API key from Google AI Studio, name it, and save.
5. Gmail: Open the Gmail nodes, choose Create new credential, select OAuth2, follow the on screen Google sign in flow, grant send email permission, and save.
6. Google Drive: Open the Google Drive node, choose Create new credential, use OAuth2, sign in with a Drive account, and select the folder where reports will be stored.
7. Telegram: Open the Telegram node, choose Create new credential, paste the Bot Token from BotFather, set the Chat ID in the node, and save.
8. Open the Global Variables node and set the base path and filenames for the JSON sources. Keep them public and reachable.
9. Test the HTTP request nodes to confirm the JSON files download and include the expected data fields.
10. Adjust sorting and limits if you want a different top list size. The defaults are top 10 creators and top 50 workflows.
11. Preview the AI summary and the Markdown to HTML step to confirm formatting looks good in email clients.
12. Enter your email recipients in the Gmail nodes and send a test message. Check your Telegram chat by sending a test post.
13. Enable the Schedule Trigger for daily runs. Watch the next run to verify files save to Google Drive and messages are delivered. If an API call fails, check credentials and network access, then retry.