Google Forms Response Trend Chart

WHAT IT DOES

Google Forms Response Trend Chart scans the current page for Google Forms response data, extracting question types, response counts, submission timestamps, and answer distributions from Google Forms results pages and response summaries. The floating panel shows response trend charts with daily/weekly submission counts, question response breakdowns, and comparative analysis. A summary shows total responses, response rate trends, and peak submission times. Filter by date range and question type, and export trend data as CSV or text. Response spikes and drops are highlighted, and form completion trends are tracked over time.

WHERE IT RUNS

Works on Google Forms results pages, including response summaries, individual response views, and question analysis pages. The script detects response data using Google Forms-specific selectors and extracts response metadata. It works best on Google Forms results and response pages.

HOW TO USE

The panel displays a summary of response statistics (total responses, days with responses, average per day, peak day) followed by a daily response trend bar chart. The highest response day is highlighted in gold. Question answer breakdowns show the most common answers for each question. Click "Scan Responses" to detect all response data on the current page. Export the trend data as text for reporting or analysis. The panel automatically detects response spikes and low-activity days.

MECHANISM — RESPONSE EXTRACTION WITH TREND ANALYSIS

The script detects Google Forms responses by finding response containers using selectors (.response-item, .response-row). From each container, it extracts the submission timestamp and individual question-answer pairs using targeted sub-selectors. Timestamps are parsed from various date formats and grouped by day to calculate daily response counts. The trend analysis calculates total responses, unique days with responses, average responses per day, and peak day count. Response spikes (days above the threshold) and low-activity days are identified and flagged. Question answer distributions are aggregated to show answer frequencies for each question. The bar chart is rendered using Canvas API with color coding for peak days. All extraction and analysis runs client-side with no network calls.

THE PANEL

The floating panel is fully draggable and remembers its position per domain. Click the minimize button to collapse it to a small bubble, or press Escape to hide it. The panel automatically adjusts to different screen sizes and can be resized to show more content. All settings, including date range defaults and display preferences, are saved per domain. The panel integrates smoothly with any page layout using the BGPanel framework, maintaining clean separation from page content.

PLEASE NOTE

This script requires the free BotGentz extension to run. It does not send any data to external servers; all extracted response data and settings remain entirely local to your browser using GM_setValue. The script never reads password fields, hidden inputs, or file inputs. It stores only response timestamps, question-answer pairs, and configuration settings from publicly visible Google Forms page content. Response detection depends on the page structure; if responses are not detected, use the "Scan Responses" button to refresh extraction. The script works on Google Forms pages and detects pages by hostname. The response trend chart is based on the data displayed on the current page. Data persists across browser sessions and is isolated per browser profile.