Source from repo

Export Google Contacts to Sheets

Export Google Workspace directory contacts (names, emails, phones) to a Google Sheets spreadsheet.

googleworkspaceGitHub googleworkspaceSource repo Original GitHub link Publisher page

Files

Skill

n/a

Size

995 B

Entrypoint

SKILL.md

Format

git-repo

Open file

SKILL.md

Syntax-highlighted preview of this file as included in the skill package.

Rendered Source

markdown29 linesEntrypointFree

SKILL.md

1---
2name: recipe-sync-contacts-to-sheet
3description: "Export Google Contacts directory to a Google Sheets spreadsheet."
4metadata:
5  version: 0.22.5
6  openclaw:
7    category: "recipe"
8    domain: "productivity"
9    requires:
10      bins:
11        - gws
12      skills:
13        - gws-people
14        - gws-sheets
15---
16 
17# Export Google Contacts to Sheets
18 
19> **PREREQUISITE:** Load the following skills to execute this recipe: `gws-people`, `gws-sheets`
20 
21Export Google Contacts directory to a Google Sheets spreadsheet.
22 
23## Steps
24 
251. 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"]'`
28 
29

Preparing the source view

Export Google Contacts to Sheets

SKILL.md