
Save yourself the work of writing custom integrations for Google Drive and HTTP Request and use n8n instead. Build adaptable and scalable Data & Storage, Development, and Core Nodes workflows that work with your technology stack. All within a building experience you will love.
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
You can find Google Drive and HTTP Request in the nodes panel. Drag them onto your workflow canvas, selecting their actions. Click each node, choose a credential, and authenticate to grant n8n access. Configure Google Drive and HTTP Request nodes one by one: input data on the left, parameters in the middle, and output data on the right.
A connection establishes a link between Google Drive and HTTP Request (or vice versa) to route data through the workflow. Data flows from the output of one node to the input of another. You can have single or multiple connections for each node.
Use n8n's core nodes such as If, Split Out, Merge, and others to transform and manipulate data. Write custom JavaScript or Python in the Code node and run it as a step in your workflow. Connect Google Drive and HTTP Request with any of n8n’s 1000+ integrations, and incorporate advanced AI logic into your workflows.
Save and run the workflow to see if everything works as expected. Based on your configuration, data should flow from Google Drive to HTTP Request or vice versa. Easily debug your workflow: you can check past executions to isolate and fix the mistake. Once you've tested everything, make sure to save your workflow and activate it.
Description
This comprehensive n8n automation template orchestrates a complete end-to-end workflow for generating engaging short-form Point-of-View (POV) style videos using multiple AI services and automatically publishing them across major social media platforms. It takes ideas from a Google Sheet and transforms them into finished videos with captions, voiceovers, and platform-specific descriptions, ready for distribution.
Who Is This For?
Content Creators & Agencies:** Mass-produce unique short-form video content for various clients or channels with minimal manual effort.
Digital Marketers:** Automate video content pipelines to boost online presence and engagement across multiple platforms simultaneously.
Social Media Managers:** Schedule and distribute consistent video content efficiently without juggling multiple tools and manual uploads.
Businesses:** Leverage AI to create branded video content for marketing, reducing production time and costs.
What Problem Does This Workflow Solve?
Creating and distributing high-quality short-form video content consistently across multiple social networks is incredibly time-consuming and resource-intensive. This workflow tackles these challenges by:
Automating Idea-to-Video Pipeline:** Generates video concepts, image prompts, scripts, images, video clips, and voiceovers using AI.
Streamlining Video Assembly:** Automatically combines generated assets into a final video using a template.
Generating Platform-Optimized Descriptions:** Creates relevant descriptions for posts by transcribing the final video audio.
Automating Multi-Platform Publishing:** Uploads the final video and description to TikTok, Instagram, YouTube, Facebook, and LinkedIn simultaneously.
Reducing Manual Workload:** Drastically cuts down the time and effort required for video production and distribution.
Centralized Tracking:** Updates a Google Sheet with results, costs, and status for easy monitoring.
How It Works
Trigger & Input: Runs on a daily schedule (configurable) and fetches new video ideas from a designated Google Sheet.
AI Content Generation:
Uses OpenAI to generate video captions and image prompts based on the idea.
Uses PiAPI (Flux) to generate images from prompts.
Uses PiAPI (Kling) to generate video clips from the images (Image-to-Video).
Uses OpenAI to generate a voiceover script based on the captions.
Uses ElevenLabs to generate voiceover audio from the script and uploads it to Google Drive.
Video Assembly: Combines the generated video clips, captions, and voiceover audio using a Creatomate template to render the final video.
Description Generation: Uploads the final video to Google Drive, extracts the audio using OpenAI (Whisper), and generates a social media description using OpenAI (GPT).
Multi-Platform Distribution: Uses upload-post.com to upload the final video and generated description to TikTok, Instagram, YouTube, Facebook, and LinkedIn.
Tracking & Notification: Updates the original Google Sheet row with output details (video link, costs, tokens used) and sends a completion notification via Discord.
Setup
Accounts & API Keys: Obtain accounts and generate API keys/credentials for:
n8n
Google Cloud Platform (for Google Sheets & Google Drive APIs + OAuth Credentials)
OpenAI
PiAPI
ElevenLabs
Creatomate
upload-post.com
Discord (Webhook URL)
Google Sheet: Make a copy of the provided Google Sheet Template and connect it in the Load Google Sheet node.
Creatomate Template: Set up a video template in Creatomate (use the provided JSON source code as a base) and note its Template ID.
Configure Nodes:
Enter all API Keys/Credentials in the Set API Keys node and other relevant credential sections (Google nodes, upload-post nodes, etc.).
Configure Google Drive nodes (Folder IDs, Permissions).
Configure the upload-post.com nodes with your user identifier and necessary platform details (e.g., Facebook Page ID).
Customize AI prompts within the OpenAI nodes (Generate Video Captions, Generate Image Prompts, Generate Script, Generate Description...) if desired.
Set the Discord Webhook URL in the Notify me on Discord node.
Enable Google APIs: Ensure Google Drive API and Google Sheets API are enabled in your Google Cloud Project.
Requirements
Accounts:** n8n, Google (Sheets, Drive, Cloud Platform), OpenAI, PiAPI, ElevenLabs, Creatomate, The social media api Upload-Post, Discord.
API Keys & Credentials:** API Keys for OpenAI, PiAPI, ElevenLabs, Creatomate, upload-post.com. Google Cloud OAuth 2.0 Credentials. Discord Webhook URL.
Templates:** A configured Google Sheet based on the template, a configured Creatomate video template.
(Potentially) Paid Plans:** Some services (OpenAI, PiAPI, Creatomate, upload-post.com) may require paid plans depending on usage volume after free trials/credits are exhausted.
Use this template to build a powerful, automated video content factory, scaling your production and distribution efforts across the social media landscape.
Nodes used in this workflow
Create custom Google Drive and HTTP Request workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Reduce time spent on customer integrations, engineer faster POCs, keep your customer-specific functionality separate from product all without having to code.
Learn moreYes, Google Drive can connect with HTTP Request using n8n.io. With n8n, you can create workflows that automate tasks and transfer data between Google Drive and HTTP Request. Configure nodes for Google Drive and HTTP Request in the n8n interface, specifying actions and triggers to set up their connection.
Yes, with n8n, you can programmatically interact with Google Drive’s API via pre-defined supported actions or raw HTTP requests. With the HTTP Request node, you create a REST API call. You need to understand basic API terminology and concepts.
Yes, with n8n, you can programmatically interact with HTTP Request’s API via pre-defined supported actions or raw HTTP requests. With the HTTP Request node, you create a REST API call. You need to understand basic API terminology and concepts.
Yes, it is safe to use n8n to integrate Google Drive and HTTP Request. n8n offers various features to ensure the safe handling of your data. These include encrypted data transfers, secure credential storage, RBAC functionality, and compliance with industry-standard security practices (SOC2 compliant). For hosted plans, data is stored within the EU on servers located in Frankfurt, Germany. You can also host it on your own infrastructure for added control.
Learn more about n8n’s security practices here.
To start integrating Google Drive and HTTP Request in n8n, you have different options depending on how you intend to use it:
Unlike other platforms that charge per operation, step, or task, n8n charges only for full workflow executions. This approach guarantees predictable costs and scalability, no matter the complexity or volume of your workflows.





Looking to integrate Google Drive and HTTP Request in your company?
Build complex workflows, really fast
Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.
Your data is displayed alongside your settings, making edge cases easy to track down.
Use 1000+ workflow templates available from our core team and our community.
Copy and paste, easily import and export workflows.
Report a vulnerability
© 2024 n8n | All rights reserved.

