Back to Templates

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

Created by

Created by: Shelly-Ann Davy || SheCodesFlow

Shelly-Ann Davy

Last update

Last update 4 days ago

Share


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:

  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:

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

  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:

  • 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.