How to Build a Project Intake Dashboard in Google Sheets

You open your inbox on a Monday morning and there it is: three new project requests. One came through email, another via chat, and one from a hallway conversation. Each sounds urgent but lacks details.

That’s when a project intake dashboard comes in; it acts as a practical control center that shows you everything you need.

This guide walks you through building a functional project intake dashboard in Google Sheets, covering data structure setup, visualization techniques, interactive filtering, and the limitations you’ll eventually hit as your intake volume scales.

We’ll also explore how ClickUp, the world’s first Converged AI Workspace, is definitely a better option for your next project dashboard. 🤩

What Is a Project Intake Dashboard?

Project requests are flying at you from everywhere and this chaos makes it impossible to track what’s been submitted, approved, or stuck in limbo, leading to missed deadlines and frustrated stakeholders. 

A project intake dashboard is a visual summary that brings order to this process, giving you a single view of every incoming request.

It answers the critical question, ‘What work is coming in?’ before that work ever gets planned, a key part of the project initiation phase. 

Unlike a project tracking dashboard that monitors work already in progress, an intake dashboard focuses on the front door. It helps PMO teams, department heads, and leaders focused on resource management triage incoming work requests before they hit the backlog, using components like a request log, status breakdowns, and submission trends.

Why Use Google Sheets for Project Intake Tracking?

You know you need to formalize your project intake process now, but you don’t have the budget or time to get a new tool approved. So, Google Sheets comes in as a practical first step.

Since most teams already have Google Workspace, there are no procurement hoops to jump through. You get a familiar interface that lowers the learning curve, and multiple stakeholders can view and update the intake log at the same time. 

You also have total control to customize every field and formula, and you can even connect a Google Form to automate request capture. These benefits make Sheets a reasonable starting point, though you’ll likely hit ceilings as your intake volume grows.

How to Build a Project Intake Dashboard in Google Sheets

Let’s break down how to build a dashboard in Google Sheets for your project intake process. ⚒️

Step #1: Set up your project intake data structure

If you’ve tried using a spreadsheet for tracking before, you know it can quickly become a mess of inconsistent data, typos, and broken formulas. A dashboard built on messy data is worse than no dashboard at all because it gives you misleading information. To avoid this, you need to set up a solid data structure from the start.

This involves defining your fields, creating validation rules to keep data clean, and organizing your tabs for clarity: 

1. Define your project request fields

Your dashboard’s power comes from consistent, well-defined data fields. Without them, you can’t accurately filter, sort, or visualize requests. Every intake log should include a standard set of fields to capture the right information from the start.

Here are the essentials:

• Request ID: A unique number for each submission that prevents duplicates and makes tracking easier
• Request Date: The date the project was submitted, which helps track how long requests sit in the queue
• Requester Name: The person or department asking for the project
• Project Name/Title: A brief, clear description of the requested work
• Project Type: The category of work, such as a new initiative, an enhancement, or a maintenance task
• Priority: The urgency level, like critical, high, medium, or low
• Status: The current stage of the request, such as Submitted, Under Review, Approved, Rejected, or On Hold
• Assigned Reviewer: The person responsible for evaluating the request
• Target Start Date: The ideal start date from the requester’s perspective
• Estimated Effort: A rough estimate of the work involved, often using T-shirt sizes (S, M, L) or hours
• Notes/Comments: A space for any additional context or details

2. Create a data validation system

If one person enters ‘High’ for priority and another enters ‘high,’ your charts and filters will break.Data validation solves this by forcing users to select from a predefined list.

To set up a dropdown list in Google Sheets: 

• Select the column you want to control
• Navigate toData > Data validation
• Choose ‘Dropdown’ 
• Enter the allowed values, like for the Status column, enter: Submitted, Under Review, Approved, Rejected, On Hold.

💡 Pro Tip: Create a hidden ‘Lookups’ tab to store these lists. This makes it much easier to update your dropdown options later without having to edit each validation rule individually.

