Create Arabic daily news audio briefings with Gemini, ElevenLabs and Telegram

Description

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.