Core How-Tos
Share one list with a Google Sheet
Keep the list in a Google Sheet and everyone who connects the same sheet sees the same people. Each tab in the workbook is a team, named after the tab, with one person per row. The sheet is only read, never changed.
Set up the sheet
- On each tab, give the first row the headings Name and City (or Time zone).
- Add one person per row.
- Share the sheet so anyone with the link can view it, or make sure the people who use it are signed in to Google in their browser with an account that can open it.
Connect it
- Open Settings → People.
- Under Google Sheets, paste the sheet's address into Sheet link and press Connect.
- The card says how many people and teams it read. Each connected sheet has Open and Remove.
Connect more than one sheet (up to 10) and their people show together: tabs with the same name in two sheets are one team. A new install starts with a built-in sample sheet of made-up people; remove it here when you connect your own.
The columns
Columns are found by their heading, so they can be in any order, and any column you don't need can be left out or left empty.
- Name (required): who the row is. The tab's name is their team.
- City or Time zone (one of the two): their local time. A city also gives the weather there.
- State, Country (optional): they pick the right city when several share a name, and the map icon opens on the closest thing given.
- Email (recommended): the mail and calendar icons for each person and each group, and copying addresses.
- Company, Title, Role Here (optional): shown under each name, and the company and role filters. Role Here is what they do in that tab's team when their title doesn't say.
- Website (optional): a small icon linking to each site. Several addresses can share the cell.
- Start, End (optional, use sparingly): working hours for someone whose day really is different.
- Working days (optional, use sparingly): for a week that isn't the usual one, such as Sun-Thu.
Settings → How It Works has the same table inside the extension.
When it syncs
Your browser reads the sheet from Google when the panel opens and again on the schedule under Sync every: 15, 30 or 60 minutes. Sync now, in Settings or in the panel's header, reads it straight away.
Someone without a city
A row with no city or time zone still appears in the panel, marked No city or time zone in the sheet yet, with an Add it link straight to the cell that needs filling in.
Keep it easy to look after
- Prefer a city or a named time zone to an offset. London or Europe/London follows daylight saving by itself; UTC+1 doesn't, and will be an hour out for half the year.
- Fill in Start, End and Working days only for hours that are different for good. Leave holidays, leave and one-off changes to the calendar.
- Add the Email column early: it's what turns a likely time into a checked one.
A sheet shows up to 200 people, from up to 30 tabs.
Related guides
Next, read Add people and teams, Email, schedule and map icons or Troubleshoot common issues.