HeyGen + Google Sheets: daily videos posted for you

Posting consistently sounds simple until you’re the one hunting news, writing scripts, generating videos, and uploading to Instagram and TikTok before your first meeting.

If you’re a marketing manager, you feel the pressure to “keep the content engine running.” A solo founder feels it when content becomes the thing that never fits into the day. And agencies get stuck babysitting a pipeline that should be automatic. This HeyGen video automation fixes the grind by turning trending news into short vertical videos, then logging everything in Google Sheets as it ships.

You’ll see exactly what the workflow does, what you need to run it, and how the moving parts fit together so you can publish daily without living in 12 tabs.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: HeyGen + Google Sheets: daily videos posted for you

Click to explore

flowchart LR

    subgraph sg0["Flow 1"]
        direction LR
        n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/perplexity.dark.svg' width='40' height='40' /></div><br/>Perplexity Search"]
        n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/openAi.dark.svg' width='40' height='40' /></div><br/>Write Video Script"]
        n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Screenshot"]
        n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/openAi.dark.svg' width='40' height='40' /></div><br/>Write Video Caption"]
        n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract URL"]
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Prepare Avatar Data"]
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Create Avatar Video (Optimiz.."]
        n8@{ icon: "mdi:database", form: "rounded", label: "Store to Google Sheets", pos: "b", h: 48 }
        n9["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Prepare Sheets Data"]
        n17["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Upload to tmpfiles"]
        n18["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract tmpfiles"]
        n5 --> n3
        n3 --> n17
        n18 --> n4
        n1 --> n2
        n17 --> n18
        n2 --> n5
        n6 --> n7
        n9 --> n8
        n4 --> n6
        n7 --> n9
    end

    subgraph sg1["Flow 2"]
        direction LR
        n10["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/webhook.dark.svg' width='40' height='40' /></div><br/>HeyGen Webhook"]
        n11["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Process HeyGen Callback"]
        n12@{ icon: "mdi:database", form: "rounded", label: "Get Caption from Sheets", pos: "b", h: 48 }
        n13["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Combine Data"]
        n14@{ icon: "mdi:swap-vertical", form: "rounded", label: "Assign Social Media IDs", pos: "b", h: 48 }
        n15["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>INSTAGRAM"]
        n16["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>TIKTOK"]
        n19["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Upload to Blotato"]
        n20["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Extract Blotato URL"]
        n13 --> n19
        n10 --> n11
        n19 --> n20
        n20 --> n14
        n14 --> n15
        n14 --> n16
        n12 --> n13
        n11 --> n12
    end

    subgraph sg2["Schedule Daily Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Daily Trigger", pos: "b", h: 48 }
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n0 trigger
    class n8,n12 database
    class n3,n7,n17,n10,n15,n16,n19 api
    class n5,n6,n9,n18,n11,n13,n20 code
    classDef customIcon fill:none,stroke:none
    class n1,n2,n3,n4,n5,n6,n7,n9,n17,n18,n10,n11,n13,n15,n16,n19,n20 customIcon

Why This Matters: Daily Posting Falls Apart in the Middle

Daily content doesn’t usually fail because you “ran out of ideas.” It fails because the process is full of tiny steps that drain attention. Find an article. Pull the link. Write a hook. Rewrite it because it’s too long. Create a background clip. Generate the talking avatar. Export. Upload. Write captions for each platform. Then you forget where you saved the file, or you can’t remember which version was approved. By day four, it’s already slipping, and honestly, the inconsistency hurts more than “average” content quality ever will.

The friction compounds. Here’s where it breaks down.

Finding “viral-worthy” news every morning turns into a half-hour research spiral.
Script writing and caption writing are repeatable, but doing them manually invites inconsistency and extra edits.
HeyGen video creation is asynchronous, so without a callback process you end up checking for completion like it’s a loading bar from 2009.
If you don’t track video IDs, captions, and statuses somewhere centralized, troubleshooting becomes guesswork and scaling becomes painful.

What You’ll Build: Daily AI News Videos That Publish Themselves

This workflow runs on a daily schedule (6 AM by default) and builds a complete short-form video from trending news. First, it uses Perplexity to find a timely story worth turning into content. Then GPT-4.1 writes a tight 30-second script with a hook, the key points, and a simple CTA. The workflow captures a scrolling visual of the source article, uploads that background clip to temporary storage, and packages everything for HeyGen. HeyGen generates the avatar video, then calls back into n8n via a webhook once it’s ready. Finally, the finished file gets sent to Blotato for social posting, while Google Sheets keeps a clean record of the video ID, caption, timestamp, and status so you can track what happened without digging.

It starts with a schedule trigger and ends with two posts going live: Instagram and TikTok. In the middle, Google Sheets acts like your lightweight database, which keeps captions and video IDs tied together even when HeyGen finishes later.

What You’re Building

What Gets Automated

What You’ll Achieve

A daily Perplexity search pulls trending news into your pipeline.
GPT-4.1 generates a short script and a platform-ready caption.
HeyGen turns the script into a vertical talking-avatar video with a news-style background clip.
Publishing to Instagram and TikTok happens automatically through Blotato once the video is ready.

One daily content run without manual uploads (about 1 hour saved per day for many teams).
More consistent posting, because the workflow runs even when you’re busy.
Cleaner collaboration since captions and video IDs are stored in Google Sheets.
Fewer “where is that file?” moments, because the workflow keeps links and statuses together.
An easy base to expand to more platforms by duplicating the posting steps.

Expected Results

Say you publish one 30-second news video every weekday to Instagram and TikTok. Manually, plan for about 20 minutes to find a story, 20 minutes to write a script and caption, then another 20 minutes juggling exports and uploads, so roughly 1 hour a day. With this workflow, you spend maybe 5 minutes reviewing what it generated, then you’re done while HeyGen renders in the background. Over a week, that’s about 4 hours back, and posting still happens even if your calendar is packed.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
HeyGen for avatar video generation via API
Google Sheets to store video IDs and captions
API keys (Perplexity, OpenAI, ScreenshotOne, Cloudinary, Blotato, HeyGen)

Skill level: Intermediate. You’ll mostly paste API keys, update a few IDs (voice, avatar, sheet), and test a webhook callback.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A daily schedule kicks things off. At 6 AM (or your preferred time), n8n runs a Perplexity query to find a trending news story that’s likely to perform well on short-form platforms.

The story becomes a script and caption. OpenAI (GPT-4.1) writes a 30-second script with a strong hook, then generates a tight caption in the 150–200 character range so you’re not rewriting copy every morning.

The video gets assembled for HeyGen. The workflow captures a scrolling-style visual of the article using ScreenshotOne, uploads the background clip to temporary storage, and combines that with your HeyGen talking photo avatar and voice settings.

Publishing waits for the callback. HeyGen renders the video asynchronously and hits your n8n webhook when it’s complete. n8n pulls the matching caption from Google Sheets, pushes the final media to Blotato, then posts to Instagram and TikTok using the account IDs you’ve set.

You can easily modify the Perplexity query to target different industries, or swap Instagram/TikTok for other platforms supported by your publishing setup. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Schedule Trigger

Set the daily trigger that starts the entire automation sequence.

Add or open the Scheduled Daily Start node.
Set the schedule options to your desired daily run time.
Confirm that Scheduled Daily Start outputs to Perplexity Query.

Step 2: Connect AI Research and Script Generation

Configure the AI nodes that create the topic research and video script.

Open Perplexity Query and add your API settings.
Open Generate Video Script and configure your prompt or model settings.
Ensure the flow follows Perplexity Query → Generate Video Script → Parse Source URL.

Credential Required: Connect your Perplexity credentials in Perplexity Query.

Credential Required: Connect your OpenAI credentials in Generate Video Script and Generate Video Caption.

⚠️ Common Pitfall: The OpenAI and Perplexity nodes have no credentials configured in the workflow. You must add the correct credentials before testing.

Step 3: Set Up Source Parsing and Media Capture

These nodes parse the source URL, capture a snapshot, and prepare a file link for later use.

Review the code logic in Parse Source URL to ensure it extracts the correct URL.
Configure request details in Capture Page Snapshot to capture the page image.
Set the upload parameters in Upload to Tempfiles.
Verify Parse Tempfiles Link extracts the final media URL for downstream use.

Tip: Group the multiple code and httpRequest nodes by function when reviewing—source parsing, media capture, and API calls are handled across several nodes.

Step 4: Generate Captions and Request the Avatar Video

Use the processed assets to create captions and build the avatar payload for video generation.

Configure Generate Video Caption to use the parsed media link from Parse Tempfiles Link.
Review the payload structure in Assemble Avatar Payload to ensure it matches your avatar API requirements.
Set the API request details in Request Avatar Video.
Confirm the flow Generate Video Caption → Assemble Avatar Payload → Request Avatar Video.

Step 5: Store Records in Google Sheets

Log the generated video metadata and captions for tracking and later callbacks.

Review formatting logic in Format Sheet Record to ensure all required fields are included.
Open Append to Google Sheet and select your target spreadsheet and worksheet.
Verify the connection Request Avatar Video → Format Sheet Record → Append to Google Sheet.

Credential Required: Connect your Google Sheets credentials in Append to Google Sheet and Lookup Caption Row.

Step 6: Configure the HeyGen Callback and Social Publishing

Handle the external callback, merge the data, then post to social channels.

Set the webhook URL in Incoming HeyGen Hook and register it with your HeyGen callback settings.
Verify Handle HeyGen Callback and Lookup Caption Row logic for matching records.
Ensure Merge Callback Data sends the payload to Send to Blotato.
Confirm Parse Blotato Link outputs to Map Social Media IDs.
Map Social Media IDs outputs to both Post to Instagram and Post to TikTok in parallel.

⚠️ Common Pitfall: The parallel posting steps won’t run unless Map Social Media IDs returns correctly formatted IDs for both channels.

Step 7: Test and Activate Your Workflow

Validate each path and then enable the workflow for daily execution.

Use Scheduled Daily Start to run a manual test execution.
Confirm successful outputs through Append to Google Sheet and verify the callback flow from Incoming HeyGen Hook.
Check that Post to Instagram and Post to TikTok both execute after Map Social Media IDs.
When results look correct, toggle the workflow to Active for daily automated publishing.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Google Sheets OAuth permissions can be surprisingly finicky. If rows aren’t appending or lookups fail, check the Google Sheets credential in n8n and confirm it has access to the correct Google account and sheet.
If you’re using Wait-like timing or relying on external rendering, processing times vary. Bump up the wait duration (or ensure you’re relying on the HeyGen webhook) if downstream nodes run before the video URL exists.
Default prompts in AI nodes are generic. Add your brand voice and formatting rules early, or you will keep “fixing” hooks and CTAs forever.

Quick Answers

What’s the setup time for this HeyGen video automation automation?

About 45 minutes if you already have your API keys and social accounts connected.

Is coding required for this video publishing outcome from focus keyword?

No. You’ll mainly copy/paste IDs and credentials, then test the webhook once.

Is n8n free to use for this HeyGen video automation workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in API costs for Perplexity, OpenAI, ScreenshotOne, HeyGen, Cloudinary, and Blotato (HeyGen is usually the biggest line item).

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this HeyGen video automation workflow for different use cases?

Yes, and it’s expected. You can change the Perplexity query to target your niche, swap the OpenAI prompts to match your brand voice, and duplicate the posting step to add more platforms. If you want an approval step, the simplest move is to write a “status = pending” row to Google Sheets and only publish when you flip it to “approved.”

Why is my HeyGen connection failing in this workflow?

Most of the time it’s an API key issue or a missing header (HeyGen expects your X-Api-Key to be correct). Also confirm your talking_photo_id and voice_id are real, active IDs in your HeyGen account. If the render starts but never finishes in n8n, the callback_url is usually wrong or not reachable from the public internet, so the webhook never receives the completion event.

What volume can this HeyGen video automation workflow process?

For one video per day, it’s very comfortable on almost any plan. On n8n Cloud, your limit is based on monthly executions (Starter is fine for low-volume daily workflows), and if you self-host there’s no execution cap, just your server capacity. Practically, HeyGen rendering time is the main throughput limiter, so scaling usually means running multiple daily items and handling callbacks cleanly.

Is this HeyGen video automation automation better than using Zapier or Make?

Often, yes, because this workflow needs webhooks, multi-step branching, and “wait for an async callback” behavior that gets awkward (and expensive) in simpler tools. n8n also makes it easier to keep a real audit trail in Google Sheets and to reuse data across steps without duplicating actions. Zapier or Make can still work if you simplify the flow, like generating a script and sending it to a human for publishing. But if you want hands-off daily posting, n8n is the cleaner fit. Talk to an automation expert if you want help choosing.

Once this is running, daily video publishing stops being a heroic effort and becomes a background process. You review when you want. The workflow does the rest.

HeyGen + Google Sheets: daily videos posted for you

How This Automation Works

n8n Workflow Template: HeyGen + Google Sheets: daily videos posted for you

Why This Matters: Daily Posting Falls Apart in the Middle