recipe-sync-contacts-to-sheet
Export Google Contacts directory to a Google Sheets spreadsheet.
Security Assessment
About recipe-sync-contacts-to-sheet
The recipe-sync-contacts-to-sheet skill automates the process of exporting a Google Contacts directory into a structured Google Sheets spreadsheet. It is designed to simplify data extraction from organizational contact directories, eliminating the need for manual copying or complex integrations. By leveraging command-line interactions with Google Workspace services, this skill ensures that contact information such as names, email addresses, and phone numbers can be efficiently transferred into a tabular format for further use.
The core functionality of this skill includes listing directory contacts using the gws-people capability, creating or appending to a Google Sheets document using gws-sheets, and systematically inserting contact data row by row. It specifies parameters such as read masks for selecting relevant contact fields and supports pagination for handling larger datasets. The workflow is structured into clear steps: retrieving contacts, initializing a spreadsheet with headers, and appending each contact’s details. This modular approach allows users to integrate or adapt the process within broader automation pipelines.
This skill is particularly useful for administrators, operations teams, and productivity-focused users who need to maintain up-to-date contact lists in a shareable and editable format. Common use cases include generating internal directories, preparing contact lists for reporting, or synchronizing organizational data for collaboration purposes. It is best suited for environments already utilizing Google Workspace tools and requires the presence of specific supporting skills and binaries to function correctly.
FAQ
What prerequisites are required to use this skill?
You must have the gws-people and gws-sheets skills loaded, along with the gws binary available in your environment.
What data fields are exported to Google Sheets?
The skill exports names, email addresses, and phone numbers as specified in the readMask parameter.
Can this skill handle large contact directories?
Yes, it supports pagination through the pageSize parameter, allowing processing of multiple contacts in batches.
Do I need an existing Google Sheet to use this skill?
Yes, you need to provide a valid spreadsheet ID where the contact data will be appended.
Is this skill compatible with personal Google Contacts?
No, it is configured to retrieve contacts from the domain directory source, not personal contact lists.
Install recipe-sync-contacts-to-sheet
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
googleworkspace/cli