AutoGineer
Generated banner for Recipe Sync Contacts To Sheet
Generated logo for Recipe Sync Contacts To Sheet

Recipe Sync Contacts To Sheet

Google WorkspaceOfficialPublished by Google Workspace

  • Skill
  • Workflow
  • Automation and integrations
  • Apache-2.0
  • No issues found
Download ZIP

From the author

Export Google Contacts directory to a Google Sheets spreadsheet.
— the description by Google Workspace

AutoGineer summary

Written by AutoGineer from the skill’s own files, not by the author

This workflow provides a structured procedure for synchronizing contact information from a Google directory into a Google Sheets document. By leveraging specific Google Workspace services, it automates the retrieval of directory profiles and populates a spreadsheet with names, email addresses, and phone numbers.

What it does

  • Retrieves contact directory data including names, emails, and phone numbers.
  • Initializes a new or existing Google Sheet with appropriate headers.
  • Appends individual contact records into rows within the specified spreadsheet.

When to use it

  • When you need to create a backup or a portable list of your organization's directory.
  • When preparing contact data for reporting or distribution in a spreadsheet format.
  • When you want to automate the manual task of copying directory information.

Advantages

  • Reduces manual data entry errors.
  • Ensures consistent formatting of contact data in Sheets.
  • Streamlines the process of moving data between Google Workspace services.

Usage examples

“Export my company directory to a new Google Sheet.”
The agent will list the directory contacts and append them to the specified spreadsheet with columns for Name, Email, and Phone.

Install

  1. Download the skill as a ZIP:

    https://mp-staging.autogineer.com/agent-skills/googleworkspace/recipe-sync-contacts-to-sheet/download

  2. Unzip it into the cross-client skills folder of your project:

    mkdir -p .agents/skills && unzip recipe-sync-contacts-to-sheet.zip -d .agents/skills

Documentation by Google Workspace

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

  1. List contacts: gws people people listDirectoryPeople --params '{"readMask": "names,emailAddresses,phoneNumbers", "sources": ["DIRECTORY_SOURCE_TYPE_DOMAIN_PROFILE"], "pageSize": 100}' --format json

  2. Create a sheet: gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Name", "Email", "Phone"]'

  3. Append each contact row: gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Jane Doe", "[email protected]", "+1-555-0100"]'

Files

SKILL.md

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

  1. List contacts: gws people people listDirectoryPeople --params '{"readMask": "names,emailAddresses,phoneNumbers", "sources": ["DIRECTORY_SOURCE_TYPE_DOMAIN_PROFILE"], "pageSize": 100}' --format json

  2. Create a sheet: gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Name", "Email", "Phone"]'

  3. Append each contact row: gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Jane Doe", "[email protected]", "+1-555-0100"]'

Requirements and compatibility

Works with: Claude Code, Claude apps, OpenAI Codex, GitHub Copilot, Cursor, Gemini CLI, Kiro, OpenCode, Goose, Amp, Roo Code, JetBrains Junie, Factory Droid, Devin (ex-Windsurf), Mistral Vibe, OpenHands, Letta

“Works with” means the tool reads the open Agent Skills format; a skill written for one tool may use features others lack.

Security

No issues found by our static scan· No issues found

A static scan is not a guarantee. Skills are third-party content: review a skill before you let an agent use it.

Attribution and licence

Published by
Google Workspace
Publisher
Google Workspace (Official)
Source
googleworkspace/cli · skills/recipe-sync-contacts-to-sheet · commit cd3697e
Licence
Apache License 2.0 (redistribution allowed)
  • LICENSE (added by AutoGineer from LICENSE)
  • ATTRIBUTION.md (written by AutoGineer)
Synced

AutoGineer is not affiliated with or endorsed by Google Workspace.

Download ZIP

The ZIP holds the skill’s files, its licence files and an ATTRIBUTION.md. Download recipe-sync-contacts-to-sheet.zip