Skip to content
Skillpedia
Analysis & spreadsheets32k · #6343

recipe-sync-contacts-to-sheet

Helps your agent export Google contacts to a spreadsheet. It's useful for organizing contact lists and using them elsewhere.

What it does

This tool copies your Google contacts into a Google Sheet. This gives you an organized list of all your contacts.

When to use it

  • ✓When you want a contact list to use elsewhere.
  • ✓To have a backup of your contacts.
  • ✓To organize work or personal contacts.

Example of what to ask your AI

“Copy my Google contacts to a spreadsheet.”

Want more? Open the sections below.

How to use

The easiest way: copy the message below and paste it into Claude, ChatGPT, Cursor or any AI. It reads the skill and follows the instructions.

Skill link

https://github.com/googleworkspace/cli/blob/main/skills/recipe-sync-contacts-to-sheet/SKILL.md

Ready-to-paste message

Use this skill to help me: https://github.com/googleworkspace/cli/blob/main/skills/recipe-sync-contacts-to-sheet/SKILL.md Read the SKILL.md file at that link and follow its instructions for my task.
How it works

The tool first retrieves all your contacts from Google. Then, it creates a new spreadsheet or uses an existing one and adds the name, email, and phone number of each contact into separate rows.

Installation

Easiest way: copy the skill link and paste it into Claude, ChatGPT or Cursor asking it to follow the instructions.

In the terminal (Claude Code, Codex, Cursor), in your project folder:

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

Or download just the file:

curl -L https://raw.githubusercontent.com/googleworkspace/cli/main/skills/recipe-sync-contacts-to-sheet/SKILL.md -o SKILL.md
Technical content (original SKILL.md)

Original text by the author, straight from GitHub.

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", "jane@company.com", "+1-555-0100"]'
FAQ

Do I need any other tools installed?

Yes, you need to have the 'gws-people' and 'gws-sheets' tools loaded for this one to work.

What happens to contacts already in the spreadsheet?

The tool adds the new contacts. If you already have contacts in the sheet, they will remain there.

Can I choose which contact information to export?

Currently, it exports names, email addresses, and phone numbers.

Details

Original description by the author

Export Google Contacts directory to a Google Sheets spreadsheet.

repo: googleworkspace/cli

Popularity

GitHub stars
32k
Ranking position
#6343
License
Apache-2.0
Updated
10/6/2026

Is this skill useful?

0

Sign in to vote.

Comments

  • …

More skills from this repository

Similar skills