In this article:

Flowchart in Google Sheets: The Ultimate Guide for 2024

October 8, 2024

In this tutorial, we will show you exactly how a flowchart in Google Sheets is created in just a few simple steps. Read on to learn more.

google sheets flowchart template

How to Make a Flowchart in Google Sheets

Follow the steps below to create the Google Sheets Flowchart.

1. Open the Drawing Tool

On your current sheet, click the Insert menu then go to Drawing. This will open the drawing window of Google Sheets.

Google Sheets draw a flowchart

2. Create Shapes for Your Flowchart

Use shapes like rectangles, ovals, and connecting arrows or lines from the drawing tool to build the Google Sheet flowchart. These shapes represent each step in your process. For example, rectangles are commonly used for tasks, ovals represent the start or end of a process, and arrows show the flow or direction between steps.

Making the Google Sheets flowchart

3. Label Your Flowchart Shapes

Double-click each shape to add short labels. You can also format these texts by using the upper right section of the menu.

4. Arrange and Adjust the Flowchart Layout

Drag shapes and arrows to rearrange them according to your liking. You can select the whole flowchart by pressing Ctrl + A then use your keyboard’s arrow keys to move them all at once.

5. Save the Google Sheets Flowchart

Click Save and close to finalize your flowchart. This will export the flowchart to your current sheet.

We hope that you now have a better understanding of how to create a flowchart in Google Sheets. If you enjoyed this article, you might also like our articles on what to do when your google sheets are too large to import and how to export google sheets as csv with quotes.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->