3. Organize your raw data tab

Never build your dashboard on the same tab where you enter data. This is a recipe for disaster, as a simple sorting error or accidental deletion can break all your charts. Instead, keep your raw intake data on a dedicated tab and name it something clear like ‘Intake_Data.’

Follow these best practices for a clean data tab:

• Freeze the header row: This keeps your column titles visible as you scroll
• Use consistent date formatting: YYYY-MM-DD is best for reliable sorting
• Avoid merged cells: They are notorious for breaking formulas and pivot tables
• Leave no blank rows: An empty row can stop formulas from calculating correctly

You can also connect a Google Form directly to this tab, which allows stakeholders to submit requests through a user-friendly form that automatically populates your sheet.

Step #2: Build your project intake visualizations

A giant spreadsheet of requests is overwhelming and makes it impossible to see the big picture. You can’t answer simple questions like, ‘Is our request volume increasing?’ or ‘Where are the bottlenecks in our approval process?’ Data visualizations turn that raw data into at-a-glance insights. 

You’ll build three core chart types to create a powerful Google Sheets dashboard: scorecards for key metrics, a line chart for trends, and a pie chart for status breakdowns. 📊

1. Add scorecards for key intake metrics

A scorecard is a chart type that displays a single, important number. It’s perfect for showing top-level key performance indicators (KPIs) that give an immediate sense of your intake health.

Here are a few essential metrics for your project intake dashboard:

• Total Requests Submitted: Use the COUNTA formula on your Request ID column to get a running total
• Requests Pending Review: A COUNTIF formula where the status is ‘Under Review’ shows your immediate backlog
• Approval Rate: Calculate this by dividing the count of ‘Approved’ requests by the total number of requests that are no longer pending
• Average Days in Queue: Use an AVERAGE formula to calculate the number of days between the request date and today for all pending items

To create one in Sheets, calculate your metric in a cell, then go to Insert > Chart and select the Scorecard chart type.

2. Create a request volume chart

Is your team getting buried in new requests, or is it just a feeling? A request volume chart helps you visualize how many new projects are coming in over time, so you can spot trends and plan capacity. A line or column chart, two common types of charts, work best here.

To build it, you’ll need to group your requests by week or month. You can do this by creating a pivot table from your ‘Intake_Data’ tab. Set the rows of the pivot table to be the ‘Request Date’ (grouped by month) and the values to be a COUNTA of the ‘Request ID.’ Once you have this summary data, you can easily insert a line chart to see your request volume over time.

💡 Pro Tip: Actively manage the intake pipeline with ClickUp Super Agents. These AI teammates work inside your workspace to observe tasks, custom fields, and status changes. They analyze incoming requests and take action when certain conditions appear.

For example, a product intake board may receive dozens of requests each week. A Super Agent can manage triage in several ways:

• Scan newly submitted intake tasks each morning and group similar feature requests into a single review summary for product managers
• Detect multiple bug reports linked to the same feature and create a consolidated investigation task for the engineering team
• Identify requests marked ‘High revenue impact’ and post a weekly briefing comment for leadership before the roadmap review meeting

Learn how to create your own by watching this video:

3. Build a project status breakdown

A status breakdown chart answers the question, ‘Where is everything stuck?’ It shows you the distribution of all your requests across each status category. A pie chart is a simple and effective way to visualize this.

First, create a small summary table that lists each status and uses a COUNTIF formula to count how many requests are in that stage. Then, select that summary table and insert a Pie chart. If your chart shows that 50% of requests are ‘Under Review,’ you’ve just found your biggest bottleneck.

Step #3: Add slicers to filter project requests

Your dashboard is useful, but it becomes truly powerful when you make it interactive. Stakeholders will inevitably ask to see the data filtered in different ways, like ‘Can I just see requests from the marketing department?’ or ‘Show me only the critical priority items.’ 

Slicers are interactive filter buttons that let anyone do this without needing to edit formulas or risk breaking the sheet.

Adding a slicer is straightforward: 

