Description
recipe-sync-contacts-to-sheet is a recipe skill from the Google Workspace CLI project, listed on skills.sh. It exports a Google Contacts directory to a Google Sheets spreadsheet in three steps. It lists the people in the domain directory with their names, email addresses and phone numbers, using the People API, with JSON output. It then writes a header row of Name, Email and Phone to a new sheet, and appends each contact as a row. The recipe needs the gws-people and gws-sheets skills. Contact details are personal data, so the user should check who can see the spreadsheet after it is created. It suits administrators and team leads who want a list of their organisation's directory in a sheet for mail merges, reports or a phone list, without copying each entry by hand.…
Highlights
- Lists the domain directory
- Names, emails and phone numbers
- Writes a header row and one row per contact
- Needs gws-people and gws-sheets
Ratings & Reviews
No ratings yet
Be the first to rate recipe-sync-contacts-to-sheet.
People also visit
recipe-copy-sheet-for-new-month
Duplicate a Google Sheets template tab for a new month of tracking
recipe-create-expense-tracker
Google Sheets spreadsheet template for expense tracking
recipe-generate-report-from-sheet
Extract Google Sheet data and generate a formatted Google Docs report
recipe-log-deal-update
Append deal status updates to a Google Sheets sales tracking spreadsheet
recipe-sync-contacts-to-sheet FAQ
What does this recipe do?
It exports the people in a Google domain directory into a Google Sheet, with name, email and phone columns.
How do I install it?
Run: npx skills add https://github.com/googleworkspace/cli --skill recipe-sync-contacts-to-sheet
Which fields are exported?
Names, email addresses and phone numbers, according to the listing and the example.
What needs care?
The sheet holds personal contact details, so check who can open it after it is created.
Has it been checked for security?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best recipe-sync-contacts-to-sheet alternatives?
Popular alternatives to recipe-sync-contacts-to-sheet include gws-sheets-append, gws-sheets-read and recipe-copy-sheet-for-new-month. See all recipe-sync-contacts-to-sheet alternatives