Refound your company for the AI era at ZapConnect 2026. Save your spot →
Google Sheets + Microsoft Dynamics 365 CRM integrations
Create spreadsheet rows in Google Sheets for new Microsoft Dynamics leads
Backing up your lead data is an important step in your lead management process. With this Zap, you can automatically add new leads to Google Sheets from Microsoft Dynamics. Back up your data automatically.
- When this happens...

New LeadTriggers when a new lead is created.TriggerPolling - automatically do this!

Create Spreadsheet RowCreate a new row in a specific spreadsheet.ActionWrite
- Free forever for core features
- 14 day trial for premium features & apps
More things you can do with Microsoft Dynamics 365 CRM and Google Sheets
Discover other triggers and actions you can use with Microsoft Dynamics 365 CRM and Google Sheets
New AccountTriggers when a new account is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New ContactTriggers when a new contact is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Info
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Customer typeRequired
- Owner
- Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- AccountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- ContactRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Case/IncidentRequired
- State
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- LeadRequired
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
ActionThis is an event a Zap performs.SearchFind existing data in your app- State Code
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Contact ID
- Match if any of the fields match (otherwise only match if all the fields match)
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
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- Info
- Info_field_enable
- Custom EntityRequired
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
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- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
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- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
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- Dont_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 plan- Dont_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
- Overwrite All Columns
- 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.- Api_docs_info
- 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
- Spreadsheet NameRequired
- Search Type
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data 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 app- Drive
- 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
New Case/IncidentTriggers when a new case/incident is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New InvoiceTriggers when a new invoice is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New LeadTriggers when a new lead is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New OpportunityTriggers when a new opportunity is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan
New OrderTriggers when a new order is created.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Custom EntityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Owner
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- Custom Entity ActionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- InvoiceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Info
- OpportunityRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.- Api_docs_info
- 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.- Info
- Info_field_enable
- Company Name
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
ActionThis is an event a Zap performs.SearchFind existing data in your app- Campaign_nameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
ActionThis is an event a Zap performs.SearchFind existing data in your app- Info
- Info_field_enable
- Company Name
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
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- Info
- Info_field_enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
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- Info
- Info_field_enable
- Contact ID
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
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- Dont_change_sheet_structure
- Drive
- SpreadsheetRequired
- WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free plan- Dont_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
- 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
- First row
- Row count
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
ActionThis is an event a Zap performs.SearchFind existing data in your app- Spreadsheet IDRequired
- Include Grid Data
ActionThis is an event a Zap performs.SearchFind existing data in your app- Drive
- Spreadsheet NameRequired
- Search Type
- Spreadsheet to Copy
- 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- 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.Search or writeFind existing data in your app, or create a new record if no data is found
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Microsoft Dynamics is built for any device, anywhere. Built for you. For Dynamics Version 9 and Dynamics 365.
Related categories







