Sick of doing the same boring tasks every day? Here are 10 ChatGPT prompts that helped me automate spreadsheets, follow-ups, reports, and more. Save your time back.
—
Let me tell you something embarrassing.
Until last year, I was spending 5 hours every Monday morning manually creating reports. Copying data from one spreadsheet to another. Formatting tables. Sending emails. It was mind-numbing work and I absolutely hated it.
The worst part? I knew I was wasting time. But I kept telling myself, “It only takes an hour” or “I’ll figure out a better way next month.”
Then I discovered how to use ChatGPT to actually design automation systems. Not just write code—but plan entire workflows step by step. I started feeding my manual processes into these prompts and the AI would come back with a clear automation roadmap.
I automated that Monday report using Google Sheets and a simple script. Now it runs itself. I get the report in my inbox at 8 AM without lifting a finger. That single change gave me back 20 hours a month.
If you are drowning in repetitive work, these 10 prompts will change your life. I promise.
—
1. Automate Repetitive Work
This is the prompt I started with. I literally wrote down everything I did every single day—even the tiny things. Opening emails. Formatting documents. Copying data.
Then I fed that list into this prompt and asked the AI to identify what could be automated. I was shocked. About 60% of my daily tasks could be automated or at least partially streamlined.
The AI even suggested specific tools for each task. Some needed scripts. Some needed no-code tools like Zapier. Some just needed better Excel formulas.
Prompt:
List all the repetitive tasks I perform at work: [Paste tasks]. Identify which tasks can be automated using AI, scripts, workflows, or no-code tools. For each task, explain the best automation approach and the potential time saved.
—
2. Build an Automation Workflow
This prompt is for when you know what you want to automate but have no idea how to structure it.
I used this when I wanted to automate my client onboarding process. I described the entire process—from the moment a client signed up to the moment they received their welcome materials.
The AI designed a complete workflow diagram with triggers, conditions, actions, error handling, and notifications. I literally handed this to my developer and said “build this.” Saved me weeks of planning.
Prompt:
I want to automate this process: [Describe process]. Design the complete automation workflow. Include trigger, inputs, processing steps, conditions, actions, output, error handling, and notifications.
—
3. Automate Excel Tasks
I used to spend hours manually updating Excel sheets. VLOOKUPs, pivot tables, cleaning data—it was painful.
This prompt changed everything. I described what I was doing manually, and the AI suggested specific formulas, Power Query steps, and even VBA macros. It always prioritized the simplest solution first—which I appreciated because I am not a coder.
One suggestion—using Power Query to combine monthly sales files—saved me 3 hours every month. I just hit refresh now. That is it.
Prompt:
I perform these Excel tasks repeatedly: [Describe tasks]. Identify which steps can be automated. Suggest formulas, Power Query, VBA, Python, or automation tools where appropriate. Prioritize the simplest reliable solution.
—
4. Automate Data Entry
Data entry is the biggest time-waster in any business. Copying from one place and pasting into another. It is not hard work—it is just stupid work.
I was manually copying lead details from my CRM into a Google Sheet every morning. This prompt designed an automation that extracted the data, validated it, transformed it, and transferred it automatically.
Now I just open the sheet and everything is already there. No copying. No pasting. No typos.
Prompt:
I manually enter data from: [Source] into: [Destination]. Design an automation that extracts, validates, transforms, and transfers the data while minimizing manual intervention.
—
5. Automate Follow-Ups
This one saved me from looking unprofessional.
I had clients who would go silent after I sent proposals. I kept forgetting to follow up because I was too busy. This prompt designed an automated follow-up system that tracks due dates, sends reminders, and escalates overdue items.
I set it up using a simple CRM with email automation. Now, if a client does not respond in 3 days, they get a gentle reminder. In 7 days, they get a second one. In 14 days, my assistant gets notified to call them.
My response rate went up by 40%. And I did not have to remember a single thing.
Prompt:
I regularly need to follow up with people about: [Describe tasks]. Design an automated follow-up system that tracks due dates, sends reminders, identifies overdue items, and escalates when necessary.
—
6. Automate Daily Reports
I already mentioned my Monday report nightmare. This prompt fixed it.
I described the report I was creating—where the data came from, what calculations I was doing, who I was sending it to. The AI designed a workflow that collects the data automatically, performs the calculations, generates the report, and emails it to the relevant people.
I implemented it using Google Sheets and a simple script. Now I do not even think about that report anymore. It just shows up in my inbox.
Prompt:
Every day I manually create this report: [Describe report]. Design an automated workflow that collects the required data, performs calculations, generates the report, and sends it to the relevant people.
—
7. Automate File Management
If you receive tons of files every day, you know the chaos. Downloads folder full of random PDFs. Invoices mixed with contracts. No organization.
This prompt helped me set up automated file management. I described the files I receive—invoices, contracts, client documents—and the AI created rules for organizing, renaming, validating, processing, and archiving them.
Now every invoice I receive gets automatically renamed with the client name and date, sorted into the right folder, and logged in my tracking sheet. I never lose a file anymore.
Prompt:
I regularly receive and manage files like these: [Describe files]. Create an automation workflow that automatically organizes, renames, validates, processes, and archives these files. Include rules for handling duplicates and errors.
—
8. Automate Meeting Work
Meetings are necessary but the preparation and follow-up kill productivity.
I used this prompt to automate my entire meeting workflow. Before the meeting, the AI helps me prepare briefs. During the meeting, I take notes using Otter.ai. After the meeting, the automation extracts action items, assigns owners, sets deadlines, and sends follow-up reminders.
I cut my post-meeting admin work by 80%. No more manually typing meeting minutes or chasing people for updates.
Prompt:
I spend time preparing for and following up on meetings. Design an automated workflow that can prepare meeting briefs, capture notes, extract action items, assign owners, set deadlines, and send follow-up reminders.
—
9. Find the Highest-ROI Automation
This is the smart prompt. It stops you from automating things that do not matter.
I listed all my processes—everything I do regularly—and the AI estimated which ones would give me the biggest return if automated. It ranked them by frequency, time consumed, automation difficulty, error reduction, and business impact.
The top recommendation was automating my invoice processing. I was spending 2 hours a week on it. Now I spend 5 minutes. The second recommendation was client follow-ups. Both were high-impact automations that I would not have prioritized without this analysis.
Prompt:
Here are all the processes I currently perform: [Paste processes]. Estimate which processes would provide the highest return from automation. Rank them by frequency, time consumed, automation difficulty, error reduction, and business impact. Tell me which one I should automate first.
—
10. Build My Automation System
This is the big picture prompt. It ties everything together.
I gave the AI my job role, my regular responsibilities, and the tools I use. It analyzed my entire workflow and identified automation opportunities across the board. Then it created a prioritized roadmap showing what to automate first, what tools to use, and how each automation would improve my productivity.
I followed this roadmap for 3 months. By the end, I had automated over 15 hours of work every week. That is two full days back in my life. Every single week.
Prompt:
Act as a process automation consultant. My role: [Job Title]. My regular responsibilities: [List responsibilities]. My tools: [List tools]. Analyze my work and identify automation opportunities. Create a prioritized automation roadmap showing what I should automate first, what tools to use, and how each automation could improve my productivity.
—
A Quick Word Before You Go
Here is the honest truth. Automation does not have to be complicated. You do not need to be a programmer. You do not need expensive software.
Most of the automations I built started with a simple ChatGPT prompt. The AI designed the workflow. I figured out the implementation step by step. Some were as simple as Google Sheets formulas. Some used free no-code tools like Zapier or Make.
Start small. Pick one repetitive task. The one you hate the most. Run prompt number 9 to see if it is worth automating. Then run prompt number 1 or 2 to design the solution.
Within a month, you will have automated at least 5-10 hours of work. That is a life-changing amount of time.
I still run these prompts regularly. Every time I find myself doing something repetitive, I stop and ask: “Can I automate this?” More often than not, the answer is yes.
—
What is the one task you would love to automate? Drop it in the comments and I will help you think through the approach.