recipe-sync-contacts-to-sheet
googleworkspace/cli
Export Google Contacts directory to a Google Sheets spreadsheet.
What is recipe-sync-contacts-to-sheet?
This recipe syncs your Google Contacts directory into a Google Sheets spreadsheet. Use it to create a backup, share contact lists, or integrate contacts with other workflows.
- Lists all contacts from your Google Workspace domain directory
- Creates a new sheet with contact headers (Name, Email, Phone)
- Appends each contact as a row in the spreadsheet
- Supports up to 100 contacts per operation
- Extracts names, email addresses, and phone numbers
How to install recipe-sync-contacts-to-sheet
npx skills add null --skill recipe-sync-contacts-to-sheet- gws-people skill installed
- gws-sheets skill installed
- Google Workspace account with Contacts and Sheets access
- Target Google Sheets spreadsheet ID
How to use recipe-sync-contacts-to-sheet
- 1.Install the recipe and required skills (gws-people, gws-sheets)
- 2.Run the list contacts command to retrieve your directory with names, emails, and phone numbers
- 3.Create a new sheet with headers: Name, Email, Phone
- 4.Iterate through each contact and append their information as rows to the sheet
- 5.Verify the data in your Google Sheets spreadsheet
Use cases
- Back up your organization's contact directory to a spreadsheet
- Create a shared contact list for team reference
- Export contacts for use in mail merge or bulk communication tools
- Maintain an offline copy of your domain directory
- Prepare contact data for integration with other systems
- Google Workspace administrators
- Team leads managing contact lists
- Organizations needing contact backups
- Anyone automating contact management workflows
recipe-sync-contacts-to-sheet FAQ
The recipe exports names, email addresses, and phone numbers from your Google Workspace domain directory.
The default page size is 100 contacts per operation. For larger directories, you may need to paginate through results.
Yes, you can modify the readMask parameter in the list contacts command to include additional fields, and adjust the sheet headers and append values accordingly.
Yes, you need the spreadsheet ID of an existing Google Sheet where the contacts will be appended.
This recipe performs a one-time export. For ongoing synchronization, you would need to schedule the recipe to run periodically.
Full instructions (SKILL.md)
Source of truth, from googleworkspace/cli.
name: recipe-sync-contacts-to-sheet description: "Export Google Contacts directory to a Google Sheets spreadsheet." metadata: version: 0.22.5 openclaw: category: "recipe" domain: "productivity" requires: bins: - gws skills: - gws-people - gws-sheets
Export Google Contacts to Sheets
PREREQUISITE: Load the following skills to execute this recipe:
gws-people,gws-sheets
Export Google Contacts directory to a Google Sheets spreadsheet.
Steps
- List contacts:
gws people people listDirectoryPeople --params '{"readMask": "names,emailAddresses,phoneNumbers", "sources": ["DIRECTORY_SOURCE_TYPE_DOMAIN_PROFILE"], "pageSize": 100}' --format json - Create a sheet:
gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Name", "Email", "Phone"]' - Append each contact row:
gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Jane Doe", "jane@company.com", "+1-555-0100"]'
Related skills
More from googleworkspace/cli and the wider catalog.
gws-gmail
Send, read, and manage Gmail emails via Google Workspace CLI.
gws-drive
Manage Google Drive files, folders, and shared drives via CLI.
gws-docs
Read and write Google Docs via command line.
gws-calendar
Manage Google Calendar events, calendars, and access control via CLI.
gws-sheets
Read and write Google Sheets spreadsheets via CLI.
gws-gmail-send
Send emails via Gmail with attachments, CC/BCC, HTML support, and draft options.