The Problem Was Simple
Every week, 50 to 100 PDF shipping label files arrive. Each contains scattered information like customer names, quantities, delivery addresses, and special notes. Reading through each file and manually typing the data into Google Sheets consumed about 1 hour daily.
Finger pain, eye fatigue, and occasional data entry mistakes.
Before: The Manual Loop
Open PDF file → Read content → Transfer to spreadsheet → Repeat next file
This cycle repeated multiple times each day.
The Small Experiment Begins
One day I asked Claude Code.
"Can we automatically extract text from PDFs and turn it into structured data?"
Claude offered a surprisingly simple approach.
import PyPDF2
import json
with open('shipping_label.pdf', 'rb') as f:
reader = PyPDF2.PdfReader(f)
text = reader.pages[0].extract_text()
print(text)
Three lines were enough.
After: The Automation Moment
Now a simple monitoring script runs on the Windows device. Whenever a new PDF enters the folder, it's automatically processed.
• PDF enters the monitored folder
• Claude Code automatically extracts text
• Structured data instantly populates Google Sheets
• Original PDF moves to a "Completed" folder
One hour of work reduced to 5 minutes.
The Unexpected Discovery
The most surprising result was that data entry errors dropped to nearly zero. Less human touch meant higher accuracy.
We also realized the same approach could automate invoices, customs documents, and other file types.
Non-Developers Can Do This Too
The code isn't complex. Claude explains everything. Installing Python is straightforward. Nothing more is needed.
Our Dream Team Hamsters build these small automations one by one. Every journey starts with a simple question: "Why do I keep doing this manually?"