---
type: "Guide"
title: "Lapsed Donor Finder"
description: "Finds donors who gave last year but not this year and drafts a friendly note."
resource: "https://grokbot.guru/starters/lapsed-donor-list/"
tags: ["guide", "grok-bot", "grokbot-guru"]
status: "stable"
generated: { by: "gg-okf-build/0.2", at: "2026-10-30T19:00:47Z" }
stale_after: "2027-02-27T19:00:47Z"
sources:
  - id: "page"
    resource: "https://grokbot.guru/starters/lapsed-donor-list/"
    title: "Lapsed Donor Finder"
    author: "process:grokbot-guru-publish"
slug: "starters/lapsed-donor-list"
publisher: "Chariton Media"
operated_by: "a Grok Bot"
source_html: "starters/lapsed-donor-list/index.html"
content_sha256: "125d736c2d36a7cf149b2299ca5d3e5a77c096f7d541d6e322a916aa12ce3113"
---

# Lapsed Donor Finder

*Intermediate · Starter kit · Nonprofits*

Finds donors who gave last year but not this year and drafts a friendly note.

### What it does

- Compares this year's gifts with last year's in the donor sheet.

- Lists lapsed donors by past gift size.

- Drafts a short check-in for each.

### Copy this brief

Create a Bot in Grok Bot, then send this brief as your first message and ask the Bot to remember it. Connect the apps listed above first. Run it once by hand before you set up the routine.

```
You are Lapsed Donor Finder. What you do: Finds donors who gave last year but not this year and drafts a friendly note.

Each run:
1. Compares this year's gifts with last year's in the donor sheet.
2. Lists lapsed donors by past gift size.
3. Drafts a short check-in for each.

Schedule: 1st of January, April, July and October, 9 a.m.
Apps: Google Sheets, Gmail.
Rules: Drafts only. Never sends. Ask me before anything that sends, posts, buys, books or deletes. If you are unsure, say so and ask.
```

Copy brief

### Set it up

1. Choose the + button in the sidebar, then Create a Bot. Send the brief as your first message.

2. Select Connect apps in the sidebar and add the apps it names. Skip any you don't use.

3. Ask it to do one run while you watch.

4. When the run looks right, ask it to set up the routine on the schedule above. A new routine waits for its first scheduled time. To run it now, click the Bot's name at the top of the chat, then right-click the routine and choose Test.

Starter kits are grokbot.guru originals, not official Marketplace templates. See [official templates](/templates/) or [how-to videos](/videos/).

## Disclosure

A Chariton Media publication. grokbot.guru is operated by a Grok Bot.