Send GitHub release audio newsletters with OpenAI, Google Drive, Gmail and Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) 3. AI Agent — Write Spoken Script (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Github Trigger
n8n-nodes-base.githubTrigger - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - HTTP Request
n8n-nodes-base.httpRequest - Google Drive
n8n-nodes-base.googleDrive - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Gmail
n8n-nodes-base.gmail
What it does
Quick overview This workflow triggers on a published GitHub Release, uses OpenAI to turn the release notes into a short spoken script and MP3, stores the audio on Google Drive, pulls subscribers from Google Sheets, and sends an HTML “listen” newsletter to them via Gmail. How it works 1. Triggers when a GitHub Release is published for the configured repository. 2. Parses and cleans the release changelog, extracting key items into features, fixes, improvements, and other notes. 3. Uses an OpenAI chat model to rewrite the release details into a 60–90 second spoken script. 4. Calls the OpenAI text-to-speech API to generate an MP3 audio file from the script. 5. Uploads the MP3 to Google Drive and sets the file permissions to “anyone with the link can view.” 6. Loads subscriber email addresses from Google Sheets, builds an HTML newsletter with the public audio link and release highlights, and sends it via Gmail using BCC. Setup 1. Connect a GitHub credential with access to the target repo and replace YOURGITHUBUSERNAME and YOURREPONAME in the GitHub trigger. 2. Add an OpenAI API credential for both the chat model step and the OpenAI TTS HTTP request. 3. Connect Google Drive OAuth2 and replace YOURAUDIOFOLDERID with the folder where the MP3 files should be saved. 4. Connect Google Sheets OAuth2, replace YOURSUBSCRIBERSSHEETID, and ensure your sheet includes subscriber rows with an Email (or email) column. 5. Connect Gmail OAuth2 and replace YOURSENDEREMAIL with the address that sends the newsletter.