How to Build Gantt Charts in Google Sheets: Pro Guide

1. Manual ways to build Gantt charts in Google Sheets

‍

1.1 Start from a simple task table

Before you draw a single bar, get your data clean.

In a blank Google Sheet, create these columns:

• WBS Number (e.g., 1, 1.1, 1.1.1)
• Task Title
• Task Owner
• Start Date
• Due Date
• Duration (days)
• % Complete

This mirrors the classic Gantt template layout where phases are grouped by WBS, and each row is a single task.

You can calculate duration with a formula:

=IF(AND(E2<>"",D2<>""), E2 - D2, "")


Where D2 is Start Date and E2 is Due Date.

Google’s general chart help is here: https://support.google.com/docs/answer/190718

‍

1.2 Build a bar-style Gantt with stacked bar chart

Google Sheets doesn’t have a native “Gantt” chart type, but you can fake it with a stacked bar chart:

1. Add two helper columns to your table:
   • Start Offset – days from project start.
   • Task Length – same as Duration.
2. In a cell, define Project Start (e.g., B1).
3. In Start Offset (e.g., G2):=IF(D2="",,D2 - $B$1)

4. In Task Length (H2), just reference Duration (F2).
5. Select Task Title, Start Offset, and Task Length columns.
6. Insert → Chart → change chart type to Stacked bar chart.
7. Under Customize → Series, set the Start Offset series color to none (transparent).
8. Adjust horizontal axis to show dates instead of numbers by formatting the axis and aligning min/max.

You now have a manual Gantt: each bar’s invisible segment positions the visible segment at the right date.

‍

1.3 Use conditional formatting Gantt in-grid

If you like the template style from the classic "Gantt Chart Template Google Sheet" approach:

1. Create columns for Week 1–Week 12 (or specific dates) across the top.
2. Put the start/end dates for each task in the left-hand columns.
3. In the first timeline cell (e.g., I9), use a formula like:=AND(I$8>=$D9, I$8<=$E9)
Where I$8 is the date of that column, D9 is Start Date, E9 is Due Date.
4. Apply conditional formatting using a Custom formula is rule with that expression, and choose a fill color.
5. Copy formatting across the grid.

You’ll get a heatmap-style Gantt directly inside your sheet.

‍

1.4 Track % complete and phases

To mirror the template’s PHASE ONE / PHASE TWO style:

• Use WBS numbers like 1, 1.1, 1.1.1 and insert phase header rows (1, 2, 3, 4) with bold formatting.
• Insert a Phase column that repeats the phase name for each task.
• Use FILTER or pivot tables to summarize progress by phase.

This keeps your visual Gantt aligned with stakeholder-friendly phase language.

‍

2. No-code automation for Google Sheets Gantt

Manual upkeep breaks down once you have dozens of projects. No-code tools can keep your Gantt updated without hiring a developer.

‍

2.1 Trigger updates from forms or CRMs

Use tools like Zapier, Make, or native connectors to:

• When a deal stage changes in your CRM, add a row in your project Gantt sheet.
• When a client fills a briefing form, create a new phase with pre-defined tasks and dates.

Concrete example with Zapier (conceptual):

1. Trigger: New opportunity in HubSpot at "Contract signed".
2. Action: Create Spreadsheet Row in your Gantt sheet with:
   • Task Title = Client onboarding: [Company]
   • Start Date = Today
   • Due Date = Today + 7
   • Owner = CSM from CRM data.
3. Your Gantt chart (built from that range) updates automatically.

‍

2.2 Use add-ons like GANTTophant

The GANTTophant add-on (from Google Workspace Marketplace) creates Gantt charts directly in Sheets with task hierarchies, views (day/week/month), and dependencies.

You can explore it here: https://workspace.google.com/marketplace
(Search for "Gantt Chart & Project Management by GANTTophant".)

‍

Typical setup:

1. Install the add-on from Marketplace.
2. In your project sheet, open Extensions → GANTTophant.
3. Define your WBS hierarchy, start/end dates, and dependencies.
4. Generate a Gantt chart view in a new sheet tab.

This gives you richer visuals and dependency lines without custom formulas.

‍

2.3 Use Apps Script for recurring project templates

If you’re comfortable with light scripting, Google Apps Script lets you:

• Clone a project template sheet for each new client.
• Automatically set start dates based on a kickoff date.
• Shift dependent tasks based on durations.

Reference: Google Apps Script documentation for Sheets – https://developers.google.com/apps-script/guides/sheets

This is still “no-code” for many teams but does require some scripting effort.

‍

3. Scaling with AI agents (Simular) at desktop level

At some point, your bottleneck is no longer updating a single Gantt, but orchestrating dozens of Sheets across campaigns, clients, and teams. That’s where a computer-use AI agent like Sai becomes powerful.

Sai acts like a power user at your Mac: it opens Google Sheets in the browser, navigates tabs, edits cells, and even coordinates with CRMs or docs. You define the workflow once; the agent executes it reliably.

‍

3.1 Workflow: daily Gantt health check

The agent can:

• Open your portfolio Gantt Sheet.
• Scan for tasks where Today > Due Date and % Complete < 100%.
• Highlight overdue bars in red and add a “Risk” label.
• Post a summary to Slack or email.

‍

Pros:

• Zero manual checking.
• Multi-step flows (Sheets → Slack → email) work end-to-end.

‍

Cons:

• Requires initial configuration and testing.
• You should monitor early runs to ensure rules match your process.

Learn more about Sai’s capabilities: https://www.sai.work/

‍

3.2 Workflow: auto-rescheduling dependencies

Instead of you dragging bars:

1. Agent opens the Gantt sheet.
2. Identifies any task where % Complete < 100% and Today > Due Date.
3. For each dependent task (based on a Dependencies column or WBS rules), it pushes the start and due dates by the slip amount.
4. Recalculates durations and updates conditional formatting.

‍

Pros:

• Keeps the schedule realistic without meetings.
• Works across multiple project sheets.

‍

Cons:

• You must define clear dependency rules.
• Stakeholders need communication norms so changes aren’t surprising.

‍

3.3 Workflow: generating new Gantt plans from briefs

For agencies and marketing teams:

• Agent reads a client brief (Google Doc or email).
• Generates a standard project plan (phases, tasks, durations) based on your template.
• Creates a new Google Sheet from the template, fills in tasks, owners, and dates.

‍

Pros:

• Onboarding becomes a one-click operation.
• Ensures every project follows your best-practice structure.

‍

Cons:

• Requires some upfront prompt design and examples.
• Best results when combined with your own templates and naming conventions.

By combining Google Sheets’ flexible Gantt structures with Simular’s AI computer agent, you move from “we update our timelines when we have time” to “our timelines update themselves while we focus on strategy.”