Convert Voice Memos to Blog Posts with Deepgram, GPT-3.5 & Google Sheets Dashboard

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:
Coaches and course creators who teach best by speaking
Homemakers sharing wisdom without typing
Solopreneurs building authority without burnout
Anyone who thinks out loud but hates writing

The workflow:
🎙️ Transcribes your voice memo using Deepgram (via n8n’s Voice to Text node)
✍️ Rewrites it into a publish-ready post using GPT-3.5
🖼️ Generates a featured image using HTML to Image
📊 Saves the post to Google Sheets as your content calendar
📨 Emails you a draft for review
🖥️ 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:

| Service | Purpose | Free Tier Available? |
|--------|--------|----------------------|
| n8n | Orchestrate the automation | Yes |
| Deepgram | Voice-to-text transcription | Yes (free tier) |
| OpenAI | AI writing (GPT-3.5 or GPT-4) | Yes |
| Google Sheets | Store blog drafts and metadata | Yes |
| SMTP Email | Send draft emails (e.g., Gmail) | Yes (via app password) |
| Softr | Build a visual content dashboard | Yes |

🔐 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 Name | Purpose | Example |
|------------|--------|--------|
| Date | When the post was created | 2025-09-05 |
| Title | Blog post title (AI-generated or custom) | "What I Learned About Boundaries" |
| Content | AI-generated post body | "Today, I realized..." |
| Image_URL | Link to generated featured image | https://.../image.png |
| Status | Publishing status | Draft, Published, Reviewed |
| Audio_URL (optional) | Link to original voice memo | https://.../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
Go to your n8n dashboard.
Click Workflows > Create from JSON.
Paste the provided JSON.
Click Import.

2. Set Up Credentials
For each service, go to Credentials > Add New:
Deepgram**: Enter your API key
OpenAI**: Use your GPT API key
Google Sheets**: Connect via OAuth or service account
SMTP**: Enter your email credentials (e.g., Gmail app password)

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

3. Configure the AI Prompt
In the HubGPT: Rewrite as Blog Post node:
Edit the prompt to match your tone:
Rewrite this raw voice memo into a warm, engaging blog post:
{{ $json["text"] }}
Use short paragraphs, friendly tone, and end with a question to engage readers.