■Overview
This is a flow bot that automatically synchronizes deal information to Excel when a record in the Salesforce opportunity object is registered or updated.
When deal information is added or updated in Salesforce, it searches for the associated account and automatically updates the information in the Excel sheet.
If the corresponding deal information already exists in Excel, it updates the information; if not, it adds new deal information.
By recording the deal ID on the Excel sheet, you can check whether the corresponding deal information already exists in Excel by searching for the deal information on Excel.
Please prepare a sheet to manage deal information in Excel Online for use.
Utilize this when analyzing Salesforce deal information in Excel.
■Notes
・After deal information is registered or updated in Salesforce, an event is registered in Google Calendar 5 to 15 minutes later.
・Integration settings with both Salesforce and Excel Online are required. It is available for use in Excel Online (not available for local files).
・Available with Yoom's Team Plan or higher.
・Paid plans such as the Team Plan or Success Plan offer a two-week free trial. During the free trial, you can use apps that are subject to restrictions.