# 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.

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.

- Page: https://thesolocreators.com/prompts/new-inquiries-logged-with-their-own-folder/
- Category: Put your business on autopilot
- Made for: Coaches, Consultants, Creators, Small business owners
- Works in: Gemini, Gmail
- Time: About 20 minutes to set up, then a minute per inquiry to check
- Effort: Advanced
- Note: Needs Google AI Pro or Ultra on a personal Google account, with Personal Intelligence on. Not in every country yet.

## The prompt

Fill in the parts in [square brackets], or leave them and the AI will ask you for them.

```text
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.
```

## 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.

## Good to know

**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.

Idea spotted on the web, shared by Erin Carson (Engadget): https://www.engadget.com/2281539/how-to-use-google-gemini-automate-tasks/. The prompt is The Solo Creators' own version.

## Go further

Ready-made skills in the Solo Creators AI Studio (https://thesolocreators.com/studio/) that fit this: Second Brain (Give your AI a memory it reads across every project, so it finally knows your business); Watch It For Me (Drop any video link and get the step-by-step playbook, the full timestamped transcript, and the best quotes. Without watching it).

From AI Use Cases and Prompts by The Solo Creators: https://thesolocreators.com/prompts/. Free to use; please link back to the page when you share it.