All projects

Developer Tools

Story Checker

Chrome side panel extension for efficiently checking Instagram/Facebook influencer stories from a Google Sheet list — keyboard-first marketing workflow tool.

Role

Solo developer

Team

Solo

Duration

2025

Year

2025

Chrome Extension Google Sheets API Google OAuth Side Panel
Chrome Extension Marketing Tools Workflow
Story Checker hero

What & Why

Marketing agencies monitoring dozens of influencers manually open profiles one by one, toggle between spreadsheets to log results, and lose their place in the list constantly. Story Checker streamlines this into a keyboard-driven side panel workflow: load your Google Sheet, tab through profiles, press Y or N, done. Results log back to the sheet automatically.

Built for marketing agency workflows where speed and accuracy of influencer story verification matters.

Key Features

  • Side panel UI — opens alongside the active tab, no context switching
  • Google Sheets integration — reads profile list (Name, Instagram URL, Facebook URL) from source sheet; logs YES results to a separate log sheet
  • Keyboard shortcutsY/N to mark, B to go back, ↑↓/J/K to navigate, R to reload
  • Search mode — filter to YES-only profiles, click to jump to that row in the open Google Sheet
  • Progress tracking — visual progress bar with session statistics
  • Session persistence — resume exactly where you left off after closing the browser

Tech & Implementation

Stack: Chrome Extension (Side Panel API) · Google OAuth · Google Sheets API · JavaScript · Chrome Storage API

Notable decision: Using Chrome's Side Panel API (rather than a popup) means the extension stays visible while navigating between Instagram and Facebook profiles — critical for a workflow that requires constant cross-referencing. Google OAuth was scoped minimally (sheets read + append only) and explicitly documented in the privacy policy.

Outcome

A functional, production-ready tool for a specific marketing agency workflow. Demonstrated ability to design keyboard-first, efficiency-focused UX for repetitive professional tasks. The session persistence pattern (saving position in localStorage) reflects real-world considerations for tools used in multi-hour work sessions.