Loading source
Pulling the file list, source metadata, and syntax-aware rendering for this listing.
Source from repo
Export Google Workspace directory contacts (names, emails, phones) to a Google Sheets spreadsheet.
Files
Skill
Size
Entrypoint
Format
Open file
Syntax-highlighted preview of this file as included in the skill package.
SKILL.md
1---2name: recipe-sync-contacts-to-sheet3description: "Export Google Contacts directory to a Google Sheets spreadsheet."4metadata:5version: 0.22.56openclaw:7category: "recipe"8domain: "productivity"9requires:10bins:11- gws12skills:13- gws-people14- gws-sheets15---1617# Export Google Contacts to Sheets1819> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-people`, `gws-sheets`2021Export Google Contacts directory to a Google Sheets spreadsheet.2223## Steps24251. List contacts: `gws people people listDirectoryPeople --params '{"readMask": "names,emailAddresses,phoneNumbers", "sources": ["DIRECTORY_SOURCE_TYPE_DOMAIN_PROFILE"], "pageSize": 100}' --format json`262. Create a sheet: `gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Name", "Email", "Phone"]'`273. Append each contact row: `gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Jane Doe", "[email protected]", "+1-555-0100"]'`2829