SkillsSKILLS
Productivity

recipe-sync-contacts-to-sheet▌

googleworkspace/cli · updated Apr 8, 2026

$npx skills add https://github.com/googleworkspace/cli --skill recipe-sync-contacts-to-sheet
summary

Export your Google Contacts directory to a Google Sheets spreadsheet in three steps.

  • ›Requires gws-people and gws-sheets skills to be loaded before execution
  • ›Lists contacts from your domain directory with names, email addresses, and phone numbers
  • ›Creates a new sheet with headers and appends each contact as a row for easy reference and sharing
skill.md

1d:["$","div",null,{"className":"prose prose-invert max-w-none prose-headings:font-semibold prose-headings:tracking-tight prose-h1:text-4xl prose-h1:mb-2 prose-h2:text-2xl prose-h2:mb-2 prose-h3:text-lg prose-h3:mb-2 prose-p:text-muted-foreground prose-li:text-muted-foreground prose-code:bg-muted prose-code:text-foreground prose-code:px-1 prose-code:py-0.5 prose-code:rounded-sm prose-code:text-sm prose-code:before:content-none prose-code:after:content-none prose-pre:bg-muted prose-pre:text-foreground prose-pre:border prose-pre:border-border prose-pre:rounded-md [&_table]:!border-[color:var(--border)] [&_th]:!border-[color:var(--border)] [&_td]:!border-[color:var(--border)]","dangerouslySetInnerHTML":{"__html":"<h1>Export Google Contacts to Sheets</h1>\n<blockquote>\n<p><strong>PREREQUISITE:</strong> Load the following skills to execute this recipe: <code>gws-people</code>, <code>gws-sheets</code></p>\n</blockquote>\n<p>Export Google Contacts directory to a Google Sheets spreadsheet.</p>\n<h2>Steps</h2>\n<ol>\n<li>List contacts: <code>gws people people listDirectoryPeople --params '{"readMask": "names,emailAddresses,phoneNumbers", "sources": ["DIRECTORY_SOURCE_TYPE_DOMAIN_PROFILE"], "pageSize": 100}' --format json</code></li>\n<li>Create a sheet: <code>gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Name", "Email", "Phone"]'</code></li>\n<li>Append each contact row: <code>gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Jane Doe", "jane@company.com", "+1-555-0100"]'</code></li>\n</ol>"}}]