• Click on one of your pivot tables or charts
• Go to Data > Add a slicer 
• Choose which column you want the slicer to control, such as Priority, Project Type, or Requester

Here are some of the most useful slicers for a project intake dashboard:

• A Status slicer to quickly switch between pending, approved, and rejected views
• A Date Range slicer to focus on a specific quarter or month
• A Priority slicer to isolate high-priority requests that need immediate attention

Group your slicers at the top of the dashboard for easy access. Now, your stakeholders can self-serve the insights they need.

Step #4: Assemble your project intake dashboard

You’ve built all the components, and now it’s time to assemble them into a clean, professional dashboard. Create a new, dedicated ‘Dashboard’ tab. This separation is key to preventing users from accidentally editing your raw data or formulas.

A logical layout makes your dashboard easy to read. Consider this structure:

• Top row: Place your scorecards here for at-a-glance KPIs
• Middle section: Position your request volume chart on the left and your status breakdown chart on the right
• Below the charts: Arrange your slicers for easy filtering
• Bottom section: Add a table showing the top five oldest pending requests to highlight items needing action

Use consistent colors; for example, green for ‘Approved,’ yellow for ‘Under Review,’ and red for ‘Rejected.’ Finally, protect the dashboard tab by going to Data > Protect sheets and ranges. This allows people to use the slicers but prevents them from moving or deleting your charts.

Limitations of Google Sheets for Project Intake Management

Your Google Sheet dashboard worked well at first. But now, it’s starting to show its cracks. The sheet is slow to load, someone accidentally deleted a formula, and you’re spending an hour every Monday manually copying approved requests into your team’s actual project management tool. The ‘free’ solution is starting to cost you serious time.

This is the reality of Work Sprawl, the fragmentation of work activities across multiple, disconnected tools and systems that don’t communicate, forcing teams to waste time switching between apps and battling information silos. While Sheets is a great starting point, it wasn’t built for true workflow management.

Here’s where you’ll encounter limitations:

• No native workflow automation: Moving a request from one stage to the next is a manual process. There are no automatic notifications to tell a reviewer it’s their turn, which means requests get stuck
• Limited real-time updates: Your dashboard charts don’t update automatically. Viewers might be looking at stale data unless they remember to refresh the page, leading to decisions based on old information
• No built-in approval process: You can’t formally route a request for sign-off from multiple people. This results in a weak audit log, making it hard to track who approved what and when
• No connection to execution: The biggest issue is the gap between intake and action. An approved request in a spreadsheet is just a row of data; it doesn’t automatically become an actionable task in the tool where your team actually works

Simplify Your Project Intake Dashboards With ClickUp

Project intake often breaks before work even starts. Requests arrive through email, chat messages, spreadsheets, and hallway conversations. Teams spend hours sorting requests instead of evaluating them. Leadership lacks visibility into what entered the pipeline and what deserves priority.

But with ClickUp, request capture, prioritization, analysis, and execution operate inside the same system. Intake data connects directly to tasks, reporting, and automation, which removes SaaS Sprawl and reduces context switching during project intake management.

Capture structured requests using ClickUp Forms

Every intake workflow begins with a consistent submission. ClickUp Forms collect requests in a structured format and convert each entry into a task inside the intake list.

A marketing operations team, for instance, creates a form titled ‘Campaign request intake’. Sales reps submit campaign requests through that form, including the campaign objective, audience segment, launch date, and asset needs. Each submission generates a task inside the marketing intake queue.

Team leads immediately see new requests and begin triage without digging through messages or spreadsheets.

Standardize intake data

Once submissions enter the intake queue, decision makers need structured data to evaluate each request. ClickUp Custom Fields inside Forms capture that data at the moment of submission.

A product operations team may include fields such as:

• Request category, like feature request, bug report, or infrastructure change
• expected revenue impact
• Urgency level
• Requesting department
• Estimated engineering effort

Here’s what Dayana Mileva, Account Director, Pontica Solutions, had to say about their experience using ClickUp:

