# AI-powered JSON processing from Google Drive to Google Sheets on demand
This automation template solves the problem of extracting and structuring data from multiple JSON files stored in Google Drive. The workflow uses an AI agent powered by Azure OpenAI to analyze content and automatically save structured results to Google Sheets — eliminating manual copying and parsing. Ideal for professionals regularly working with raw JSON data.
## Who it´s for
- Analysts handling numerous JSON files from cloud storage
- Developers needing to automate parsing and logging tasks
- Project managers compiling structured reports from raw JSON inputs
## What the automation does
- Triggered manually via n8n
- Searches and downloads JSON files from a specified Google Drive folder
- Extracts and processes data using LangChain and Azure OpenAI
- Transforms unstructured content into structured fields (e.g., key events, metrics)
- Appends or updates rows in Google Sheets
- Supports batch processing of multiple files in a single run
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on manual execution
- Integrations with Google Drive API, Google Sheets API, and Azure OpenAI
- Basic textual guide for setup and adaptation
## Requirements for setup
- n8n account with workflow execution capability
- Google account with read access to Google Drive files and write access to Google Sheets
- Access to Azure OpenAI with configured endpoint and API key
- Credentials to connect all services within n8n
## Benefits and outcomes
- Saves time on manual JSON file processing
- Reduces human error during data transfer
- Quickly converts technical dumps into readable summaries
- Centralized storage of analysis results in Google Sheets
- Scalable through batch processing
- Repeatable process with no human intervention after setup
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet