When a response to the quote is submitted in the form, issue a quotation using Microsoft Excel and send it via Outlook email.
■Overview
Using the content entered in the form, documents are issued using an Excel quotation template.
After that, the issued documents are sent to the recipient via email.
Document issuance can be done not only with Excel but also with Google Sheets and Google Docs.
■Preparation
・Prepare a template document (Excel) for issuing documents.
■Excel currently in use (view-only access. Please make a copy if you wish to use it)
■Creation Method
① Create a new Flowbot and select "Create from scratch".
② Select the form trigger from the triggers, configure the following settings, and save.
・Form Title: Give it a title of your choice. This title will be displayed to respondents.
・Each question item: Set the information necessary for issuing documents and sending emails to the recipient. *You can add more questions by clicking "Add question".
・Acquired values: On the next page, you can input demo values for the questions you set. Enter demo values as they will be used in later tests.
*For instructions on setting up the form, please refer here. https://intercom.help/yoom/en/articles/8009267
③ Click the plus sign, select Excel from the operations to issue documents, configure the following settings, and test/save.
・File storage location: Select OneDrive or SharePoint where the target Excel is stored.
・Drive ID/Site ID: Select the drive ID for OneDrive or the site ID for SharePoint.
・Item ID: Click and select the Excel template you want to issue documents from the candidates.
・File name (optional): If the item does not appear in the item ID, enter the file name here and select the item ID again.
・Folder ID for storage: Select the folder ID to store after issuing the document from the candidates.
・Folder name for storage (optional): If the item does not appear in the folder ID, enter the folder name here and select the folder ID again.
・Output file name: Set an arbitrary file name. You can also embed the values obtained in step ②. (Embedding output)
・String to be replaced: Embed the values obtained in step ② for the corresponding string.
*For instructions on setting up the operation to issue documents, please refer here. https://intercom.help/yoom/en/articles/8237765
*For embedding output, please refer here. https://intercom.help/yoom/en/articles/8223528
*If the site ID does not appear in SharePoint, please refer here. https://intercom.help/yoom/en/articles/9003081
④ Click the plus sign, select any email tool from the operations to send emails, configure the following settings, and save.
・To: Click the field and embed the address obtained in step ②.
・Subject/Body: Enter arbitrary values. You can also embed the values obtained in step ② as before.
・Attachment: Click "Add attachment", use the output, and select the issued document from the candidates.
・Test: You can check the reflected content on the next page and conduct a test. (Please note that it will actually be sent)
■Notes
・Pre-registration (integration) with the app to be used is required. The following is a reference guide for integration.
*There may be no detailed guide available for apps that can be integrated simply.
https://intercom.help/yoom/en/collections/3041779
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.
This is a flow that is triggered at the end of each month to send an email in Outlook. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
This is a business workflow that automatically adds Outlook email content as notes to HubSpot. By utilizing Yoom's API integration and AI, it reduces manual tasks and streamlines information management.
This is a business workflow that automatically creates a Salesforce case from support request emails received in Outlook. By automatically converting support emails received in Outlook into Salesforce cases, you can eliminate the need for manual input and allocate valuable time to other important tasks.
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.
This is a flow that is triggered at the end of each month to send an email in Outlook. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
This is a business workflow that automatically adds Outlook email content as notes to HubSpot. By utilizing Yoom's API integration and AI, it reduces manual tasks and streamlines information management.
This is a business workflow that automatically creates a Salesforce case from support request emails received in Outlook. By automatically converting support emails received in Outlook into Salesforce cases, you can eliminate the need for manual input and allocate valuable time to other important tasks.
When a specific subject email is received
When an email is received
When an event is registered in the calendar
When a calendar event is added or updated
When a Task is Created
When an email is received
Get worksheet information
Get a specific cell value
Get range by column
Get range by row
Add worksheet
Rename sheet
Get 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
List sites
List drives in site
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)
When a specific subject email is receivedWhen an email is receivedWhen an event is registered in the calendarWhen a calendar event is added or updatedWhen a Task is CreatedWhen an email is received
Register Event in Own CalendarCreate CalendarRegister Event in Specified User's CalendarGet email attachment informationDownload email attachmentsDelete an event from a specified user's calendarUpdate an event in a specified user's calendarDelete an event from your calendarUpdate an event in your calendarタスクを作成する（リマインド設定対応）タスクを作成する（リマインド設定非対応）Search events in my calendarSearch events in a specified user’s calendarFind meeting timesGet calendar viewGet email messagesMove messageGet a specific message