Track incoming requests using ClickUp Dashboards

After requests enter the intake system, leadership needs visibility into pipeline volume and workload distribution. ClickUp Dashboards display real-time intake data across teams.

A PMO team may build an intake dashboard that includes:

• A task list card showing all newly submitted requests this week
• A pie chart showing request distribution across departments
• A workload card that compares engineering capacity against incoming project demand

Program managers use this dashboard during weekly planning meetings to decide which requests move forward and which wait for the next cycle.

Watch this video to see how you can create project management dashboards:

How to Create a Project Management Dashboard in under 15 Minutes: Step-by-step Tutorial | ClickUp

🚀 ClickUp Advantage: Identify project intake trends using AI Cards in ClickUp Dashboards. You can add:

• AI Summary Cards to analyze recent intake activity and explain major trends
• AI Project Update Cards that highlight progress across active requests
• AI Standup Cards that surface blockers affecting project intake tasks

Route requests through the pipeline using ClickUp Automations

Project intake often slows after submission because each request must be triaged manually. ClickUp Automations removes that bottleneck and pushes requests through the intake pipeline based on the data collected in the form.

A product intake workflow may include rules such as:

• When a form submission sets the request category to ‘Bug’, an automation assigns the task to the QA triage lead and sets the priority to high
• When a request includes the custom field ‘Revenue impact: High’, an automation adds the product strategy team as watchers and moves the task to the ‘Leadership review’ status
• When a requester leaves the effort estimate field empty, an automation assigns the task to an engineering manager and posts a comment requesting a quick sizing review
• When a request reaches the ‘Approved for sprint planning’ status, an automation adds the task to the upcoming sprint list and assigns the product owner

Analyze intake demand using ClickUp Brain

Intake dashboards show numbers, but planning teams often need quick explanations before roadmap discussions. ClickUp Brain analyzes tasks, custom fields, and dashboard data to answer intake questions instantly.

For example, a PMO lead preparing for a monthly prioritization meeting can ask ClickUp Brain: Summarize all project intake submissions from customer success this quarter and highlight requests marked high revenue impact.

ClickUp Brain scans the intake list, reads Custom Fields, such as department, urgency, and effort estimate, then generates a summary that includes the most frequent request categories and links to the relevant tasks.

Automate Your Intake Process Using ClickUp

As intake volume increases, spreadsheets start to strain under the weight of workflow management. Manual approvals, disconnected notifications, stale data, and the gap between ‘approved’ and ‘executing’ create friction. The dashboard becomes a reporting layer instead of a control system.

ClickUp offers a more scalable path forward. With ClickUp Forms, requests are captured in a structured, consistent format. Custom Fields ensure every submission includes the right information.

ClickUp Dashboards provide real-time visibility into request volume, approval rates, and bottlenecks without manual updates. Automations route requests to the right reviewers and trigger status changes automatically. And with ClickUp Brain, you can instantly surface insights, summaries, and trends across your intake pipeline.

Sign up for ClickUp today!

Frequently Asked Questions (FAQ)

1. Can I automate project intake requests in Google Sheets?

You can use Google Forms to automatically populate a Sheet and use Apps Script for basic email notifications, but there’s no native workflow automation for routing requests or managing multi-step approvals

2. What’s the difference between a project intake dashboard and a project tracking dashboard?

An intake dashboard focuses on the ‘front door’ of your projects, such as monitoring new requests before they are approved. A project tracking dashboard monitors the progress of active projects that are already underway.

3. How do I share a Google Sheets project intake dashboard with my team?

Click the ‘Share’ button in the top right, add your team’s email addresses, and set their permissions to ‘Viewer.’ This allows them to see the dashboard and use slicers without being able to accidentally edit their charts or data.

4. Is Google Sheets enough for enterprise project intake management?

While Sheets is a good starting point for small teams, it lacks the robust workflow automation, audit trails, and native integrations required for most enterprise project intake management.

Explore article topics