recipe-sync-contacts-to-sheet
Export and sync Google Contacts to a Google Sheet for data analysis and management.
npx skills add googleworkspace/cli --skill recipe-sync-contacts-to-sheetBefore / After Comparison
1 组Previously, I had to manually export data from Google Contacts, choose a format, then open Google Sheets, import the file, and then perform data cleaning and formatting adjustments. This process was cumbersome and prone to errors, especially when the number of contacts was large, making it time-consuming and laborious.
Now, through an automated process, I can accurately synchronize the Google Contacts directory to Google Sheets with a single click. The data is automatically organized and formatted uniformly, greatly simplifying the preparation work before data analysis, and improving both work efficiency and data accuracy.
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
- List contacts:
gws people people listDirectoryPeople --params '{"readMask": "names,emailAddresses,phoneNumbers", "sources": ["DIRECTORY_SOURCE_TYPE_DOMAIN_PROFILE"], "pageSize": 100}' --format json - Create a sheet:
gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Name", "Email", "Phone"]' - Append each contact row:
gws sheets +append --spreadsheet SHEET_ID --range 'Contacts' --values '["Jane Doe", "jane@company.com", "+1-555-0100"]'
User Reviews (0)
Write a Review
No reviews yet
Statistics
User Rating
Rate this Skill