Google Sheets + Microsoft Office 365
Create new rows in Google Sheets for every new contact in Microsoft Office 365
Effortlessly maintain your contacts and enhance productivity with this workflow. When a new contact is added to your Microsoft Office 365, a row with the relevant contact information is immediately created in your Google Sheets. This streamlined process ensures effective management of your contacts, eliminating the need for manual data entry and potential for errors.
Effortlessly maintain your contacts and enhance productivity with this workflow. When a new contact is added to your Microsoft Office 365, a row with the relevant contact information is immediately created in your Google Sheets. This streamlined process ensures effective management of your contacts, eliminating the need for manual data entry and potential for errors.
- When this happens...
New ContactTriggers when a new contact is added to your account
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Spreadsheet RowCreate a new row in a specific spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Calendar
Time BeforeRequired
Time Before (Unit)Required
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New Flagged Email
Triggers when a new email is flagged.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact Folder
First NameRequired
Last Name
Email Addresses
Business Phones
Home Phones
Mobile Phone
Job Title
Company Name
Department
Business Website URL
File As
Personal Notes
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.EventRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Folder
ContactRequired
First Name
Last Name
Email Addresses
Business Phones
Home Phones
Mobile Phone
Job Title
Company Name
Department
Business Website URL
Personal Notes
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Folder
First Name
Last Name
Email
ActionThis is an event a Zap performs.SearchFind existing data in your appFolder Info
FolderRequired
Search terms
From address
Start date
End date
ActionThis is an event a Zap performs.SearchFind existing data in your appContact Folder
First NameRequired
Last Name
Email
Business Phones
Home Phones
Mobile Phone
Job Title
Company Name
Department
Business Website URL
File As
Personal Notes
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
Street
City
State
Postal Code
Country or Region
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Parent FolderRequired
Child Folder
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planParent Folder
Child Folder
Search termsRequired
Note
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planCalendar
SubjectRequired
Start Date & TimeRequired
End Date & TimeRequired
All Day Event?
Description
Show me as Free or Busy
Attendees
Categories
Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.To Email(s)Required
CC Email(s)
BCC Email(s)
SubjectRequired
Body FormatRequired
BodyRequired
Attachment
Action for Files Larger Than 150MB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.From Email
To Email(s)Required
CC Email(s)
BCC Email(s)
SubjectRequired
Body FormatRequired
BodyRequired
Attachments
Action for Files Larger Than 150MB
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Calendar
Search TermRequired
Start Date & Time
End Date & Time
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch Info
Search valueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appCalendar
Start date and timeRequired
End date and timeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Related categories
About Microsoft Office 365
Related Zap Templates
- Send Microsoft Office 365 emails for new rows in a Google Sheets
- Send Microsoft Office 365 emails for new or updated Google Sheet rows
- Create personalized cold email drafts in Microsoft Office 365 from new Google Sheets rows with Brain Pod AI
- Create Microsoft Office 365 events from new Google Sheets rows
- Create draft emails in Microsoft Office 365 from new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new emails in Microsoft Office 365
- Send emails in Microsoft Office 365 from new or updated rows in Google Sheets team drive
- Create spreadsheet rows in Google Sheets for new calendar events in Microsoft Office 365
- Generate Google Sheets rows for new Microsoft Office 365 messages in a folder
- Create Microsoft Office 365 events from new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new emails matching search in Microsoft Office 365
- Start new Google Sheets rows for every Microsoft Office 365 calendar event start
- Create new Microsoft Office 365 contacts from new rows in Google Sheets
- Create contacts in Microsoft Office 365 from new or updated rows in Google Sheets
- Create new Microsoft Office 365 contacts from new Google Sheets spreadsheets
- Update Google Sheets rows with new Microsoft Office 365 messages in folder
- Generate Google Sheets rows for each new matched email in Microsoft Office 365
- Create multiple Google Sheets rows for new matching emails in Microsoft Office 365
- Create new rows at the top of Google Sheets when new messages arrive in Microsoft Office 365 folders
Related Zap Templates
- Send Microsoft Office 365 emails for new rows in a Google Sheets
- Create Microsoft Office 365 events from new Google Sheets rows
- Send emails in Microsoft Office 365 from new or updated rows in Google Sheets team drive
- Create Microsoft Office 365 events from new or updated rows in Google Sheets
- Create new Microsoft Office 365 contacts from new rows in Google Sheets
- Send Microsoft Office 365 emails for new or updated Google Sheet rows
- Create draft emails in Microsoft Office 365 from new or updated rows in Google Sheets
- Create spreadsheet rows in Google Sheets for new calendar events in Microsoft Office 365
- Create spreadsheet rows in Google Sheets for new emails matching search in Microsoft Office 365
- Create contacts in Microsoft Office 365 from new or updated rows in Google Sheets
- Create personalized cold email drafts in Microsoft Office 365 from new Google Sheets rows with Brain Pod AI
- Create spreadsheet rows in Google Sheets for new emails in Microsoft Office 365
- Generate Google Sheets rows for new Microsoft Office 365 messages in a folder
- Start new Google Sheets rows for every Microsoft Office 365 calendar event start
- Create new Microsoft Office 365 contacts from new Google Sheets spreadsheets