Sync Outlook Contacts to Sheets
Automatically log new Outlook contacts to Google Sheets and receive instant Gmail notifications with their details. Great for sales teams and admin pros.
This workflow automatically tracks new contacts added to your Microsoft Outlook account by saving their details into a Google Sheets spreadsheet and sending you a notification via Gmail. Whenever a new contact is created in Outlook, the information is logged for easy record-keeping, and you get an immediate email alert with all the essential contact details.
It does three things:
- Watches for new contacts created in Microsoft Outlook.
- Adds the new contact's details as a row in a specified Google Sheets spreadsheet.
- Sends a formatted notification email through Gmail with the contact's information.
What You Need
- A Microsoft Outlook account with permissions to access contacts.
- A Google account with access to Google Sheets where you want to store contacts.
- A Gmail account to send notification emails.
- Properly configured OAuth permissions on the Needle platform for Microsoft Outlook, Google Sheets, and Gmail.
- The Google Sheet ID and Worksheet ID where contacts will be stored.
- Your email address to receive notifications.
How the Flow Works
| Node | Description |
|---|---|
| Microsoft Outlook – New Contact Trigger | Listens for any new contact added in your Outlook account and triggers the workflow when one is created. |
| Google Sheets – Upsert Row | Adds the new contact's details to a Google Sheet as a new row. Uses the contact's email as a key in column A, and inserts details like email, display name, phone number, and company name. |
| Gmail – Send Email | Sends a notification email about the new contact to your specified inbox. The email includes a nicely formatted HTML summary of the contact's info pulled directly from Outlook. |
What Gets Captured
The following contact fields are logged in Google Sheets and included in the notification email:
| Field | Description |
|---|---|
| Display Name | The contact's full name as shown in Outlook |
| Primary email address | |
| Phone | Mobile or business phone number |
| Company | Company or organization name |
| Job Title | The contact's job title |
Output
At the end of this workflow, your Google Sheet will have a fresh row containing the latest contact's key information, and you'll receive an immediate Gmail notification confirming the contact was added, complete with all relevant details.
Notes
- Make sure to replace placeholders like
YOUR_SHEET_ID,YOUR_WORKSHEET_ID, andYOUR_EMAILwith your actual spreadsheet IDs and email address before running the workflow. - The email notification is HTML formatted for clarity, so it looks clean in most email clients.
- If any contact information fields are missing (like phone or company), the email will show "N/A" to indicate unavailable data.
- Ensure your connectors have the necessary permissions to read contacts in Outlook and write to Google Sheets and Gmail to avoid authentication errors.
Want to showcase your own workflows?
Become a Needle workflow partner and turn your expertise into recurring revenue.
