What This Workflow Does
This n8n workflow automates the process of retrieving video data from Google Sheets and filtering content based on publication status. It runs on a scheduled interval to identify videos marked as “pending” and processes them one at a time to prevent exceeding API rate limits. The workflow integrates with Google Sheets, Google Drive, and the Blotato node to manage video content efficiently.
How It Works
The workflow operates through a series of coordinated steps that ensure reliable data retrieval and processing:
- Schedule Trigger: Activates automatically every hour to maintain consistent data synchronization
- Google Sheets Node: Connects to your spreadsheet and retrieves all video data records
- If Node: Evaluates each record and filters for entries with a “pending” status only
- Limit Node: Restricts processing to one video per execution cycle to avoid overwhelming external APIs
- Set Node: Prepares and structures data for downstream processing
- Blotato Node: Handles specialized processing of video metadata or content transformation
- Google Drive Node: Manages file storage and organization of processed videos
- Sticky Note: Provides workflow documentation and reference notes for team members
Use Cases
- Video Content Management: Automatically process pending video uploads from a content calendar stored in Google Sheets, updating their status as they move through production stages
- Social Media Publishing Pipeline: Retrieve videos awaiting publication from a shared spreadsheet and organize them into Google Drive folders by date or platform destination
- Batch Video Processing: Transform and prepare video metadata for multiple platforms by processing one video per hour to maintain stable API connections
- Content Review Workflow: Filter videos marked as pending review, organize supporting files in Google Drive, and prepare them for team member approval
- Scheduled Content Distribution: Automatically queue pending videos for distribution to multiple channels while tracking status changes in your Google Sheet
Nodes Used
- Schedule Trigger: Time-based trigger that executes the workflow at regular hourly intervals
- Google Sheets: Reads and retrieves video data from a connected Google Sheet
- If Node: Conditional logic that evaluates status fields and filters for pending items
- Limit Node: Rate limiting control that processes exactly one record per workflow execution
- Set Node: Data transformation and variable assignment for downstream nodes
- Blotato Node: Custom processing node for specialized video data handling (community node)
- Google Drive: File management and storage integration for processed videos
- Sticky Note: Documentation node for adding notes and instructions within the workflow
Prerequisites
- Self-hosted n8n instance with community node support enabled
- Active Google Account with access to Google Sheets and Google Drive
- Blotato community node installed on your n8n instance
- A Google Sheet containing video data with a status column marked as “pending”
- Google OAuth credentials configured in your n8n environment
- Proper permissions set for both Google Sheets and Google Drive access
- Understanding of basic workflow structure and conditional logic
Difficulty Level
Intermediate. This workflow requires familiarity with n8n node configuration, Google API integration, and conditional filtering logic. Users should understand how to set up OAuth credentials, configure API connections, and modify filtering conditions based on their specific data structure. The workflow is more complex than basic automation but remains manageable for users with prior n8n experience.
This workflow template is shared under the n8n fair-code license. Free to use and modify.