Export Contacts to Sheets
Copy your Google Workspace directory contacts into a Google Sheet via the gws CLI.
- Repository
- googleworkspace/cli
- Stars
- 32,059
- Licence
- Apache-2.0
- Files
- 1 file
What it does
This skill gives an AI agent a step-by-step recipe for exporting people from your Google Workspace domain directory (names, email addresses and phone numbers) into a Google Sheets spreadsheet. It relies on the gws command-line tool to read the directory and write rows to the sheet, so the agent can do the copying for you instead of you exporting by hand. It is a short recipe that depends on two other skills, gws-people and gws-sheets, being loaded too.
Great for
- Workspace admins who want a quick snapshot of the company directory in a spreadsheet
- Operations staff building a shared contact list for a team or event
- People who already use the gws CLI and want a repeatable export
Skip it if
- Personal Google Contacts, since the recipe reads the domain directory source, not your own contacts list
- Anyone handling sensitive staff data who has not checked sharing settings on the target sheet, because it copies personal details like emails and phone numbers into a file that others may be able to open
- Large directories, since the recipe fetches only one page of 100 people and does not show how to loop through further pages
Try asking
- “Export our Google Workspace directory names, emails and phone numbers into a new Google Sheet”
- “Make a spreadsheet of all company contacts with their email addresses”
- “Create a Contacts tab with name, email and phone columns from the domain directory”
Install in 3 steps
- 1
Download the skill
The ZIP contains the 1 original files, the Apache-2.0 licence and an attribution note.
recipe-sync-contacts-to-sheet.zip - 2
Add it to your agent
Claude Code (all projects)
mkdir -p ~/.claude/skills && unzip recipe-sync-contacts-to-sheet.zip -d ~/.claude/skills/Claude Code / Agent SDK (this project only)
mkdir -p .claude/skills && unzip recipe-sync-contacts-to-sheet.zip -d .claude/skills/Claude apps (web/desktop): Settings → Capabilities → Skills → Upload skill, and choose the ZIP.
- 3
Ask for the task
No special command needed — the agent reads the skill's description and loads it when your request matches. Try one of the prompts above.
Get better results
- Replace SHEET_ID with a real spreadsheet you own, and check who it is shared with before running, since it will contain personal contact details
- Expect the recipe to write only the first 100 directory entries; ask the agent to page through results if you need everyone
- Run the commands once on a test sheet first to confirm the column layout matches what you expect
What's inside
- SKILL.md
Redistributed unmodified from googleworkspace/cli under the Apache-2.0 licence. The assessment was drafted with AI from the skill's files on 2026-10-29. Skills can instruct your agent to run code — read SKILL.md and any scripts before installing.