Recently, I built an automation for a marketing agency that needed to centralize digital content — videos, images, audio, and text — from various online sources.
The idea was simple: give the team an easy way to save everything without having to manually download files, copy and paste transcriptions, or organize folders in Google Drive. That’s where n8n, Supabase, and Google Drive came in — along with some magic from RapidAPI.
Starting Point: A Simple Form
Everything starts with a form, where the user enters a URL and selects the type of content they want to capture:
- Website screenshot
- YouTube video with transcription
- Instagram Reels with transcription
This form triggers the n8n workflow.
Collecting Content Using RapidAPI
To handle web scraping, I used APIs available on RapidAPI — a platform that offers access to various public APIs. Based on the submitted URL, n8n identifies the content type and calls the right API to fetch it:
- Website screenshots: Captured via a screen capture API.
- YouTube videos: Downloaded using a YouTube API, followed by transcription via a speech-to-text API.
- Instagram Reels: Similar to YouTube, but with adjustments for social media handling.
All files were automatically sent to Google Drive, organized by date and type.
Storing Metadata in Supabase
While the actual media files go to Drive, all the metadata (original link, content type, filename, transcription, etc.) is stored in Supabase, which I used as a real-time backend.
Alternative Collection via Virtual Number (API Evolution)
Besides the form, I also created a parallel content intake system through a virtual number.
Using the API Evolution, I was able to capture incoming messages with text, images, videos, or audio. The workflow then saves these files to Google Drive and logs the metadata in Supabase — just like with the form.
The Result: A Fully Automated Content Collection Pipeline
Now, the agency team can simply send a link or media file, and within seconds, it’s saved, transcribed, and neatly organized.
This automation drastically cut down on manual tasks and brought more consistency and traceability to their process.