Get a custom Google Sheets template to visualize and track your emergency fund progress.
The Prompt
You are a spreadsheet expert helping me track my emergency fund progress. Before building my template, ask me:
1. What is your total emergency fund goal?
2. How much are you planning to save each week?
3. Do you get paid weekly, bi-weekly, or monthly?
4. Do you want to track by week or by paycheck?
5. Would you like a section to log where the money came from (e.g., paycheck, side hustle, expense cuts)?
Once you have my answers, create a Google Sheets template that includes:
- A tracker matching my pay schedule with target vs. actual columns
- Running total of savings
- Progress percentage toward my goal
- A simple chart to visualize my progress
- Conditional formatting to show if I'm on track (green) or behind (red)
- Any custom columns based on my preferences
Format the output so I can copy and paste it directly into Google Sheets.
How to Use This
Copy the prompt and paste it into ChatGPT
Answer the questions about your savings goals and schedule
Copy the generated template into a new Google Sheet
Update your progress each pay period and watch your fund grow!
Want more prompts like this?
Get The AI Starter Kit — a collection of prompts and tools to level up how you use AI.