recipe-sync-contacts-to-sheet
PopularExport Google Contacts directory to a Google Sheets spreadsheet.
"Export Google Contacts directory to a Google Sheets spreadsheet."
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"]'
You Might Also Like
Related Skills
revops
When the user wants help with revenue operations, lead lifecycle management, or marketing-to-sales handoff processes. Also use when the user mentions 'RevOps,' 'revenue operations,' 'lead scoring,' 'lead routing,' 'MQL,' 'SQL,' 'pipeline stages,' 'deal desk,' 'CRM automation,' 'marketing-to-sales handoff,' 'data hygiene,' 'leads aren't getting to sales,' 'pipeline management,' 'lead qualification,' or 'when should marketing hand off to sales.' Use this for anything involving the systems and processes that connect marketing to revenue. For cold outreach emails, see cold-email. For email drip campaigns, see emails. For pricing decisions, see pricing.
coreyhaines31
recipe-block-focus-time
Create recurring focus time blocks on Google Calendar to protect deep work hours.
googleworkspacerecipe-create-task-list
Set up a new Google Tasks list with initial tasks.
googleworkspacerecipe-share-doc-and-notify
Share a Google Docs document with edit access and email collaborators the link.
googleworkspacerecipe-schedule-recurring-event
Create a recurring Google Calendar event with attendees.
googleworkspacerecipe-find-large-files
Identify large Google Drive files consuming storage quota.
googleworkspace