All AI use cases AI agent use cases

Get the next AI workflow before anyone else

My newest AI workflows and skills, the day they drop. Tested in my own business. Free.

Free. A few emails a week. Unsubscribe anytime.

Put your business on autopilot

Get every new inquiry logged in your tracker with its own folder

Months later, every lead you ever got sits in one sheet, with a folder ready the moment they say yes.

About 20 minutes to set up, then a minute per inquiry to check Advanced

Published . Updated . Steps as of October 2026.

How do I automatically log new client inquiries from Gmail?

Create a Client Tracker sheet with name, email, need, date, source and status columns. Open Gemini, click Task below the text box (as of October 2026) and paste the prompt. Approve the access it asks for and test it on one past inquiry. If it works, tell Gemini to run it each time a form email arrives. Check new rows weekly and fix anything marked 'check'.

A sketch of what you'll get back.

Your prompt

Fill in your details. Skip any you like.

This AI can't be filled in from a link, so the button copies your prompt: paste it into the new chat.

The prompt that gets copied

Each time a new client inquiry arrives in my Gmail (emails from [WHERE INQUIRIES COME FROM, e.g. my website contact form]), do this:

1. Read the email and pull out the person's name, email, phone if given, what they're asking for, any dates they mention and how they found me.
2. Add one row to my Google Sheet [TRACKER NAME, e.g. Client Tracker] with those details, today's date and the status 'New'. If they're already in the sheet, update their row instead of adding a new one.
3. Create a Google Drive folder named after them inside my folder [PARENT FOLDER, e.g. Clients] and put its link in the row.
4. Rate the fit against my ideal client, [YOUR IDEAL CLIENT, e.g. busy practice owners], as strong, maybe or poor, with one line on why.

If anything is unclear, write 'check' instead of guessing. Don't reply to anyone, share the folder or delete any email.

Set a Gemini task that watches Gmail for new inquiries. Each one gets a row in your client sheet with their name, need and dates, plus its own Drive folder, so your tracker builds itself.

Step by step

  1. Create a Google Sheet called Client Tracker with name, email, need, date, source and status columns.
  2. Open Gemini, click Task below the text box, and paste the prompt with your details.
  3. Approve the Gmail, Sheets and Drive access it asks for, then test it on one past inquiry.
  4. Tell Gemini to run it each time an email from your contact form or booking page arrives.
  5. Check new rows each week and fix anything marked 'check' before you reach out.

What you'll get

A client tracker that fills itself as inquiries arrive, with a fit rating and a ready Drive folder for each person, and nothing sent without you.

Needs Google AI Pro or Ultra on a personal Google account, with Personal Intelligence on. Not in every country yet.

Made for
Coaches, Consultants, Creators, Small business owners
Works in
Gemini, Gmail

Frequently Asked Questions.

How do I automatically log new client inquiries from Gmail?

Create a Client Tracker sheet with name, email, need, date, source and status columns. Open Gemini, click Task below the text box (as of October 2026) and paste the prompt. Approve the access it asks for and test it on one past inquiry. If it works, tell Gemini to run it each time a form email arrives. Check new rows weekly and fix anything marked 'check'.

Which AI tools does this work in?

It works in Gemini and Gmail. On this page, one tap copies the prompt and opens the app, so you just paste. Needs Google AI Pro or Ultra on a personal Google account, with Personal Intelligence on. Not in every country yet.

How long does it take?

About 20 minutes to set up, then a minute per inquiry to check. It's rated "Advanced". There are 5 steps, listed above.

What do I need before I start?

Just your details for 4 blanks: where inquiries come from, tracker name, parent folder and your ideal client. You can skip any, and your AI will ask for them.

What will I get back?

A client tracker that fills itself as inquiries arrive, with a fit rating and a ready Drive folder for each person, and nothing sent without you.

Find more like this in AI agent use cases, For content creators, For small business and For coaches.

More ways to put your business on autopilot.

See all 70 ways to put your business on autopilot

Get the next AI workflow before anyone else

My newest AI workflows and skills, the day they drop. Tested in my own business. Free.

A few emails a week from Ronnie. Unsubscribe anytime.

You're in. The next drop comes straight to your inbox.