Quick overview
This workflow runs daily at 07:00, pulls Arabic headlines from an RSS feed, uses Google Gemini to rank and rewrite the top five stories into a short Modern Standard Arabic briefing, then sends the briefing as text and ElevenLabs-generated audio to Telegram while logging delivery details to Google Sheets.
How it works
- Runs every morning at 07:00 on a schedule.
- Reads up to 20 items from the configured Arabic RSS news feed.
- Sends the feed items to Google Gemini to select the five most important stories and rewrite them into a JSON briefing in Modern Standard Arabic.
- Parses Gemini’s JSON response into a formatted Telegram message and extracts key fields like date, top headline, and top summary.
- Sends the formatted text briefing to a Telegram chat using Markdown formatting.
- Converts the briefing text to Arabic speech with the ElevenLabs Text-to-Speech API and sends the resulting audio file to the same Telegram chat.
- Appends a delivery log row to a Google Sheets document with the date, top headline, top summary, audio sent status, and overall status.
Setup
- Add Google Gemini credentials (API key) for the Google Gemini node.
- Create a Telegram bot and add your Telegram bot token as credentials, then set the target Telegram chat ID in both Telegram send steps.
- Add an ElevenLabs API key using an HTTP header authentication credential and update the ElevenLabs voice ID in the Text-to-Speech request URL if needed.
- Connect Google Sheets credentials and replace
YOUR_GOOGLE_SHEET_ID with your document ID, ensuring the Briefings sheet exists with matching columns (Date, Headline, Summary, Audio Sent, Status).
- Review and update the RSS feed URL if you want to source headlines from a different publisher or feed.