Automated Content Creation: Google Drive to Social Media with Airtable Tracking
detail.loadingPreview
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, andupload_post_userwith 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 Triggernode 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, andUpload Video to YouTubenodes under thehttpHeaderAuthcredentials. - OpenAI Credentials: Ensure your OpenAI API key is set up in the
openAiApicredentials. - Airtable Credentials: Configure your Airtable API token in the
airtableTokenApicredentials. - 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
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.
Get This Workflow
ID: ddbaee4f-eaa6...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated News to Newsletter AI Agents
This workflow automates the process of news aggregation, summarization, and newsletter creation using AI agents.
PDF to Blog Post Generator
Automates the process of converting PDF documents into engaging blog posts, ready for publishing.
Automated Blog Post Generation with AI and WordPress Integration
Automate blog post creation from Google Sheets ideas, using AI for content and image generation, and publishing to WordPress.