How Do You Turn a Spreadsheet Into a Simple App Without Coding?
You turn a spreadsheet into a simple app by opening it in Google Sheets, going to Insert > Create a canvas, and describing in ordinary words what you want to see. Gemini then builds an interactive page on top of your data, such as a task board, a dashboard, or a schedule, and anything you change on that page changes the spreadsheet too. There is no code, no formulas, and nothing extra to buy. Google calls the feature Sheets canvas, and it published six example mini apps on its Workspace blog. This post walks through each one in everyday terms and includes a prompt you can copy and paste.
Your spreadsheet already has the app in it
Picture a team member who keeps the week's job list in a spreadsheet. Every morning, someone scrolls across fifteen columns to work out what is late, who is doing what, and which customer is still waiting for a reply. The information is all there. What is missing is a way of looking at it that makes sense at a glance.
That is the gap a canvas fills. It does not replace your spreadsheet or move your data anywhere. It gives you a second view of the same rows, laid out the way you think about the work: as cards on a board, as headline numbers, or as a calendar. Change something on the canvas, and the corresponding cell in the spreadsheet updates. Change a cell, and the canvas updates.
You do not need to know what an "app" is under the bonnet, and you do not need to write a single line of code. You describe what you want in the same words you would use to explain it to someone in your team who was going to build it for you, and Gemini does the building. Because it all happens inside your own Google Workspace, nobody needs to paste your figures into a free chatbot to make sense of them, which is how shadow AI creeps into a business.
What is a canvas in Google Sheets?
A canvas is an interactive page that lives inside your spreadsheet and draws on the data from one of its tabs. Google's announcement in the Workspace Updates blog describes it as read-write, meaning it works in both directions: you can view your data through it and edit it through it.
A few practical points are worth knowing before you start. A canvas works on a computer, not in the Sheets app on your phone, and for now only in English. Each canvas reads from one tab, so if your information is spread across several tabs, start with the one that matters most. And because the canvas lives inside the spreadsheet, it is shared with exactly the same people as the spreadsheet. There are no separate permissions to set or forget about.
How do you make your first canvas?
Open the spreadsheet on your computer. It needs to be a Google Sheet stored in Google Drive. If it is an Excel file, open it in Google Sheets and first choose File > Save as Google Sheets.
Go to the tab with your list. The canvas will work from that tab. Check that the first row has clear headings, such as Customer, Job, Due date, and Status, because Gemini uses those headings to understand your data.
Choose Insert > Create a canvas. A box appears asking what you would like to build. Type it in your own words, or paste one of the prompts further down this post.
Ask for changes in the same way. If the result is not quite right, tell Gemini what to change: "make the text bigger", "add a column for Waiting on parts", or "use our company colours". You can keep refining it until it works the way you want. Click View data at any point to see the rows behind the canvas, a quick way to verify that the numbers Gemini is showing you are the ones you expected.
Share it with the link. Click Copy link at the top right and send it to your team. Anyone who can edit the spreadsheet can change things on the canvas. Anyone who can only view or comment on the spreadsheet can look, but cannot change anything.
To come back to a canvas later, open the spreadsheet and click the Canvas menu in the bar at the bottom of the screen. To get back to your normal spreadsheet, click any other tab.
Six things you can build with Sheets canvas
Each example below follows one of Google's six, retold for a small business. Google's own short video sits under each one, so you can see what the finished canvas looks like. The prompts are rewritten in plain English from the ones Google gives in its video descriptions. Swap in the names of your own columns and categories where they differ.
1. A job board where you can drag cards around
A kitchen fitter keeps every job in a spreadsheet: the customer, the address, who is fitting it, the due date, and the status. On a Monday morning, the question is always the same. What is waiting to start, what is in progress, and what is on hold because the customer has not yet chosen the worktops?
A board answers that at a glance. Each job becomes a card, and the cards sit in columns by status. When a job moves on, you drag its card into the next column, and the Status cell in the spreadsheet updates by itself. You may hear this kind of board called a Kanban board. It is the same idea as sticky notes moving across a whiteboard.
Turn my list of jobs into a board with four columns: Not Started, In Progress, Waiting on Customer, and Done. Show each job as a card with the customer's name, who is doing it, and the due date. Let me drag cards between columns, click a card to change its details, and add a new job with a button at the top.
2. A dashboard that shows the numbers that matter
A hair salon records every appointment in a spreadsheet: the date, the stylist, the treatment, and what the client paid. By the end of a month, that is hundreds of rows, and nobody wants to scroll through them to find out whether colour treatments are up or which day of the week is quietest.
A dashboard puts the answers at the top of the page. Headline figures for the month, a chart of how takings are moving, and filters so you can look at one stylist or one treatment at a time. When a new appointment is added to the spreadsheet, the dashboard picks it up straight away.
Make a dashboard of my takings. At the top, show the total takings, the number of appointments, and the average spend per visit. Underneath, show a chart of takings by month and a breakdown by treatment. Add filters so I can choose a month or a stylist, and make every number and chart update when I change a filter.
3. A "what if" model for your forecast
A café owner has a 12-month forecast in a spreadsheet and two decisions to make: whether to put prices up, and whether opening on Sundays would pay for the extra hours. Testing those ideas in the spreadsheet means changing figures, checking the totals, and then trying to remember what the numbers were before.
A "what if" canvas turns the big assumptions into sliders. Move the price up by 5%, or add Sunday trade, and the profit and the closing bank balance change in front of you. Google says your team can test different scenarios together this way without breaking the formulas underneath.
Build a "what if" page from my 12-month forecast. Give me sliders for the price increase, the cost of stock, and the number of customers a week. When I move a slider, show straight away what happens to the monthly profit and the cash in the bank at the end of the year, with a simple chart. Do not change the figures in my spreadsheet.
4. A visual schedule for an event
A garden centre is running a two-day Christmas weekend: wreath-making workshops, a Santa's grotto, late-night shopping, and a food stall in the car park. The plan lives in a spreadsheet with a row for each session, and it is hard to see from the rows where two things clash or where there is an empty hour on Sunday afternoon.
A schedule canvas lays the sessions out as a timeline, one day at a time. Gaps and overlaps jump out. You can drag a session to a new time or add one with a short form, and the spreadsheet stays in step.
Turn my event plan into a visual timeline, one day at a time, with buttons at the top to switch between Saturday and Sunday. Show each session as a card with its time, where it happens, and who is running it. On the left, show the start and finish time for each day and how many sessions there are. Add a "New session" button that opens a simple form, and let me drag a session to change its time.
5. A priority grid for your to-do list
A dental practice has a long list of improvements it would like to make: online booking, new chairs in the waiting room, text reminders for check-ups, and a refreshed website. Everything feels important, and the list never gets shorter.
A priority grid sorts the list by two simple questions: how much difference will this make, and how much effort will it take? Each idea becomes a dot on a grid of four boxes. The ones in the "big difference, little effort" box are the ones to start with. As the team adjusts the scores, the dots move, and the decision gets easier to see.
Put my list of ideas on a grid with "how much difference it makes" going up and "how much effort it takes" going across, split into four boxes labelled Quick wins, Big projects, Fill-ins, and Not worth it. Show each idea as a dot that shows its name when I hover over it. When I click an idea, open a panel with sliders for difference and effort, and move the dot as I change them.
6. A board for your team's ideas
An accountancy practice holds a team meeting about winning more clients. Twenty good ideas go into a spreadsheet as people call them out, and a week later, nobody can remember which ones were agreed or who was going to follow them up.
An ideas board turns that list into sticky notes, grouped into areas you choose. People can add notes, move them around, vote for the ones they like, and put their name on the ones they will take forward. Every note is saved back to the spreadsheet, so nothing from the meeting gets lost.
Turn this list of ideas into a board of sticky notes, split into three areas: Win new clients, Keep existing clients, and Ideas for later. Let anyone add, edit, or drag a note anywhere on the board. Give each note a vote button and a space for the name of the person taking it forward. Put new notes at the bottom of their area.
Which canvas fits which job?
| Which Sheets Canvas Fits Which Job? | ||
| What your spreadsheet holds | What to ask for | What you get |
|---|---|---|
| A list of jobs or tasks | A board with a column for each status | Cards you drag from column to column, with the status updating in the spreadsheet |
| Sales or takings by date | A dashboard with headline figures, a chart, and filters | The month's numbers at a glance, broken down by person, product, or service |
| A 12-month forecast | A "what if" page with sliders for your big assumptions | Profit and cash that change as you move a slider, without breaking your formulas |
| An event or project plan | A day-by-day timeline with a form for new items | Clashes and gaps you can see, and sessions you can drag to a new time |
| A list of ideas or improvements | A four-box grid of difference against effort | The quick wins sitting in one corner, ready to start |
| Notes from a team meeting | A sticky-note board split into themes, with votes and owners | Every idea grouped, voted on, and given a name, all saved to the sheet |
| Team members' holidays | A month-view calendar of who is off | Clashing holidays spotted before you approve them |
What helps a canvas come out right the first time?
Gemini can only work with what is in the spreadsheet, so a tidy tab gives a better result. Put one item per row, such as a job, appointment, or session, and give each column a clear heading in the first row. Merged cells and blank rows in the middle of the list tend to confuse things.
Be specific in your prompt about the columns you want to see. "Show the customer's name and the due date on each card" works better than "show the important details". If the first attempt is close but not right, ask for one change at a time, as you would with a person.
Remember that a canvas edits the real data. Dragging a card or deleting a note on the canvas changes the spreadsheet, for you and for everyone it is shared with. If something goes wrong, you can restore an earlier version of the spreadsheet from its version history. If you want to experiment freely, make a copy first using File > Make a copy, then build your canvas on the copy.
Frequently asked questions
-
No. You describe what you want in ordinary words, and Gemini builds it. If you can explain to a team member what you would like a page to show, you can make a canvas. Changes work the same way: you ask for them in a sentence.
-
If you are a Kimbley IT client, yes. Open any Google Sheet on your computer and look for Insert > Create a canvas. It works on a computer rather than a phone, and only when your Google account's language is set to English.
-
Yes, when you edit something on it. Moving a card, changing a date, or adding a new item on the canvas updates the matching cells in your spreadsheet straight away. Simply looking at a canvas changes nothing, and anything typed into the spreadsheet shows up on the canvas.
-
The same people who can see the spreadsheet. A canvas has no sharing settings of its own; it follows the spreadsheet's. People with edit access can change things on it, and people with view or comment access can look but not change anything.
-
Yes, once it is a Google Sheet. Open the Excel file in Google Sheets and choose File > Save as Google Sheets. Then make your canvas on the new version, which is saved in your Google Drive.
Is your IT support showing you things like this?
Sheets canvas is the kind of change that quietly arrives in the Google Workspace you already pay for, and it can save your team hours every week. If your business runs on Google Workspace and your IT support provider is not telling you about features like this or showing your team how to use them, you are paying for far more than you are getting.
Kimbley IT is an authorised Google partner providing IT assistance and support to businesses in the UK and the US. Part of that is making sure your team gets the most out of the tools you already have, rather than being left to find them on their own. If you do not have an IT support provider at all, you are missing out on even more.
Book a video call with Kimbley IT using the form below. You will have a straightforward conversation about how your business works today and where Google Workspace could do more of the work for you.
