Embedded Files
Tools: Github Kanban board, Notion, Google Forms, Google Sheets, ChatGPT, Supademo
My Role: Product Manager, UX Designer, Instructional Designer
Time: Ongoing
Client: Designed for researchers and knowledge workers collecting useful web resources
Design Brief: Design a solution to reduce the time researchers spend saving and organizing URLs for referencing
Process: Organize and manage the project using a Kanban board for task tracking, and Notion for API documentation.
Solution
I designed this Chrome extension to let users quickly save URLs into one of five categories: Article, Website, Video, Report, or Blog. Each URL is automatically saved in a connected Google Sheet via Google Forms. RefBucket can also generate APA, MLA, and IEEE citations, which users can copy directly from the sheet. A daily automation triggers on the Sheet every 24 hours to ensure accurate, up-to-date records.
Select the arrows ▼ to learn more about each stage of the project
Stage 1: URL Capture
Stage 1: URL Capture
Outline:
Core Functionality: Chrome extension captures URLs and submits them to a Google Form.
Automation: Google Form logs data in a Google Sheet, updated daily via script.
API Integration: Google Forms API for automatic URL submission.
How it works:
User clicks the Chrome extension while browsing.
The extension captures the active webpage URL.
It submits the URL, User ID, and timestamp to a Google Form.
Google Forms instantly logs the data to a connected Google Sheet.
A daily script updates the Sheet to keep records organized and analytics-ready.
Stage 2: Data Filtering
Stage 2: Data Filtering
Outline:
Core Functionality: Users can filter URLs by content type (Article, Website, Video, Report, Blog) and citation type, and have the option to select and copy citations (APA, MLA, IEEE) directly from the sheet.
Automation: Daily automation triggers on both sheets to filter URLs and sync citation data, ensuring accurate, up-to-date records. The process uses Google Sheets' built-in functions for syncing and updating data.
API Integration: Extended API functionality with Google Sheets ensures URLs are filtered correctly and synced across sheets.
How it works:
User clicks the Chrome extension and selects a filter from the dropdown menu.
The extension submits URLs along with their selected categories to Google Sheets.
Data appears in filtered buckets on Google Sheets.
Users have the option to select and generate citation type.
Daily automation updates the Sheet to keep data current.
Stage 3: Citation Filtering
Stage 3: Citation Filtering
Outline: (in development)
Core Functionality:
Automation:
API Integration: =
How it works:
Pros
No login or training needed.
Scales easily for small teams.
Ethical and privacy-conscious: users choose what to submit.
Uses Google tools, so it’s free and accessible.
Cons
Google Forms restricts field logic and validation.
Would need a custom backend for large-scale enterprise tracking.
To view the installation demo select unmute and play
Page updated
Google Sites
Report abuse