🎬 Convert voice memos to blog posts with Deepgram, GPT-3.5 & Google Sheets dashboard

38 views · 🎬 Content Creation & Video

Description

Voice Memo to Blog Post with Deepgram, GPT-3.5 & Softr for Creators

Turn Voice Memos into Published Blog Posts Using AI and Automation

Stop letting great ideas vanish in your Notes app. This workflow transforms your voice memos into polished blog posts, LinkedIn articles, or newsletters — automatically.

Perfect for:

The workflow:

  1. 🎙️ Transcribes your voice memo using Deepgram (via n8n’s Voice to Text node)
  2. ✍️ Rewrites it into a publish-ready post using GPT-3.5
  3. 🖼️ Generates a featured image using HTML to Image
  4. 📊 Saves the post to Google Sheets as your content calendar
  5. 📨 Emails you a draft for review
  6. 🖥️ Syncs to your Softr dashboard for visual content planning

No typing. No staring at a blank screen. Just speak — and publish.


Prerequisites

Before using this workflow, ensure you have the following accounts:

ServicePurposeFree Tier Available?
n8nOrchestrate the automationYes
DeepgramVoice-to-text transcriptionYes (free tier)
OpenAIAI writing (GPT-3.5 or GPT-4)Yes
Google SheetsStore blog drafts and metadataYes
SMTP EmailSend draft emails (e.g., Gmail)Yes (via app password)
SoftrBuild a visual content dashboardYes

🔐 You’ll need API keys for: Deepgram, OpenAI, and SMTP
✅ All credentials should be stored securely in n8n


Google Sheets Setup

Your Google Sheet must have the following columns for the workflow to work correctly:

Column NamePurposeExample
DateWhen the post was created2025-09-05
TitleBlog post title (AI-generated or custom)“What I Learned About Boundaries”
ContentAI-generated post body”Today, I realized…”
Image_URLLink to generated featured imagehttps://…/image.png
StatusPublishing statusDraft, Published, Reviewed
Audio_URL (optional)Link to original voice memohttps://…/memo.mp3

📌 Tip: Name your sheet “Content Calendar” and share it with your n8n service account or use OAuth.


Step-by-Step Setup Instructions

1. Import the Workflow into n8n

  1. Go to your n8n dashboard.
  2. Click Workflows > Create from JSON.
  3. Paste the provided JSON.
  4. Click Import.

2. Set Up Credentials

For each service, go to Credentials > Add New:

🔐 Never hardcode keys — always use n8n’s secure credential system.

3. Configure the AI Prompt

In the HubGPT: Rewrite as Blog Post node:

🔗 Nodes Used

Google Sheets

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup