Google Sheets Flow Chart: Create and Customize One

Yes. In Google Sheets in a web browser, choose Insert > Drawing > New, add flowchart shapes and connector lines, then select Save and close to place the diagram on the sheet. Sheets can hold a useful visual flow chart, but its Drawing tool does not automatically build or update a diagram from spreadsheet data.

What a flow chart in Google Sheets can do

A flow chart lays out steps and decisions in a process, using labeled shapes and lines to show what happens next. In Sheets, you create that diagram in the Drawing editor and insert it as an object over the cells. This is handy when a process belongs beside the table that documents it: for example, an order-tracking sheet could show how a new order moves from receipt to payment, packing, and dispatch.

Common flowchart conventions help readers understand the picture quickly. A rounded terminator shape marks a start or finish, a rectangle represents an action, and a diamond represents a decision with branches such as Yes and No. Arrows show direction. These conventions are widely used, but they are not enforced by Sheets; you choose the shapes and label them yourself.

Sheets is most suitable for a modest diagram that needs to live with spreadsheet information. It is not a dedicated diagramming application: it does not automatically arrange a complex process, validate that every branch reaches an endpoint, or turn rows of data into connected flowchart nodes.

How to create a flow chart

Use a desktop browser for the full Drawing workflow. Start with the sheet where you want the chart, then follow these steps:

Choose Insert > Drawing > New. A Drawing editor opens over the spreadsheet.
Open the Shape menu on the toolbar, point to Shapes, and choose a shape. The flowchart symbols are available in the shape choices. Draw the shape on the canvas; repeat for the process steps and decisions.
Add labels by selecting or double-clicking a shape and typing, or insert a text box if you want text that is not inside a shape. Keep labels short enough to read at the size the diagram will appear in the sheet.
Use the Line menu to choose a connector or arrow, then draw connections between the relevant shapes. Add a Yes or No label near each decision branch so the reader does not have to infer what the paths mean.
Adjust the size and position of shapes, arrange the flow in a consistent direction, and select Save and close. The drawing is inserted on the sheet.

For example, an expense approval flow might begin with “Request submitted,” continue to a diamond labeled “Within budget?”, and split into two paths. The Yes path can lead to “Manager approves” and “Reimburse”; the No path can lead to “Return for changes” or “Decline.” Use arrows to make the sequence unambiguous, and include a clear endpoint for each outcome.

If you need to change the diagram later, select the drawing in the sheet and use its edit option to reopen it. Make the changes in the Drawing editor and save and close again. The drawing is separate from ordinary cell content, so editing a nearby cell does not edit the diagram.

Plan the process before drawing

A little planning makes a chart easier to follow than adding shapes until the canvas is full. Write down the start, actions, decisions, possible outcomes, and finish points first. Then check that every decision has a named branch and that the arrows do not leave the reader wondering where to go next.

Choose a reading direction. Top to bottom is often easiest for a basic process; left to right can work well for a timeline-like sequence. Avoid switching directions without a clear reason.
Keep each shape focused. Use a verb-led action such as “Check address” rather than a long explanation. Put supporting instructions in cells or a note if they do not fit cleanly in the chart.
Make branches explicit. Label decision exits with terms such as Yes and No, Approved and Rejected, or the actual outcomes in the process.
Check edge cases. Include what happens when information is missing, a request is rejected, or a step fails. A chart that shows only the normal route can mislead people using it as instructions.

For a customer-support process, for instance, the start might be “Ticket received,” followed by “Identify issue” and a decision such as “Can support resolve it?” One path could lead to “Send solution” and close the ticket; the other could lead to “Escalate to specialist.” That example stays understandable because each shape states one step and the decision has distinct outcomes.

Format shapes and connectors for readability

The Drawing editor offers basic formatting controls for fill color, border color, line weight, text, and alignment. Use formatting to clarify structure rather than to decorate every shape differently. For example, one color for decisions and another for actions can help, provided the meaning is consistent throughout the chart. Do not rely on color alone to communicate a critical distinction; labels should still make the route clear.

Use a readable font size and enough contrast between text and fill. A diagram may look legible in the editor but become difficult to read when the drawing is reduced on a crowded sheet or viewed on a smaller screen. Leave space between shapes so arrowheads and branch labels are visible. Straight or elbow connectors can make a more orderly route than lines that cross through the middle of unrelated shapes.

Sheets does not provide a flowchart-specific automatic alignment or layout system comparable to a dedicated diagramming tool. You may need to move shapes manually and redraw or adjust connectors after changing the layout. A sensible grid-like arrangement, even spacing, and a consistent shape size make manual diagrams easier to maintain.

How drawings relate to cells and spreadsheet data

A key limitation is that a drawing is not a live data-driven chart. Text typed inside a shape does not become a cell value, and changing a cell does not automatically rewrite a label inside the drawing. Similarly, the drawing does not behave like a chart generated from a cell range. If a procedure changes, someone must edit the drawing itself.

The drawing sits over the grid, so it can cover cells and make nearby data harder to select. Keep it in a clear area, or place it on a separate tab when the worksheet needs to remain easy to filter, sort, and edit. If the chart needs to refer to a data table, use descriptive labels or add a nearby note explaining which rows or fields it represents. Do not assume that sorting the sheet will rearrange the flowchart.

Because the diagram and its source information are separate, consider adding a version date or an owner in the sheet. This simple practice helps readers notice when a chart may need review. If a workflow is controlled by a table of steps and must stay synchronized automatically, consider a tool designed to generate diagrams from structured data instead.

Sharing, printing, and collaboration

Sheets supports sharing the spreadsheet through its usual sharing controls, and collaborators with sufficient access can work with the file. A person who needs to change the drawing must be able to edit the spreadsheet; a viewer can inspect it but cannot make edits. When several people maintain the process, agree on who owns updates so the diagram does not become stale.

Before printing or exporting a sheet, check how the drawing fits in the print area. A large drawing may be clipped, scaled down, or separated from the data it explains depending on the sheet layout and print settings. Use print preview to inspect the result, adjust the drawing or page setup, and make sure labels remain readable. For a chart intended to stand alone in a presentation or handout, a dedicated diagram or slide may produce a cleaner page than a busy spreadsheet tab.

Common problems and practical fixes

The Drawing option is hard to find: confirm you are using Google Sheets in a web browser and check the Insert menu. The full desktop workflow may not be available in the same way in mobile interfaces.
Text is cramped: shorten the label, enlarge the shape, or split one complicated action into separate steps. Avoid shrinking text until it is difficult to read.
Arrows cross or point ambiguously: rearrange the shapes, use elbow-style connectors where appropriate, and label decision branches near their starting point.
The diagram covers data: move it to an unused part of the tab or create a separate tab for the process. Remember that it is an object placed over the grid.
The flow chart no longer matches the procedure: update the drawing as well as any written instructions or data table. A cell edit will not update drawing text automatically.

For a complicated chart, the main problem is often not a missing feature but too much information in one picture. Divide the process into smaller charts by role, stage, or outcome. A clear overview with links or references to detail is usually more useful than a single diagram with tiny text and many crossing arrows.

Google Sheets versus other diagram tools

Google Sheets is convenient when the diagram is small and its supporting data is already in the workbook. It keeps the process and the spreadsheet in one shared file, and the Drawing editor is sufficient for basic shapes, labels, and connectors. The trade-off is manual layout and no automatic connection between diagram labels and cell values.

Google Slides can be a better choice when the flow chart needs room, presentation-sized text, or a polished page for an audience. Google Drawings or a dedicated diagramming application may be more comfortable for larger diagrams and repeated editing. If a process diagram must be generated from data, look for a tool that specifically supports data-linked diagrams or automation; a Sheets drawing alone does not provide that behavior.

Excel also supports drawing shapes, but it is a different application with its own menus and editing behavior. The Google Sheets instructions above should not be treated as Excel menu directions. Choose the tool based on the job: Sheets for a simple diagram alongside spreadsheet data, and a diagram-focused app for complex structure, automatic layout, or extensive collaboration on the diagram itself.

Frequently Asked Questions

Does Google Sheets have a built-in flowchart maker?
Sheets has a Drawing editor that lets you place flowchart shapes and connectors, but it is not an automatic flowchart generator. You arrange and label the symbols yourself.

Can I make a flow chart from spreadsheet rows automatically?
Not with the standard Drawing workflow. A drawing does not automatically convert rows into connected steps or update its text when cell values change. Use a diagramming tool with data-driven features if that is essential.

Can I connect a flowchart shape to a cell?
You can place the drawing over cells, but that does not create a live link between a shape and a cell. The shape’s label must be maintained in the drawing editor.

Can I move or resize the chart after inserting it?
Yes. Select the drawing on the sheet and use its handles to reposition or resize it. Reopen it with the edit option when you need to change its shapes or wording.

Is Google Sheets a good choice for a large flow chart?
It can hold a large drawing, but manual arrangement and limited space can make a complex chart hard to read and maintain. Split it into smaller diagrams or use a dedicated diagramming application for extensive branching.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.