Articles
▸ 5 articles
Automating Invoice Data Extraction with OCR, AI, and Google Sheets
This article explains how an n8n workflow automates invoice processing by finding documents in Google Drive, extracting text with OCR, using AI to convert the data into structured fields, and appending the results to Google Sheets.
- ocr
- invoice automation
- document processing
- n8n
- google drive
- google sheets
- ai data extraction
- japanese invoices
Building a Unified Scraper for Open Educational Content
This article walks through the architecture and design decisions behind a Python-based scraping engine that unifies access to multiple open learning platforms, covering the interface abstractions, parallel fetching with proxy rotation, and practical patterns for consistent data collection across heterogeneous sources. Every open learning platform structures content differently. One exposes a JSON API, another requires navigating paginated HTML, and a third needs authentication before any document becomes reachable. Building a separate scraper per platform creates a maintenance burden and produces output that is hard to combine.
- python
- web scraping
- proxy rotation
- open educational resources
- parallel fetching
- api integration
Designing a Rule-Based and AI Email Prioritization System for Gmail
The average professional receives over a hundred emails daily, yet only a fraction demand immediate attention. Raw inboxes force a manual triage loop that costs focus and time. The Mail Prioritizer addresses this by building a two-tier classification pipeline that separates urgent messages from those that can wait, without requiring users to change their existing Gmail workflow.
- gmail api
- oauth 2.0
- email classification
- rule-based system
- ai classification
- batch processing
Building an AI Avatar Video Pipeline with HeyGen and ElevenLabs
This article walks through a Node.js REST API that turns a static character image into a realistic AI avatar video using HeyGen, generates custom speech with ElevenLabs, and automatically publishes the resulting video as an Instagram Reel. The key idea is to combine avatar generation, voice synthesis, media processing, and social media publishing into a single API-driven pipeline.
- node.js
- express
- ai video generation
- heygen
- elevenlabs
- text-to-speech
- voice cloning
- instagram api
- ffmpeg
Building a RAG AI Assistant with n8n, Google Drive, and Supabase
A practical look at building an AI assistant that turns documents stored in Google Drive into a searchable knowledge base using n8n, embeddings, Supabase, and an LLM.
- n8n
- RAG
- AI agents
- Supabase
- vector search
- embeddings
- GitHub