I just built out a fun new automation for getting videos into ad accounts 🤓

Key Concepts

• Google Drive Watcher: A system for monitoring a specific Google Drive folder for new file additions.
• Marketing API (Facebook): Facebook’s Application Programming Interface used for programmatic ad creation and management.
• Downloadable URL: A temporary, accessible link to a file for download.
• Asset ID: A unique identifier assigned to a video file within the system.
• Air Table: A cloud-based relational database used for organizing and managing data.
• Dropbox Public Link: A publicly accessible link to a file stored in Dropbox.
• Thumbnail URL: The web address pointing to the video’s thumbnail image.
• Bulk Uploading: The process of uploading multiple ads simultaneously.

Automated Video Upload & Organization System

This system automates the process of uploading videos to a Facebook ad account and organizing associated metadata. The core functionality revolves around monitoring a designated Google Drive folder for new video files and then automatically processing and cataloging them for ad creation.

Workflow Breakdown: From Google Drive to Air Table

The process unfolds in a series of automated steps:

1. Google Drive Monitoring: The system continuously watches a specific folder within Google Drive. Upon detection of a new video file, the process is triggered. This utilizes a “Google Drive Watcher” – a component designed to detect file additions.
2. URL Generation: Once a new file is detected, a temporary, downloadable URL is generated for that video. This URL allows the system to access the video for subsequent processing.
3. Facebook Marketing API Integration: The downloadable URL is then posted to Facebook using the Facebook Marketing API. This isn’t directly uploading the video to Facebook Ads Manager, but rather initiating a process to retrieve information from the video.
4. Thumbnail Extraction: The system then parses the response from the Facebook Marketing API call. This parsing extracts the thumbnail URL associated with the video. This is achieved through another API call specifically designed to retrieve the thumbnail.
5. Dropbox Storage & Public Link: The extracted thumbnail URL is then uploaded to a designated folder within Dropbox. The system then generates a public link for the thumbnail image within Dropbox, making it accessible via a URL.
6. Air Table Database Population: Finally, both the original video file’s downloadable URL and the Dropbox public link for the thumbnail are uploaded to an Air Table database. Alongside these URLs, the system also records the video’s name, type, and a unique asset ID.

Data Organization in Air Table

The Air Table database serves as a central repository for all video assets and their associated metadata. The database structure includes the following fields:

• Name: The filename of the video.
• Type: The file type of the video (e.g., .mp4, .mov).
• Asset ID: A unique identifier assigned to each video within the system.
• Downloadable URL: The temporary URL for accessing the original video file.
• Thumbnail URL: The public URL for accessing the video’s thumbnail image in Dropbox.

Benefits & Applications

The primary benefit of this system is the automation of a previously manual and time-consuming process. The creator states that, “within seconds of dropping a video into a Google Drive folder, I now have it organized in Air Table with its name, type, asset ID, and thumbnail URL.” This allows for:

• Efficient Ad Creation: The organized data in Air Table can be readily used to create Facebook ads.
• Bulk Ad Uploading: The system facilitates the bulk uploading of ads to Facebook, significantly reducing the time required for campaign setup.
• Centralized Asset Management: Air Table provides a single source of truth for all video assets and their associated metadata.

Technical Considerations

The system relies on a combination of APIs (Google Drive, Facebook Marketing API, Dropbox) and a relational database (Air Table). The creator doesn’t detail the specific programming language or tools used to build the system, but it clearly requires scripting and API integration expertise. The use of temporary downloadable URLs suggests a focus on security and controlled access to the video files.

Conclusion

This automated system demonstrates a powerful application of API integration and data organization. By connecting Google Drive, Facebook, Dropbox, and Air Table, the creator has streamlined the video ad creation process, enabling efficient bulk uploading and centralized asset management. The system’s core strength lies in its ability to automatically extract and organize crucial metadata, saving significant time and effort in the long run.