How to Make an ADHD Daily Planner | Google Sheets Tutorial, by You Are Loved Templates on YouTube. 25 min 57 s.
- Video length
- 25 min 57 s
- Time to do it
- 45 minutes
- Difficulty
- Medium
- Steps
- 10
What you need
Steps
Open Google Sheets and create a blank spreadsheet. Rename the tab Daily Planner so the reset script can find it later.
Lay out a time-blocked schedule down the left side. Put times in column A from morning to night and leave column B free for what you plan to do in each block.
Add a single daily focus box at the top, for example in cell G8. Merge a few cells and label it Today's Focus so one task stands out.
Build the three-tier task system to the right of the schedule. Label three areas Priorities, Do Later and Everything Else, and leave rows under each for typing tasks.
Add a rewards section near the tasks. List two or three small rewards and a checkbox next to each so you can tick one off when a task is done.
Create a habit tracker with a row per habit and a checkbox column. Add a completion cell that counts ticked boxes divided by total habits and format it as a percentage.
Add a meals tracker with rows for breakfast, lunch, dinner and snacks, plus a self care tracker with icons or emoji for water, movement and rest.
Make a Brain Dump box in an empty area of the sheet. Give it a clear border and enough blank rows to catch racing thoughts without cluttering the main planner.
Open Extensions, then Apps Script. Paste the clear function from the description, which clears ranges like B9:E56 and G13:J18, and save the project.
In Apps Script, add a drawing or button to the sheet and assign the clear function to it. Click it once to test that the planner resets to blank.
Tips and common mistakes
Keep the planner to one screen so you are not scrolling and losing focus.
Test the clear script on a copy of the sheet first, since it wipes every range you list.
Use checkboxes from the Insert menu instead of typing X, so the habit percentage updates on its own.
Set the daily focus the night before to cut down on morning decision fatigue.
Questions
Do I need to know how to code?
No. You only copy and paste the clear function into Apps Script and assign it to a button. The rest is normal spreadsheet formatting.
Can I reuse the planner every day?
Yes. The Clear Data button empties the schedule, tasks, trackers and brain dump so you start fresh each morning.
Will this work on my phone?
Yes, the Google Sheets app opens the file, but building and formatting it is much easier on a computer.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
