Google Drive to Google Sheets, Facebook drafts ready

You upload a new tutorial video, and then the real time-sink starts. Writing a Facebook post, pulling out the “so what,” and coming up with an image idea turns into another task that sits in the queue for days.

If you’re a content creator, you feel it immediately. A marketing lead trying to keep the calendar full deals with it too. And agencies building repeatable systems for clients know how messy it gets without Drive post drafts automation.

This workflow watches a Google Drive folder for new videos, turns each upload into a ready-to-review Facebook draft plus an image concept, and logs everything to Google Sheets. You’ll see what it does, what you need, and how to get it running reliably.

How This Automation Works

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

n8n Workflow Template: Google Drive to Google Sheets, Facebook drafts ready

Click to explore

flowchart LR

    subgraph sg0["Trigger on New Video Upload Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Trigger on New Video Upload", pos: "b", h: 48 }
        n1@{ icon: "mdi:cog", form: "rounded", label: "Download Video File", pos: "b", h: 48 }
        n2@{ icon: "mdi:cog", form: "rounded", label: "Convert Video to Base64", pos: "b", h: 48 }
        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/>Extract Key Insights with Du.."]
        n4@{ icon: "mdi:robot", form: "rounded", label: "Generate Facebook Post & Ima..", pos: "b", h: 48 }
        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/httprequest.dark.svg' width='40' height='40' /></div><br/>Generate AI Image with Dumpl.."]
        n6@{ icon: "mdi:database", form: "rounded", label: "Save Post and Image URL to G..", pos: "b", h: 48 }
        n1 --> n2
        n2 --> n3
        n0 --> n1
        n5 --> n6
        n3 --> n4
        n4 --> n5
    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 n4 ai
    class n6 database
    class n3,n5 api
    classDef customIcon fill:none,stroke:none
    class n3,n5 customIcon

Why This Matters: Turning videos into posts is a bottleneck

Most teams don’t struggle to create videos. The bottleneck is everything after upload: re-watching to find the key steps, translating technical language into something a Facebook audience will read, and coming up with a visual that doesn’t look like the same stock-photo template again. It’s not hard work, but it’s draining. And because it’s draining, it gets delayed, which means your best content sits unused while you scramble for something “good enough” to post.

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

One new tutorial video can trigger 30+ minutes of writing, revising, and formatting before it’s even shareable.
The “image idea” step sounds quick, but it becomes a second creative project if nobody writes the prompt clearly.
When drafts live in DMs and docs, approvals get lost and posts quietly never ship.
Consistency suffers because each post is written from scratch, often by whoever has time that day.

What You’ll Build: Google Drive → Facebook drafts logged in Sheets

This automation starts the moment a new video lands in a specific Google Drive folder. n8n grabs the file, converts it into a format an AI service can analyze, then sends it to Dumpling AI to pull out structured insights (topic, tools mentioned, and the key steps). Those insights get handed to GPT-4o, which writes a short, friendly Facebook post draft and also generates a clean image prompt that matches the post. Finally, Dumpling AI creates the visual and n8n logs the draft plus the image URL into a Google Sheet so you can review, approve, and publish without hunting through threads or folders.

The workflow begins with a Google Drive upload trigger. Then AI extracts meaning from the video and turns it into a post and a visual concept. The output lands in Google Sheets as a tidy “ready for review” queue.

What You’re Building

What Gets Automated

What You’ll Achieve

Detecting new video uploads in a chosen Google Drive folder.
Downloading the video and converting it to base64 for analysis.
Extracting structured insights from the video with Dumpling AI.
Generating a Facebook post draft and an image prompt with GPT-4o, then creating the image via Dumpling AI.

Turn each upload into a draft in about a few minutes of “hands-on” work.
Keep a single review queue in Google Sheets instead of scattered docs and messages.
Ship more consistently because the draft exists even when the team is busy.
Get more reusable value from your tutorial library without re-watching everything.
Standardize voice and structure, so posts feel like they came from one brand.

Expected Results

