Download Facebook videos to Google Drive with automated logging in sheets
π Facebook to MP4 Video Downloader β Fully Customizable Automated Workflow
Easily convert Facebook videos into downloadable MP4 files using Facebook Video Downloader API.
This n8n workflow automates fetching videos, downloading them, uploading them to Google Drive, and logging results in Google Sheets.
Users can modify and extend this flow according to their own needs (e.g., add email notifications, change storage location, or use another API).
π Node-by-Node Explanation
- On form submission β Triggers when a user submits a Facebook video URL via the form. (You can customize this form to include email or multiple URLs.)
- Facebook RapidAPI Request β Sends a POST request to Facebook Video Downloader API to fetch downloadable MP4 links. (Easily replace or update API parameters as needed.)
- If Node β Checks API response for errors before proceeding. (You can add more conditions to handle custom error scenarios.)
- MP4 Downloader β Downloads the Facebook video file from the received media URL. (You can change download settings, add quality filters, or store multiple resolutions.)
- Upload to Google Drive β Uploads the downloaded MP4 file to a Google Drive folder. (Easily switch to Dropbox, S3, or any other storage service.)
- Google Drive Set Permission β Sets the uploaded file to be publicly shareable. (You can make it private or share only with specific users.)
- Google Sheets β Logs successful conversions with the original URL and shareable MP4 link. (Customizable for additional fields like video title, size, or download time.)
- Wait Node β Delays before logging failed conversions to avoid rapid writes. (You can adjust the wait duration or add retry attempts.)
- Google Sheets Append Row β Records failed conversion attempts with
N/Aas the Drive URL. (You can add notification alerts for failed downloads.)
β Use Cases
- Automate Facebook video downloads for social media teams
- Instantly generate shareable MP4 links for clients or marketing campaigns
- Maintain a centralized log of downloaded videos for reporting
- Customizable flow for different video quality, formats, or storage needs
π Benefits
- Fast and reliable Facebook video downloading with Facebook Video Downloader API
- Flexible and fully customizable β adapt nodes, storage, and notifications as required
- Automatic error handling and logging in Google Sheets
- Cloud-based storage with secure and shareable Google Drive links
- Seamless integration with n8n and Facebook Video Downloader API for scalable automation
π Resolved: Manual Facebook video downloads are now fully automated, customizable, and scalable using Facebook Video Downloader API, Google Drive uploads, and detailed logging via Google Sheets.
Download Facebook Videos to Google Drive with Automated Logging in Sheets
This n8n workflow automates the process of downloading Facebook videos to Google Drive and logs the activity in a Google Sheet. It's designed to provide a simple form-based interface for users to submit Facebook video URLs, which are then processed, downloaded, and stored, with a record kept for tracking.
What it does
- Triggers on Form Submission: The workflow starts when a user submits a form containing a Facebook video URL.
- Logs Request to Google Sheets: Immediately logs the received Facebook video URL into a specified Google Sheet, marking it as "Pending".
- Initiates Video Download: Sends an HTTP request to a video download service (e.g., SaveFrom.net, FDown.net, or a similar API) to retrieve the video.
- Checks for Successful Download: Evaluates the response from the download service.
- If successful:
- Downloads the video file.
- Uploads the downloaded video to a designated folder in Google Drive.
- Updates the corresponding row in the Google Sheet to "Success" and includes the Google Drive file URL.
- If unsuccessful:
- Updates the corresponding row in the Google Sheet to "Failed" and logs any error messages.
- If successful:
- Waits (Optional): Includes a
Waitnode, potentially for rate limiting or to allow the download service to process the request before checking status. (Note: The provided JSON doesn't specify a wait duration, so it might be a placeholder or configured for a very short delay.)
Prerequisites/Requirements
- n8n Instance: A running n8n instance.
- Google Account: A Google account with access to Google Sheets and Google Drive.
- Google Sheets Credential: An n8n credential configured for Google Sheets.
- Google Drive Credential: An n8n credential configured for Google Drive.
- Facebook Video Download Service/API: Access to a service or API that can download Facebook videos given a URL. (The
HTTP Requestnode will need to be configured with the specific endpoint and parameters for your chosen service). - Google Sheet: A Google Sheet set up with columns to log video URLs, status, and potentially Google Drive links.
Setup/Usage
- Import the Workflow: Import the provided JSON into your n8n instance.
- Configure Credentials:
- Update the "Google Sheets" node with your Google Sheets credential.
- Update the "Google Drive" node with your Google Drive credential.
- Configure Google Sheets Node:
- Specify the Spreadsheet ID and Sheet Name where the logs will be stored.
- Ensure the columns for logging (e.g.,
Video URL,Status,Drive Link) match your sheet's headers.
- Configure HTTP Request Node:
- Update the URL and Method to point to your chosen Facebook video download service/API.
- Configure any necessary Headers or Query Parameters (e.g., API keys, the Facebook video URL).
- Configure Google Drive Node:
- Specify the Folder ID in Google Drive where the downloaded videos should be uploaded.
- Activate the Workflow: Once configured, activate the workflow.
- Use the Form Trigger: Access the URL provided by the "On form submission" trigger node. Submit Facebook video URLs through this form to initiate the workflow.
Related Templates
AI-powered code review with linting, red-marked corrections in Google Sheets & Slack
Advanced Code Review Automation (AI + Lint + Slack) Whoβs it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting β all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0β10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your teamβs channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow β reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why itβs valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n β combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your teamβs review history transparent and centralized.
Daily cash flow reports with Google Sheets, Slack & Email for finance teams
Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. πΈπ§ Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows β Get in touch with us
Generate Weather-Based Date Itineraries with Google Places, OpenRouter AI, and Slack
π§© What this template does This workflow builds a 120-minute local date course around your starting point by querying Google Places for nearby spots, selecting the top candidates, fetching real-time weather data, letting an AI generate a matching emoji, and drafting a friendly itinerary summary with an LLM in both English and Japanese. It then posts the full bilingual plan with a walking route link and weather emoji to Slack. π₯ Who itβs for Makers and teams who want a plug-and-play bilingual local itinerary generator with weather awareness β no custom code required. βοΈ How it works Trigger β Manual (or schedule/webhook). Discovery β Google Places nearby search within a configurable radius. Selection β Rank by rating and pick the top 3. Weather β Fetch current weather (via OpenWeatherMap). Emoji β Use an AI model to match the weather with an emoji π€οΈ. Planning β An LLM writes the itinerary in Markdown (JP + EN). Route β Compose a Google Maps walking route URL. Share β Post the bilingual itinerary, route link, and weather emoji to Slack. π§° Requirements n8n (Cloud or self-hosted) Google Maps Platform (Places API) OpenWeatherMap API key Slack Bot (chat:write) LLM provider (e.g., OpenRouter or DeepL for translation) π Setup (quick) Open Set β Fields: Config and fill in coords/radius/time limit. Connect Credentials for Google, OpenWeatherMap, Slack, and your LLM. Test the workflow and confirm the bilingual plan + weather emoji appear in Slack. π Customize Adjust ranking filters (type, min rating). Modify translation settings (target language or tone). Change output layout (side-by-side vs separated). Tune emoji logic or travel mode. Add error handling, retries, or logging for production use.