People chips in Google Sheets turn a plain email address or name into a clickable, interactive tag that links to a person’s contact info. You can mention someone, see their profile, and quickly email them—all without leaving your spreadsheet. This guide covers how to insert, use, and manage people chips, plus common pitfalls.
What You’ll Need
- A Google account (personal or Workspace)
- A Google Sheet with at least one cell containing an email address or a person’s name
- For full functionality (profile cards, quick actions), you need to be signed in to the same Google account that has the contact, or the person must be in your organization’s directory (for Workspace).
Step-by-Step
- Open your Google Sheet in a browser (Chrome, Firefox, Safari, or Edge). Make sure you’re signed in to your Google account.
- Type or paste an email address into a cell. For example, type
sarah@example.comand press Enter. - Convert the text to a people chip in one of these ways:
- Right-click the cell, then choose View more cell actions > Insert people chip.
- Or, click the cell, then go to the menu Insert > Dropdown > People chip (this works if you already have an email in the cell).
- Or, type
@in the cell and start typing the person’s name or email. A suggestion list appears—click the correct person.
- Verify the chip – Once inserted, the cell shows a blue pill with the person’s name (or email if no name is found). A small avatar icon appears on the left.
- Use the chip – Click on the chip once. A popup appears with the person’s profile picture, email, and quick actions like “Send email” or “View profile”. Clicking the chip also lets you copy the email or open the person’s contact card.
- Mention someone in a comment – To notify someone, type
@in a cell comment (right-click cell > Comment, or press Ctrl+Alt+M). Then type their name or email and select them from the list. They’ll get an email notification with a link to the sheet. - Remove or change a chip – To remove the chip and keep only the email text, right-click the chip and choose Remove people chip. To change the person, delete the chip and re-insert a new one.
- Copy and paste chips – You can copy a cell with a chip and paste it elsewhere. The chip remains active. If you paste into a different sheet or document, it may convert to plain text depending on the destination.
Common Mistakes
- Typing an email but not converting it – Simply typing an email does not create a chip. You must explicitly insert it via the right-click menu or the @ mention.
- Using a non-Google email – People chips work best with Google accounts. If the email belongs to a non-Google service (e.g., Outlook), the chip may show only the email and not a profile card.
- Expecting the chip to update automatically – If the person changes their name or email, the chip does not auto-update. You’ll need to re-insert it.
- Mentioning someone in a cell instead of a comment – Typing @ in a cell creates a dropdown or chip, but it does not send a notification. To notify, you must use the comment feature.
Tips
- Use people chips for task assignments – In a project tracker, add a people chip in a “Owner” column. This makes it easy to see who’s responsible and quickly email them.
- Combine with data validation – For a column that should only contain people chips, you can use data validation with a list of emails, but the chip will only appear if you manually insert it. There’s no native way to force a chip via validation.
- Keyboard shortcut – Press
@in a cell to quickly bring up the smart chip menu, then type the person’s name. - Check permissions – For people in your organization, the chip shows their directory profile. For external contacts, it shows what’s in your Google Contacts.
- Use in Google Workspace – If you’re on a Workspace account, people chips can also show presence (if the person is online) and allow you to start a chat directly from the sheet.
Troubleshooting
- Chip doesn’t appear after right-click – Make sure the cell contains a plain email address (no extra spaces or formatting). If it’s a name, the system may not recognize it. Try typing the full email and then converting.
- The chip shows “Unknown” or just the email – This usually means the email is not associated with a Google account or the person is not in your contacts. Double-check the email for typos, or ask the person to share their Google account email.
- @ doesn’t bring up suggestions – Ensure you’re typing in a cell (not in the formula bar). Also, if you’re offline, suggestions may not load. Check your internet connection.
- Mention in comments doesn’t notify – The person must have access to the sheet (viewer, commenter, or editor). If they don’t, they won’t receive the notification. Also, the email must be a Google account.
- Can’t remove a chip – Right-click the chip and select “Remove people chip”. If that doesn’t work, try clearing the cell (Delete key) and re-entering the text.
Frequently Asked Questions
- Can I use people chips with non-Google emails? – Yes, but they will only show the email address as a plain chip, without a profile card or quick actions. It’s best to use Google accounts for full functionality.
- Do people chips work on mobile? – Yes, in the Google Sheets mobile app, you can tap the chip to see the person’s email and some actions, but you cannot create a new chip from scratch easily. It’s easier to create them on desktop.
- Can I convert an existing column of emails into chips? – There’s no one-click bulk conversion. You’d have to manually convert each cell. A workaround is to use a script (Google Apps Script) to loop through cells and insert chips, but that requires coding knowledge.
- What happens if I share the sheet with someone else? – People chips are visible to anyone with access. They can click the chip and see the person’s email, but they won’t see the profile card unless they have permission to view that contact.
- Can I use people chips in Google Docs or Slides? – Yes, the same @ mention works in Docs and Slides, but the chip behavior may differ slightly. In Docs, you can hover over the chip to see the profile.
- Why does the chip show a name I don’t recognize? – Google may be pulling the name from your contacts or the person’s Google profile. If it’s wrong, you can remove the chip and re-insert it, or edit the contact in your Google Contacts.
Related
General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.
More in this bed
- Fix Apps Not Downloading From Play Store
- Secure a Samsung Galaxy After a Zero-Day Disclosure
- What to Check Before Installing Linux Alongside Windows
- Fix OEM Activation Error 0xc004c060 in Windows 10
- Why Does My App Run One Query for the List and One per Item?
- Fix Google Chrome Has Stopped Working