StepGleam logoStepGleam
Human-reviewed AI workflows

How to anything,with AI.

Practical workflows with real steps, copy-ready prompts, and sources that hold up.

7 guides · 38 steps · 13 copy-ready prompts

Clay illustration of a winding staircase leading to a colourful grid of tiles, a glowing star, and a speech bubble
See a real guide

Not a demo.
A finished workflow.

Every guide opens with an outcome, then walks you through the exact moves.

Open a sample guide
stepgleam.com/guides/clean-messy-excel-data
StepGleam guide page showing a step navigator, a copy-ready prompt, an example table, and a reliability score
Copy-ready prompts Progress saved Reliability 92/100
Explore by discipline

Pick a shelf.
Start with the mess.

Six disciplines, one calm library. More guides land every week.

How it works

Pick. Follow. Done.

No account wall, no autoplay video. Read it, copy the prompts, finish the task.

Pick a guide

Filter by discipline, level, or the tool already open on your desk.

Follow the steps

Copy each prompt, check the example, and mark your progress as you go.

Ship the thing

Leave with a finished workflow and a recipe you can repeat next week.

From the library

Fresh field notes.

Open the library
Illustration for Plan in Obsidian, build with Claude Code: the PRD-to-tasks loopCoding
Intermediate74

Plan in Obsidian, build with Claude Code: the PRD-to-tasks loop

How practitioners on r/hermesagent run projects: requirements and task lists in an Obsidian vault, small tasks handed to a coding agent, every diff reviewed by a human.

6 steps1 prompt
Illustration for Ship a feature with a coding agent: spec, tests first, then review the diffCoding
Intermediate78

Ship a feature with a coding agent: spec, tests first, then review the diff

The loop experienced developers describe on r/ExperiencedDevs: write the spec, plan the smallest steps, have tests written from the spec, implement, then review against the spec before anything merges.

6 steps2 prompts
Illustration for Review AI-written pull requests against an acceptance contractCoding
Beginner76

Review AI-written pull requests against an acceptance contract

A reviewer's method from r/ExperiencedDevs: a short scope contract at the top of the PR, the diff checked against it first, no extra behavior, plus Copilot code review as a first pass.

6 steps2 prompts
Illustration for Keep agent PRs small: one concern per branchCoding
Advanced70

Keep agent PRs small: one concern per branch

A developer's setup from r/ExperiencedDevs: the agent plans a feature into small chunks, writes the approved plan to the repo, and ships one stacked PR per concern.

4 steps2 prompts
Illustration for Clean a messy workbook: have Copilot flag issues, then decide yourselfExcel
Beginner72

Clean a messy workbook: have Copilot flag issues, then decide yourself

Use Copilot as an auditor rather than an autopilot. Ask it to flag anything that needs manual review on its own sheet, then fix the data with Excel features you control.

4 steps2 prompts
Illustration for Write complex Excel formulas with Copilot, then prove they workExcel
Intermediate80

Write complex Excel formulas with Copilot, then prove they work

How r/excel users actually use Copilot for formulas: describe each field, take the draft as a starting point, test it on awkward rows, and check every reference before filling down.

6 steps2 prompts
Illustration for Automate a recurring Excel report: deterministic Python, AI only for the fuzzy partsExcel
Advanced73

Automate a recurring Excel report: deterministic Python, AI only for the fuzzy parts

The pattern practitioners recommend on r/AI_Agents and r/automation: scripts for ingest, transform and validate, an OpenAI or Claude API call only for fields that need interpretation, and a hard stop when totals don't reconcile.

6 steps2 prompts
Contribute

Got a workflow?
Submit a guide.

If it saved you an afternoon, it can save someone else one too.

Submit a guide