StepGleam logoStepGleam
The library

Open the library.

Visual, human-reviewed AI workflows. Filter by level or the tool already open on your desk.

Guides

Illustration for Combine monthly files with Power Query, using an LLM one step at a timeExcel
ExcelIntermediate40 min

Combine monthly files with Power Query, using an LLM one step at a time

Point Power Query at a folder of same-shaped files, then use ChatGPT or Copilot only to write or explain individual M steps, testing each one before adding the next.

Illustration for Turn a recorded macro into reusable VBA with ChatGPT, then test it on a copyExcel
ExcelIntermediate45 min

Turn a recorded macro into reusable VBA with ChatGPT, then test it on a copy

Record the task, have ChatGPT clean up and comment the code and make the ranges dynamic, then compile, step through and test it on a copy before it touches real data.

Illustration for Run a Python analysis in Excel with Copilot's Advanced AnalysisExcel
ExcelIntermediate35 min

Run a Python analysis in Excel with Copilot's Advanced Analysis

Put the data in a Table in a cloud-saved workbook, start Advanced Analysis in Copilot, let it write Python cells, and read each one before you reuse the code.

Illustration for Make a coding agent write the failing tests first, then implementCoding
CodingIntermediate30 min

Make a coding agent write the failing tests first, then implement

Split the work into separate prompts: tests only, confirm they fail for the right reason, commit, then implement without touching the tests.

Illustration for Set up Claude Code hooks for formatting, tests and protected filesCoding
CodingIntermediate30 min

Set up Claude Code hooks for formatting, tests and protected files

Add PostToolUse hooks that format and test after edits, a PreToolUse hook that blocks protected files, and a notification for long runs.

Illustration for Debug with an agent: reproduce, hypothesise, log, then fixCoding
CodingIntermediate30 min

Debug with an agent: reproduce, hypothesise, log, then fix

Don't just ask the agent to fix it. Make it reproduce the bug, state a testable hypothesis, prove the root cause with logging or a failing test, and only then change code.

Illustration for Write Cursor project rules that actually load when you need themCoding
CodingIntermediate25 min

Write Cursor project rules that actually load when you need them

Put rules in .cursor/rules as .mdc files, set alwaysApply, globs and the description on purpose, and test that the agent picks each rule up.

Illustration for Get a second-opinion review from a fresh session or another modelCoding
CodingIntermediate20 min

Get a second-opinion review from a fresh session or another model

Review the agent's diff in a session that didn't write it, either a fresh Claude Code session or Codex on the PR, and act only on findings that affect correctness.

Illustration for Plan in Obsidian, build with Claude Code: the PRD-to-tasks loopCoding
CodingIntermediate45 min

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.

Illustration for Ship a feature with a coding agent: spec, tests first, then review the diffCoding
CodingIntermediate60 min

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.

Illustration for Write complex Excel formulas with Copilot, then prove they workExcel
ExcelIntermediate30 min

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.