recipe-sync-contacts-to-sheet

Name: recipe-sync-contacts-to-sheet
Author: googleworkspace

25kinstalls1.7kforks

How to install recipe-sync-contacts-to-sheet?

googleworkspace/cli/recipe-sync-contacts-to-sheet

$npx -y skills add googleworkspace/cli --skill recipe-sync-contacts-to-sheet

Installs into the current project.

Summary

Export Google Contacts directory to a Google Sheets spreadsheet.

Files · 1

SKILL.md

1	# Export Google Contacts to Sheets
2
3	> PREREQUISITE: Load the following skills to execute this recipe: `gws-people`, `gws-sheets`
4
5	Export Google Contacts directory to a Google Sheets spreadsheet.
6
7	## Steps
8
9	1. List contacts: `gws people people listDirectoryPeople --params '{"readMask": "names,emailAddresses,phoneNumbers", "sources": ["DIRECTORY_SOURCE_TYPE_DOMAIN_PROFILE"], "pageSize": 100}' --format json`
10	2. Create a sheet: `gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Name", "Email", "Phone"]'`
11	3. Append each contact row: `gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Jane Doe", "jane@company.com", "+1-555-0100"]'`

6 picks

Type