# 1. Manual ways to create categories in Google Sheets### 1.1 Build a master category list1. Open your Google Sheet.2. Create a dedicated tab called `Categories`.3. In column A, list your main categories (e.g. `Lead Source`, `Channel`, `Status`).4. In column B, list the allowed values for each (e.g. for `Channel`: `Facebook Ads`, `Google Ads`, `Email`, `Referral`).5. Keep this tab as your single source of truth so the whole team tags data consistently.This mirrors the advice in Google’s own docs: keep your validation ranges separate from the raw data for easier maintenance. See the dropdown help here: https://support.google.com/docs/answer/186103### 1.2 Use Data validation dropdowns1. Go to the sheet that holds your raw data (e.g. `Deals`).2. Select the column you want to categorize, such as `Deals!C2:C` for “Channel”.3. Click **Data → Data validation**.4. Under **Criteria**, choose **Dropdown from a range**.5. Point it to your category list, for example `Categories!B2:B10`.6. Click **Done**.Now every row has a consistent dropdown. Reps can only choose from your approved categories, which prevents typos like `Gooogle Ads`.Official reference: https://support.google.com/docs/answer/186103### 1.3 Use inline dropdown chips (the @ menu)1. Click in a cell where you want a quick category.2. Type `@` and choose **Dropdowns**.3. Configure options like `Hot`, `Warm`, `Cold` for lead temperature.4. Reuse the same preset across the sheet.Great for small teams or simple statuses where you don’t yet need a full category tab.### 1.4 Color‑code categories with Conditional formatting1. Select the categorized column (e.g. `Status`).2. Click **Format → Conditional formatting**.3. Add rules like: * If text is exactly `Closed Won`, background green. * If text is exactly `Closed Lost`, background red.4. Click **Done**.This makes categories visually scannable in seconds.### 1.5 Use Filter views to analyze by category1. Click anywhere in your data table.2. Go to **Data → Filter views → Create new filter view**.3. In the header of your category column, click the filter icon.4. Check only the categories you want to see (e.g. only `Google Ads`).5. Save the view as `By Channel – Google Ads`.Now you can switch between saved views without breaking someone else’s filter.---# 2. No‑code automation for categoriesOnce you’re comfortable with manual dropdowns, you can bring in simple automation tools (Zapier, Make, or native integrations) to pre‑fill categories instead of asking humans to touch every row.### 2.1 Auto‑categorize on import from forms or CRMsUse a form or CRM field to drive categories:1. In your CRM or form (HubSpot, Typeform, etc.), add fields that map cleanly to your Google Sheets categories (e.g. `UTM Source`, `Industry`).2. Use a no‑code tool (e.g. Zapier) to push submissions into Google Sheets.3. In the Zap, map the source field directly into the categorized column.4. Because the values match your dropdown list in `Categories`, Sheets will accept them and keep data clean.Result: 80–90% of rows arrive already categorized.### 2.2 Rule‑based categorization with helper columnsIf you don’t want external tools, you can still automate inside Sheets using formulas:1. Add a helper column next to your “Description” column (e.g. for bank or ad transactions).2. Use nested `IFS` or `REGEXMATCH` to detect keywords: * Example: `=IFS(REGEXMATCH(D2, "(?i)facebook|meta"), "Facebook Ads", REGEXMATCH(D2, "(?i)google ads|adwords"), "Google Ads", TRUE, "Other")`3. Apply data validation on that helper column so only known labels are allowed.This mirrors approaches shared on Stack Exchange for auto‑categorizing transactions based on text.### 2.3 Use ARRAYFORMULA for continuous auto‑fill1. In the header row of your category column, insert an `ARRAYFORMULA` that applies your logic to the whole column: * Example: `=ARRAYFORMULA(IF(ROW(D2:D)=1, "Channel", IFS(LEN(D2:D)=0, "", REGEXMATCH(D2:D, "(?i)google"), "Google Ads", TRUE, "Other")))`2. New rows are categorized automatically as they are added.Pros: stays inside Google Sheets, no external tools.Cons: formulas can become complex and harder for non‑technical teammates to maintain.---# 3. Scaling categories with an AI agentManual and no‑code methods work until volume explodes. When you’ve got thousands of rows streaming in weekly, you want an AI computer agent that behaves like a power‑user living inside your desktop.## 3.1 Agent method: Desktop‑level categorization**How it works**- You define a simple playbook: which sheet, which columns, what your categories mean.- The AI agent opens Google Sheets in your browser, scrolls, reads descriptions, and applies categories using the same menus you would: **Data → Data validation**, dropdowns, and formulas.**Pros**- Works across your entire desktop, not limited to one app or API.- Follows your exact UI steps; every click is visible and auditable.- Easy to tweak – you can edit the agent’s actions like you’d edit a macro.**Cons**- Requires a short setup session to “teach” the agent your business rules.Useful links to reference while designing the workflow:- Google dropdown docs: https://support.google.com/docs/answer/186103- Simular Pro overview (for advanced desktop agents): https://www.simular.ai/simular-pro## 3.2 Agent method: Keyword learning for recurring dataFor recurring inputs like bank transactions, ad exports, or CRM logs:1. Create a training sheet with three columns: `Raw Text`, `Expected Category`, `Notes`.2. Have the AI agent read this sheet to learn patterns (e.g. `"Debit Google ADS" → Advertising`).3. On a schedule, the agent: - Downloads the latest CSV from your bank or ad platform. - Pastes it into Google Sheets. - Scans each row’s description. - Suggests a category based on learned patterns. - Applies the closest matching dropdown value.**Pros**- Learns your domain language (campaign codes, product names, vendors).- Keeps human‑reviewed control: you can spot‑check in Sheets and adjust.**Cons**- Needs an initial “teaching” pass where you correct a few early guesses.## 3.3 Agent method: End‑to‑end reportingFinally, you can let the AI agent not only categorize but also:- Create new categories when the business evolves (e.g. a new ad network).- Update validation ranges in your `Categories` tab.- Build or refresh pivot tables by category.- Export summary reports or dashboards.This is where Google Sheets becomes a living database rather than a static grid, and the AI agent becomes your tireless operations analyst.**Pros**- Massive time savings for founders, sales leaders, and ops teams.- Consistent, always‑up‑to‑date views by category.**Cons**- You need to invest an hour up front to define the “source of truth” for categories and sign off the first run.

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5

Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

1. Item 1
2. Item 2
3. Item 3

Unordered list

• Item A
• Item B
• Item C

Text link

Bold text

Emphasis

^Superscript

_Subscript