Automated Content Creation: Google Drive to Social Media with Airtable Tracking

Name: Automated Content Creation: Google Drive to Social Media with Airtable Tracking
Rating: 5 (5 reviews)
Author: Free N8N

Beginner

10 nodes connected

detail.loadingPreview

Free N8N Temples

133 views

0 downloads

Content CreationAIAirtableGoogle DriveInstagramTikTokYouTubeautomationsocial mediavideo

Automatically transcribe audio from videos in Google Drive, generate social media descriptions using AI, and upload to TikTok, Instagram, and YouTube, with detailed tracking in Airtable.

About This Workflow

This workflow automates the entire process of content creation and distribution for video content. It starts by monitoring a Google Drive folder for new video uploads. Upon detecting a new video, it downloads the file, extracts audio for transcription, and uses AI (OpenAI) to generate engaging social media descriptions. Finally, it uploads the video to TikTok, Instagram, and YouTube via the upload-post.com API and logs all activity, including success/failure status and URLs, into an Airtable base for comprehensive tracking.

Key Features

Google Drive Integration: Triggers workflow on new file creation in a specified Google Drive folder.
AI-Powered Description Generation: Utilizes OpenAI's GPT-4o model to create tailored social media descriptions based on video audio.
Multi-Platform Upload: Simultaneously uploads videos to TikTok, Instagram, and YouTube using the upload-post.com API.
Airtable Tracking: Logs video details, upload status, and links to platforms in an Airtable base for management.
Error Handling & Notifications: Includes a basic error detection mechanism with Telegram notifications for critical failures.

How To Use

Configure Set Variables: Update airtable_app_id, airtable_table_id, and upload_post_user with your specific credentials.
Set up Airtable: Ensure your Airtable base has fields for 'Video Name', 'Google Drive Link', 'File ID', 'Instagram Status', 'TikTok Status', 'YouTube Status', 'Upload Date', and 'Description'.
Google Drive Folder: Configure the Google Drive Trigger node to watch your desired folder.
upload-post.com: Generate an API token on upload-post.com and add it to the Upload Video to TikTok, Upload Video to Instagram, and Upload Video to YouTube nodes under the httpHeaderAuth credentials.
OpenAI Credentials: Ensure your OpenAI API key is set up in the openAiApi credentials.
Airtable Credentials: Configure your Airtable API token in the airtableTokenApi credentials.
Error Notifications: Set up Telegram credentials if you wish to receive error alerts.
Activate Workflow: Enable the workflow to start processing new video uploads from Google Drive.

Apps Used

Airtable

Google Drive

Instagram

TikTok

YouTube

automation

social media

video

Workflow JSON

{
  "id": "ddbaee4f-eaa6-439e-bd4a-8b2cc7a449b6",
  "name": "Automated Content Creation: Google Drive to Social Media with Airtable Tracking",
  "nodes": 10,
  "category": "Content Creation",
  "status": "active",
  "version": "1.0.0"
}

Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.