Google Sheets + Microsoft Dynamics 365 CRM

Create opportunities in Microsoft Dynamics 365 CRM from new rows in Google Sheets

Boost your efficiency by linking Google Sheets with Microsoft Dynamics 365 CRM. With this workflow, each new row of data added to your spreadsheet swiftly turns into a fresh opportunity within Microsoft Dynamics 365 CRM. It's a seamless way to transfer data without manual input, saving you valuable time and effort while ensuring accuracy. Your customer relationship management has never been more streamlined.

When this happens...
New Spreadsheet Row
Triggers when a new row is added to the bottom of a spreadsheet.
TriggerInstant
automatically do this!
Create Opportunity
Creates a new opportunity.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write

- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write

- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write
New Account
Triggers when a new account is created.
Trigger
Polling
Try It
New Contact
Triggers when a new contact is created.
Trigger
Polling
Try It
- Custom EntityRequired
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- Customer typeRequired
- Owner
- Status
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Info
- AccountRequired
Action
Write
- Info
- ContactRequired
Action
Write
- Info
- Case/IncidentRequired
- State
Action
Write
- Info
- LeadRequired
Action
Write
- Info
- OrderRequired
Action
Write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
Action
Search
- 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
Action
Search
- State Code
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Contact ID
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Search By Email Only
- Owner
Action
Search or write
- 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
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write
- Info
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
New Case/Incident
Triggers when a new case/incident is created.
Trigger
Polling
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Polling
Try It
New Lead
Triggers when a new lead is created.
Trigger
Polling
Try It
New Opportunity
Triggers when a new opportunity is created.
Trigger
Polling
Try It
New Order
Triggers when a new order is created.
Trigger
Polling
Try It
- Info
Trigger
Polling
Try It
- Owner
Action
Write
- Owner
Action
Write
- Custom EntityRequired
Action
Write
- Info
- Owner
Action
Write
- Info
- Owner
Action
Write
- Owner
Action
Write
- Info
- Custom Entity ActionRequired
Action
Write
- Info
- InvoiceRequired
Action
Write
- Info
- OpportunityRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- 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
Action
Search
- Campaign NameRequired
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
Action
Search
- 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
Action
Search or write
- Info
- Info Field Enable
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write
- Info
- Info Field Enable
- Contact ID
- Match if any of the fields match (otherwise only match if all the fields match)
- Owner
Action
Search or write

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

About Microsoft Dynamics 365 CRM

Microsoft Dynamics is built for any device, anywhere. Built for you. For Dynamics Version 9 and Dynamics 365.

Learn more

Google Sheets + Microsoft Dynamics 365 CRM

Create opportunities in Microsoft Dynamics 365 CRM from new rows in Google Sheets

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New Account

New Contact

New Custom Entity

Updated Case/Incident

Updated Invoice

Updated Lead

Updated Opportunity

Updated Order

Create Account

Create Contact

Create Case/Incident

Create Invoice

Create Opportunity

Update Account

Update Contact

Update Case/Incident

Update Lead

Update Order

Find Account

Find Custom Entity

Find Campaign Response

Find Invoice

Find Opportunity

Find or Create Account

Find or Create Custom Entity

Find or Create Lead

Find or Create Order

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

Updated Account

Updated Contact

New Case/Incident

New Invoice

New Lead

New Opportunity

New Order

Updated Quote

Create Campaign

Create Campaign Response

Create Custom Entity

Create Lead

Create Order

Update Campaign Response

Update Custom Entity

Update Invoice

Update Opportunity

API Request (Beta)

Find Contact

Find Campaign

Find Multiple Leads

Find Lead

Find Order

Find or Create Contact

Find or Create Invoice

Find or Create Opportunity

About Google Sheets