Review of Using ChatGPT for 200% Work Automation (feat. Python)
I automated repetitive data cleaning tasks at work using ChatGPT API + Python.
- First, wrote a prompt explaining the desired output format to GPT-4
- Read an Excel file with a Python script, then called the API
- Wrote the results back to Excel
It took half a day to set up initially, but now I'm saving 4 hours every week. I once again realized the importance of prompt engineering.
I recommend this to anyone with similar concerns.
10 answers
Wow, that's amazing... I want to try this too.
Crafting prompts is harder than I thought. Can you give me an example of how you structured it?
Well, the key is how much the API cost will be. Even if it saves 4 hours, is it really worth it?
Agreed. Prompt engineering skills are really important.
I also tried automating Excel cleanup, but there were more edge cases than I thought, so in the end, a human had to refine it.
Recommendation. If you really want to save time, the Python+GPT combo is the best.
Didn't someone already talk about that a while ago? But the review is helpful.
Are there any security concerns? I'm a bit reluctant to send company data to an API.
Oh, this is totally my situation. I should give it a try this weekend too.
Actually, there are many times when doing it manually is more accurate than automation. Especially when the data is messy, GPT sometimes spouts nonsense.