Bulk JSON file downloader from Google Sheet to local folders

Description:

Easily extract, download, and organize multiple JSON files from Google Drive using this no-code automation template for n8n. Ideal for operations, analysts, or data engineers managing bulk document processing, this workflow reads a Google Sheet containing file names and Google Drive URLs, converts those links into downloadable JSONs, and automatically writes each file to a local disk folder—sorted by name.

No more manual downloading or copy-pasting. Everything is processed in a structured loop, ensuring reliable and scalable folder-based separation of your JSON data files.

What This Template Does (Step-by-Step)

🟢 Trigger: Manual Execution: Initiates the flow when you click “Execute Workflow” in n8n.

📄 Google Sheet Reader: Connects to your Google Sheet to fetch rows with columns like Name and Google Drive URL.

🧹 Clean & Filter Data (Python Code Node): Filters out rows missing name or URL. Keeps only valid entries to prevent failure in downstream steps.

🔗 Convert Drive URL to Download Link (JavaScript Code): Extracts the Google Drive File ID and transforms it into a direct download link for each JSON file.