Say you upload 5 technical videos a week. Manually, if each one takes about 45 minutes to re-watch, pull the key points, write a Facebook post, and come up with an image direction, that’s roughly 4 hours weekly. With this workflow, your “work” is just uploading to Drive (already happening) and scanning a Google Sheet for approvals, maybe 5 minutes per video. The AI processing runs in the background, so you’re getting about 3 hours back most weeks.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Drive to store incoming tutorial videos.
Google Sheets to review drafts and image URLs.
Dumpling AI API key (get it from your Dumpling AI dashboard).
OpenAI API key (get it from the OpenAI API keys page).

Skill level: Beginner. You’ll connect accounts, paste a folder ID and sheet ID, and run a couple of test uploads.

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

Step by Step

A new video hits your Google Drive folder. The workflow listens to a specific folder, so only the videos you intend for repurposing trigger the automation.

The video gets retrieved and prepared for analysis. n8n downloads the file from Google Drive and converts it to base64. That sounds technical, but the point is simple: the file becomes “sendable” to the AI service reliably.

AI pulls the story out of the video. Dumpling AI analyzes what was covered and returns structured insights like the topic, tools mentioned, and the important steps. Then GPT-4o turns those insights into a short Facebook post draft plus a matching image prompt that fits the same message.

Everything lands in Google Sheets for review. Dumpling AI generates the visual from the prompt, and n8n writes a new row to your sheet with the post text and the image URL. That sheet becomes your lightweight approval queue.

You can easily modify the post style to match your voice (or swap Facebook for another channel) based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Google Drive Trigger

Set up Video Upload Watcher to detect new video files in a specific Google Drive folder.

Add the Video Upload Watcher node and set Event to fileCreated.
Set Trigger On to specificFolder and choose the target folder in folderToWatch.
Credential Required: Connect your googleDriveOAuth2Api credentials.

⚠️ Common Pitfall: The folder picker can show a cached name even if the ID is empty. Make sure a valid folder is selected, not just the cached label.

Step 2: Connect Google Drive for Video Retrieval

Download the newly uploaded file using Retrieve Video Asset and pass it to encoding.

Add Retrieve Video Asset and set Operation to download.
Set File ID to ={{ $json.id }} to use the ID from Video Upload Watcher.
Credential Required: Connect your googleDriveOAuth2Api credentials.
Connect Video Upload Watcher → Retrieve Video Asset.

Step 3: Set Up Video Encoding and Key Insight Extraction

Convert the video to Base64 and send it to Dumpling for insights via Pull Key Insights via Dumpling.

Add Encode Video to Base64 with Operation set to binaryToPropery.
Add Pull Key Insights via Dumpling and set URL to https://app.dumplingai.com/api/v1/extract-video.
Set Method to POST and Specify Body to json.
Set JSON Body to the full expression:
={ "inputMethod": "base64", "video": "{{ $json.data }}", "prompt": "You are an AI assistant that extracts key insights from a video transcript related to automation or technical tutorials. From the content, identify and return the following details clearly: 1. Topic of the video, 2. Main tools or platforms mentioned (e.g. N8N, 11Labs), 3. Purpose of the tutorial, 4. Key steps shared or demonstrated, 5. Important modules or actions discussed, 6. Any use case or real-world application mentioned, 7. Specific tips, issues, or recommendations shared by the creator. Focus only on the core lesson, and ignore filler intro or closing remarks unless they contain critical information. Respond only with the extracted data, do not repeat the transcript. Return your result in clean and structured JSON.", "jsonMode": true }
Credential Required: Connect your httpHeaderAuth credentials.
Connect Retrieve Video Asset → Encode Video to Base64 → Pull Key Insights via Dumpling.

Tip: Ensure the incoming data includes a data field after encoding; if not, double-check the binary property name in Encode Video to Base64.

Step 4: Set Up AI Content and Visual Generation

Use Craft FB Post and Image Idea to create post copy and an image prompt, then generate a visual with Create AI Visual via Dumpling.

Add Craft FB Post and Image Idea and set Model to chatgpt-4o-latest.
In the user message content, include the expression =Here is the extracted content:{{ $('Pull Key Insights via Dumpling').item.json.results }}.
Enable JSON Output by setting true.
Credential Required: Connect your openAiApi credentials.
Add Create AI Visual via Dumpling with URL https://app.dumplingai.com/api/v1/generate-ai-image and Method POST.
Set JSON Body to ={ "model": "recraft-v3", "input": { "prompt": "{{ $json.message.content.image_prompt}}", "style": "any" }}.
Credential Required: Connect your httpHeaderAuth credentials.
Connect Pull Key Insights via Dumpling → Craft FB Post and Image Idea → Create AI Visual via Dumpling.

