Skip to article

How Does an AI Agent List Renewals With the Risk Signs I Named?

Build an AI agent in Gumloop that reads your account notes and renewals sheet and lists the renewals showing the signs you wrote, with the note behind it.

By Jacqueline V. TwillieNovember 9, 20266 min readGuide
Quick answer

Keep the renewals on one tab and the notes on another, then build an AI agent in Gumloop that lists the upcoming renewals whose notes show the signs you wrote, each with the note behind it, plus the accounts with no notes. Its instructions tell it to score nothing, rank nothing and contact no customer.

Deciding which accounts get a call before the renewal date means rereading the notes on each account.

This AI agent reads the renewals sheet and the notes and hands you a list. It looks for the signs you write and shows you the note behind each one.

Who decides what counts as a sign?

You do, before you build anything. Write each sign as a sentence a note could contain: a champion who went quiet, usage your team logged as falling, an open complaint.

You connect no usage data and no support system. It reads what your team wrote down, so a sign they don't record won't show up.

A sign counts only when a note or a row says it in so many words.

Each run sorts the upcoming renewals into three groups: accounts that show a sign, with the note behind it; accounts whose notes were read and show none of your signs; and accounts with no notes in the workbook. An account with no notes in the workbook is either quiet or keeps its notes somewhere else.

What do you paste into the instructions for the renewal risk list?

Copy and fill in
You build my renewal risk list. I'm the [YOUR ROLE] at [YOUR COMPANY], and my team owns the accounts on my renewals sheet: [SHEET NAME OR LINK].
Today's date is [TODAY'S DATE]. List the accounts whose renewal falls within [RENEWAL WINDOW] of that date, in the order of their renewal dates. Read only the renewals sheet and the account notes in it. Never look anything up on the web.
I define the signs, and you score nothing. A sign counts only when a note or a row says it in so many words. My signs are [SIGN ONE], [SIGN TWO] and [SIGN THREE].
For each account that shows a sign, give the account name, the renewal date, the sign, and the note or row behind it. Show the account name and the date of the note as the sheet has them, and quote the words exactly. If a note only hints at a sign, leave it out.
Give two more groups. Accounts with notes and none of my signs get the label "notes read, no sign found". Accounts with no notes at all get the label "no notes".
Don't rank the accounts, don't predict who will leave and don't suggest what to say. You contact nobody and you never change the sheet. I decide who gets a call before the renewal date.

How do you build the renewal risk list in Gumloop?

  1. 01

    Make the account names match on both tabs.

    Keep the renewals on one tab and the notes on another, in the same workbook. A name written two ways can read as an account with no notes.

  2. 02

    Connect Google Sheets, and only Google Sheets.

    Open Gumloop, start a new AI agent and say the job in one sentence: list the upcoming renewals that show the signs I name, from my sheet. Open Connectors on the tab named Agent, click Add, search for Google Sheets and sign in. Then click the approval icon beside it and change Always allow to Ask for writes/deletes. Which tools the connector offers isn't in the documentation, so open it in your account and read them. Checked on 2026-11-11 against the guided setup section of Gumloop's AI agent builder page, against Gumloop's connector help page, which names Google Sheets among the built-in connectors, and against Human in the loop, which lists Always allow as the default approval mode.

  3. 03

    Turn off web search, web fetch and the browser, then paste the block and press Save.

    In the Abilities section, turn off Web Search and Web Fetch, and in the Browser section switch the Browser toggle off if it's on. Paste the block above into the instructions, fill in the brackets, and press Save. Read Can I Use an AI Agent at Work When My Company Restricts the Data I Can Connect? before you connect the real sheet. Checked on 2026-11-11 against the abilities table on Gumloop's AI agent builder page and against Gumloop's AI agent browser page, which says the browser starts turned on for new custom AI agents when the creator is allowed to use it.

  4. 04

    Keep the signs in your wording.

    Edit Own Instructions sits below the instructions box. Turn it off and press Save. Change the block yourself when a sign changes. If Reflections is on, open Performance in the sidebar and set Apply Suggestions to Review Queue in the Reflections settings, so a suggested change to the block waits for you. Checked on 2026-11-11 against the self-improving instructions section of Gumloop's AI agent builder page and against Gumloop's Reflections page.

  5. 05

    Check one account whose story you know.

    Pick a renewal you remember and set today's date to a day before it. Start the task by hand and read what the AI agent says about that account against what you remember.

I am an ambassador for Gumloop. Code SISSUMMIT2026 takes 20% off your first month.

Which entries do you check against the sheet before anyone calls?

Search the sheet for the words in three quoted notes. A quote you can't find was reworded, so don't act on that list yet.

Open every account listed under no notes. One that has notes on the sheet points to a name spelled two ways, and the sheet is what you fix.

Find an account you know has a problem. If it sits under notes read, no sign found, your team may word it differently from your sign, and their wording belongs in the block. After the calls, the renewal call debrief AI agent drafts the record from your notes.

Frequently asked questions

What does "notes read, no sign found" tell me?

That the notes didn't say any of your signs in so many words. It doesn't mean the account is safe.

Can it tell me which account is most likely to leave?

Not with this block. You wrote the signs, the block tells it to score nothing, and the accounts should come back in renewal-date order.

Why does it quote the note instead of summarizing it?

So you can search the sheet for the exact words. The documentation doesn't list whether the connector returns row numbers, so the build doesn't rely on them.

More on Domain Expertise for Corporate Executives