■Overview
This is a flow that adds a lead to Microsoft Excel when it is registered in Microsoft Dynamics365 Sales.
With Yoom, you can easily achieve this flow without the need for programming, as it allows for integration between applications.
■Recommended for
1. Those who manage sales data with Microsoft Dynamics365 Sales
・Sales department personnel utilizing Microsoft Dynamics365 Sales
・Those who analyze lead information to aid in formulating sales strategies
2. Those who use Microsoft Excel for business
・Those who transfer lead information to Microsoft Excel for data analysis
・Those who want to streamline the process of transferring data to Microsoft Excel
■Benefits of using this template
When transferring lead information from Microsoft Dynamics365 Sales to Microsoft Excel for data analysis, manual transfer can be cumbersome.
Moreover, data entry errors can compromise the accuracy of data analysis and negatively impact sales strategies.
With this flow, you can transfer leads registered in Microsoft Dynamics365 Sales to Microsoft Excel, streamlining manual tasks.
By automating data transfer to Microsoft Excel, you can prevent data entry errors and omissions, thereby enhancing the accuracy of data analysis.
■Notes
・Please integrate Yoom with both Microsoft Dynamics365 Sales and Microsoft Excel.
・Microsoft365 (formerly Office365) has both consumer and business plans (Microsoft365 Business), and if you are not subscribed to the business plan, authentication may fail.


When a lead is created
When an account is created
When a contact is created
When an opportunity is created
When a lead is created or updated
When an Account is Created or Updated
When a Contact is Created or Updated
When an Opportunity is Created or Updated
Retrieve Account Information
Create Account
Update Account Information
Create Contact
Retrieve Contact Information
Update Account Contact Information
Delete Account Contact
Update Lead Information
Retrieve Lead Information
Delete Lead
Create Case
Update Case Information
Retrieve Case Information
Create Lead
Delete Account
Delete Opportunity
Search Lead Information
Search Account
When a lead is created
When an account is created
When a contact is created
When an opportunity is created
When a lead is created or updated
When an Account is Created or Updated
When a Contact is Created or Updated
When an Opportunity is Created or Updated
Retrieve Account Information
Create Account
Update Account Information
Create Contact
Retrieve Contact Information
Update Account Contact Information
Delete Account Contact
Update Lead Information
Retrieve Lead Information
Delete Lead
Create Case
Update Case Information
Retrieve Case Information
Create Lead
Delete Account
Delete Opportunity
Search Lead Information
Search Account
Search Contact Information
Search Opportunities
Update Custom Fields of Account
Update Custom Field Information of Opportunity
Update Custom Fields of Lead
Get Worksheet Information
Get Specific Cell Value
Get Range in Columns
Get Range in Rows
Add Sheet
Change Sheet Name
Retrieve Table List
Add Table
Enter Formula in Cell
Enter Value in Cell
Get Item ID
Delete Sheet
Sort a specified range in ascending or descending order
Unprotect Worksheet
Get Drive Item ID from Sharing URL
Create Excel Session