Tip: Flowpast Branding is a sticky note for documentation and does not affect execution; keep it for reference.

Step 5: Configure Output Logging to Google Sheets

Log the generated Facebook post and image URL using Log Post and Image to Sheet.

Add Log Post and Image to Sheet and set Operation to append.
Select the spreadsheet in Document ID and set Sheet Name to gid=0 (e.g., Sheet1).
Map Post to ={{ $('Craft FB Post and Image Idea').item.json.message.content.facebook_post }}.
Map Image URL to ={{ $json.images[0].url }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials.
Connect Create AI Visual via Dumpling → Log Post and Image to Sheet.

Step 6: Test and Activate Your Workflow

Validate the end-to-end flow and then enable the workflow for ongoing use.

Click Execute Workflow and upload a test video to the watched Google Drive folder.
Verify that Pull Key Insights via Dumpling returns structured JSON and that Craft FB Post and Image Idea outputs a JSON object with facebook_post and image_prompt.
Confirm Create AI Visual via Dumpling returns an image URL and Log Post and Image to Sheet appends a new row.
When successful, toggle the workflow to Active to run automatically on new uploads.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

Google Drive credentials can expire or be missing file permissions. If the workflow can’t download the video, check the connected Google account in n8n credentials and confirm it can access that folder.
If you’re using Wait-like delays elsewhere or the video is large, processing times vary. Bump up timeouts in your HTTP Request nodes if Dumpling AI occasionally returns late and downstream nodes get empty data.
Default prompts in AI nodes are generic. Add your brand voice (tone, phrases to avoid, length rules) inside the GPT-4o prompt early or you’ll be editing outputs forever.

Quick Answers

What’s the setup time for this Drive post drafts automation?

About 30 minutes if your accounts and keys are ready.

Is coding required for this Drive post drafts automation?

No. You’ll connect credentials, choose a Drive folder, and point the workflow at your Google Sheet.

Is n8n free to use for this Drive post drafts 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 OpenAI API costs and Dumpling AI usage, which depend on how many videos you process.

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 Drive post drafts workflow for different use cases?

Yes, and it’s honestly one of the best parts. You can swap the “Craft FB Post and Image Idea” OpenAI node prompt to write for LinkedIn, Instagram, or an email newsletter instead. Many teams also change the Google Sheets mapping to add columns like “Owner,” “Status,” or “Publish date,” so approvals don’t live in someone’s head. If you prefer another image generator, replace the “Create AI Visual via Dumpling” HTTP Request node with a different image API and keep the same output pattern (return an image URL, write it to the sheet).

Why is my Google Drive connection failing in this workflow?

Usually it’s permissions. Make sure the connected Google account can actually access the target folder, and double-check that the folder ID in the trigger matches the folder you’re uploading into. If it worked once and then stopped, re-authorize the Google Drive credential in n8n because tokens can expire. Also confirm the workflow is listening to the right Drive (personal vs. shared drive) because that mismatch is a sneaky one.

What volume can this Drive post drafts workflow process?

It depends mostly on your n8n plan and how long each video takes to analyze, but most small teams run dozens of videos per week comfortably.

Is this Drive post drafts automation better than using Zapier or Make?

For this particular workflow, n8n is usually the better fit because you’re handling files, multi-step AI calls, and mapping structured outputs into a sheet. Zapier and Make can do it, but larger files and branching logic tend to get expensive or brittle. n8n also gives you the option to self-host, which matters when you’re processing lots of content. If you want tight control over prompts and data shaping, n8n feels less “boxed in.” Talk to an automation expert if you want help deciding.

Once this is live, new uploads stop being “someday content.” They become drafts you can approve in minutes, and your Google Sheet turns into a simple publishing pipeline.

Google Drive to Google Sheets, Facebook drafts ready

How This Automation Works

n8n Workflow Template: Google Drive to Google Sheets, Facebook drafts ready

Why This Matters: Turning videos into posts is a bottleneck