PipeMailSheet
A lightweight Go service that automatically connects your Gmail inbox to a Google Sheet for real-time job application tracking.
A lightweight Go service that automatically connects your Gmail inbox to a Google Sheet for real-time job application tracking.
PipeMailSheet listens for incoming emails via Google Pub/Sub push notifications, matches them to your existing job applications in a Google Sheet, and updates the status, color coding, and metadata — all automatically and in real time.
Receives Gmail push notifications via Pub/Sub. No polling, no delays — updates happen within seconds of a new email.
Matches emails to applications using company name, job title, location, contact person, and sender domain with weighted scoring.
Interprets free-text German status entries (e.g. “Absage”, “Einladung”) and normalizes them into actionable states with date extraction.
Automatically applies row background colors: green for positive, red for rejection, orange for rejection after a prior positive step.
Built with Go and deployed on Google Cloud Run. Uses OAuth 2.0 for secure access to Gmail (read-only) and Google Sheets. All state is stored in the user’s own Google Sheet — no external database required.