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://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

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 or 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