recipe-sync-contacts-to-sheet
Export Google Contacts directory to a Google Sheets spreadsheet.
Best for Google Workspace administra…Works with GitHubLow risk
⌘source
- author
@googleworkspace- language
- Rust
★25kstars
1.3kforks
Apr 22, 2026
✦overview.md
Key Features
- ·Exports Google Contacts directory to Google Sheets
- ·Uses gws CLI tools for Google Workspace
- ·Specifies required readMask fields (names, emailAddresses, phoneNumbers)
- ·Creates structured spreadsheet with headers
- ·Appends contacts as individual rows
Use Cases
- →Creating a backup of company contact directory in spreadsheet format
- →Migrating Google Contacts data to another system via CSV export
- →Generating a clean contact list for email marketing campaigns
- →Auditing employee contact information across the organization
Best for
- ✓Google Workspace administrators
- ✓Data migration projects
- ✓Contact management workflows
Not ideal for
- !Real-time contact synchronization
- !Individual personal contact management
- !Non-Google Workspace environments
FAQs
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"]'
$install
1-click copynpx skills add googleworkspace/cli --skill recipe-sync-contacts-to-sheetSafety assessment
★
Clarity score
How clear and easy to understand the SKILL.md instructions are, rated from 1 to 5.
5/ 5
excellentVery clear and well structured, with almost no room for misunderstanding.
◎
Actionability score
How directly an agent can act on the SKILL.md instructions, rated from 1 to 5.
5/ 5
very highHighly actionable with clear, concrete steps that an agent can follow directly.