When Salesforce opportunity information is registered, add the information to Excel.
When Salesforce opportunity information is registered, add the information to Excel.
Launch this workflow to connect
Salesforce &
Microsoft Excel
!
◼️Overview
This is a flow bot that automatically adds opportunity information to Excel when a record is registered in the Salesforce opportunity object.
When opportunity information is added to Salesforce, it searches for the account associated with that opportunity and automatically writes the information to an Excel sheet.
Please prepare a sheet to manage opportunity information in Excel Online for use.
◼️Notes
・After opportunity information is registered in Salesforce, an event will be registered in Google Calendar 5 to 15 minutes later.
・Integration settings with both Salesforce and Excel Online are required for Yoom.
・Available for use with Excel Online. (Not available for local files.)
・Available with Yoom's Team Plan or higher.
・Salesforce is an app available only with the Team Plan and Success Plan. For Free Plan and Mini Plan, the operation and data connection of the configured flow bot will result in an error, so please be careful.
・Paid plans such as Team Plan and Success Plan offer a two-week free trial. During the free trial, you can use restricted apps.
・Microsoft365 (formerly Office365) has a Home Plan and a General Business Plan (Microsoft365 Business), and if you are not subscribed to the General Business Plan, authentication may fail.
Check Out Similar Templates!
Add a record to Microsoft Excel when a record is registered in a Salesforce custom object.
When a record is registered in a Salesforce custom object, it is added to the Microsoft Excel database. This flow improves work efficiency by eliminating the need for manual data entry by the person in charge.
See more
About the Apps
Salesforce
Templates using
Salesforce
When a ToDo object is registered in Salesforce, it is added to the Google Spreadsheet database. This flow frees the person in charge from the redundant manual input tasks, allowing them to focus on their core duties.
This is a business workflow that automatically adds a contact to Mailchimp when the lead status is updated in Salesforce. Automating data synchronization streamlines customer management.
This is a business workflow that automatically adds lead information registered in Salesforce to Notion. It reduces manual input and streamlines information sharing across the entire team.
Templates using
Microsoft Excel
A business workflow that automatically adds records to Microsoft Excel based on Tally's responses. It eliminates manual data entry, ensuring data accuracy and real-time updates, thereby improving work efficiency and preventing errors.
The workflow automatically records Jotform responses in Excel and adds tasks to Outlook. It eliminates the need for manual data entry and task setting, enhancing the accuracy and efficiency of operations.
This is a business workflow that automatically organizes Microsoft Teams posts into Excel and adds tasks to Outlook. It eliminates the need for manual input, streamlining information and task management.
About the apps you use
Salesforce
With Yoom, you can utilize Salesforce's API without any coding. For example, you can retrieve information from Salesforce via the API and integrate it with other SaaS or create documents. Additionally, you can synchronize Salesforce lead information and deal information with Yoom's database for various purposes.
see detailsTemplates
When a ToDo object is registered in Salesforce, it is added to the Google Spreadsheet database. This flow frees the person in charge from the redundant manual input tasks, allowing them to focus on their core duties.
Add a Google Spreadsheet entry when a ToDo object is registered in Salesforce.
This is a business workflow that automatically adds a contact to Mailchimp when the lead status is updated in Salesforce. Automating data synchronization streamlines customer management.
Add a contact to Mailchimp when the lead status in Salesforce is updated.
This is a business workflow that automatically adds lead information registered in Salesforce to Notion. It reduces manual input and streamlines information sharing across the entire team.
Add lead information registered in Salesforce to Notion.
Microsoft Excel
Yoom allows you to integrate with Microsoft Excel's API without any code, enabling the automation of various tasks. For example, it can automatically store values in specific Excel cells or create sheets and tables automatically.
see detailsTemplates
A business workflow that automatically adds records to Microsoft Excel based on Tally's responses. It eliminates manual data entry, ensuring data accuracy and real-time updates, thereby improving work efficiency and preventing errors.
Add records to Microsoft Excel based on Tally's responses.
The workflow automatically records Jotform responses in Excel and adds tasks to Outlook. It eliminates the need for manual data entry and task setting, enhancing the accuracy and efficiency of operations.
Add tasks to Microsoft Excel and Outlook based on Jotform responses.
This is a business workflow that automatically organizes Microsoft Teams posts into Excel and adds tasks to Outlook. It eliminates the need for manual input, streamlining information and task management.
Add tasks to Microsoft Excel and Outlook based on Microsoft Teams posts.
No-Code API Actions
Executable API actions
Flowbot triggers
When a new record is registered in the lead object
When a new record is registered in the account object
When a new record is registered in the opportunity object
When a new record is registered in the contact object
When a record is registered or updated in the lead object
When a record is created or updated in the Account object
When a record is created or updated in the Opportunity object
When a record is created or updated in the Contact object
When a new record is created in the Custom Object
When a record is created or updated in the Custom Object
When a record is registered in the Activity object
When a record is registered in the ToDo object
When an outbound message is received
When a file is uploaded
When a calendar event is created
When a calendar event is updated
When a calendar event is deleted
Flowbot operations
Get Lead records
Update Lead Records
Create Lead Record
Search Lead records
Get Latest Lead Record
Get Account records
Update Account records
Create Account Record
Search Account records
Get Opportunity Record
Update Opportunity records
Create Opportunity Record
Search Opportunity records
Get Contact Record
Update Contact records
Create Contact Records
Search Contact records
Get Custom Object Record
Flowbot triggers
When a new record is registered in the lead objectWhen a new record is registered in the account objectWhen a new record is registered in the opportunity objectWhen a new record is registered in the contact objectWhen a record is registered or updated in the lead objectWhen a record is created or updated in the Account objectWhen a record is created or updated in the Opportunity objectWhen a record is created or updated in the Contact objectWhen a new record is created in the Custom ObjectWhen a record is created or updated in the Custom ObjectWhen a record is registered in the Activity objectWhen a record is registered in the ToDo objectWhen an outbound message is receivedWhen a file is uploadedWhen a calendar event is createdWhen a calendar event is updatedWhen a calendar event is deleted
Flowbot operations
Get Lead recordsUpdate Lead RecordsCreate Lead RecordSearch Lead recordsGet Latest Lead RecordGet Account recordsUpdate Account recordsCreate Account RecordSearch Account recordsGet Opportunity RecordUpdate Opportunity recordsCreate Opportunity RecordSearch Opportunity recordsGet Contact RecordUpdate Contact recordsCreate Contact RecordsSearch Contact recordsGet Custom Object RecordUpdate Custom Object RecordCreate Custom Object RecordSearch custom object recordsLink a File to a RecordUpload a File to Link to a RecordGet the Content Document ID of the Uploaded FileSearch Lead Records (Excluding Deleted Records)Search Account Records (Excluding Deleted Records)Search Opportunity Records (Excluding Deleted Records)Search Contact Records (Excluding Deleted Records)Search Custom Object Records (Excluding Deleted Records)Download ReportLog Activity on LeadLog Activity on AccountLog Activity on Opportunity RecordLog Activity on ContactCreate To-Do on LeadCreate ToDo on Account ObjectCreate Task on OpportunityCreate Task on ContactLog Activity on LeadCreate Event on AccountCreate Event on OpportunityCreate Event on ContactLog Email Message to OpportunityLog Email Message to AccountCreate User RecordCreate Email MessageAssociate Email Message with PersonAdd Email Message to Custom ObjectLog Activity on a Custom ObjectCreate To-Do on a Custom ObjectLog Activity on Custom ObjectGet Content IDs of Files Related to a RecordGet Latest Content Version IDDownload FilesGet Contract RecordUpdate Contract recordsCreate Contract Object RecordDelete Contract RecordCreate Calendar EventSearch User Object RecordsGet User RecordUpdate Account ActivitySearch Account ActivitiesGet User ListGet Account ListGet Contact ListGet Opportunity ListGet Lead ListGet Case ListGet Campaign ListGet Object ListGet Custom Object ListGet Chatter Group ID ListPost to User on ChatterPost to Account on ChatterChatterを取引先責任者に投稿Chatterを商談に投稿Chatterをリードに投稿Chatterをケースに投稿Post to Campaign ChatterPost to Custom Object ChatterChatterをChatterグループに投稿Get Channel Listユーザーオブジェクトのレコードの更新Create User RoleAssign User Roleユーザーオブジェクトの権限セット割り当ての作成Associate a Contract record with an Opportunity recordユーザーオブジェクトの権限セット割り当てを削除ユーザーを指定グループに追加ユーザーを指定グループから削除Post to ChatterAdd User to Chatter GroupGet File NameGet Email MessagesSearch Records with SOQL
Flowbot triggers
There is no action.
Flowbot operations
Get worksheet informationGet a specific cell valueGet range by columnGet range by rowAdd worksheetRename sheetGet table listAdd TableEnter Formula in CellEnter Value in CellGet item IDDelete SheetSort a specified range in ascending or descending orderUnprotect WorksheetGet Drive Item ID from Sharing URLCreate Excel SessionList sitesList drives in siteGet worksheet information (SharePoint)Get the value of a specific cell (SharePoint)Get range by column (SharePoint)Get range by row (SharePoint)Add worksheet (SharePoint)Rename worksheet (SharePoint)Get table list (SharePoint)Add table (SharePoint)Set formula in cell (SharePoint)Set value in cell (SharePoint)Delete sheet (SharePoint)Sort a specified range in ascending or descending order (SharePoint)Unprotect worksheet (SharePoint)Create Excel Session (SharePoint)Get Item ID (SharePoint)More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
