■Overview
This is a flow where you launch Yoom's Flowbot from the HubSpot contact page to create an invoice based on a Microsoft Excel template and send an email to Outlook.
By launching the Flowbot from HubSpot and setting information such as billing items and amounts in the specified locations, invoices are automatically created.
You can use any format for the invoice template.
Additionally, it is possible to include a request for confirmation from the person in charge during the flow, allowing for a combination where the billing details are checked once.
■Notes
・Integration with HubSpot, Microsoft Excel, and Outlook is required for Yoom.
・Microsoft365 (formerly Office365) has both a home plan and a general business plan (Microsoft365 Business), and if you are not subscribed to the general business plan, authentication may fail.
・Please prepare an invoice template created with Microsoft Excel, like this.



When a new contact is created
When a new company is created
When a new deal is created
When a contact is created or updated
When a company is created or updated
When a deal is created or updated
Form Submitted
When a product is created
When a product is created or updated
When a deal is updated to the specified stage
When a record is created in a custom object
When a custom object record is created or updated
When an order is created or updated
When an order is created
When a ticket is created
When a ticket is created or updated
When a Service is created
When a Service is created or updated
Create Contact
Retrieve Contact
Get Latest Contact IDs
Update Contact
Search Contact (Keyword Search)
Create Company
Retrieve Company Information
Retrieve Latest Company ID
Update Company
Search Company (Keyword Search)
Create Deal
Get Deal Details
Retrieve Latest Deal ID
Update Deal
Search Deals (Keyword)
Get Contact Custom Properties
Retrieve Company Custom Properties
Get Deal Custom Properties
When a new contact is created
When a new company is created
When a new deal is created
When a contact is created or updated
When a company is created or updated
When a deal is created or updated
Form Submitted
When a product is created
When a product is created or updated
When a deal is updated to the specified stage
When a record is created in a custom object
When a custom object record is created or updated
When an order is created or updated
When an order is created
When a ticket is created
When a ticket is created or updated
When a Service is created
When a Service is created or updated
When a Task is created
When a note is added to a deal
Create Contact
Retrieve Contact
Get Latest Contact IDs
Update Contact
Search Contact (Keyword Search)
Create Company
Retrieve Company Information
Retrieve Latest Company ID
Update Company
Search Company (Keyword Search)
Create Deal
Get Deal Details
Retrieve Latest Deal ID
Update Deal
Search Deals (Keyword)
Get Contact Custom Properties
Retrieve Company Custom Properties
Get Deal Custom Properties
Get List of Contact IDs
Get List of Company IDs
Search Deals (Filter Search)
Update Contact Custom Property
Update Company Custom Properties
Update Deal Custom Properties
Create Ticket
Submit Information to Form
Update Ticket
Associate Records
Add Note to Contact
Get Public URL of File
Get Custom Object Records
Create Custom Object Record
Update Custom Object Record
Search Custom Object Records
Retrieve Product
Create Product
Update Product
Search Products (Keyword Search)
Update Ticket Custom Property
Add Note to Company
Add Note to Deal
Add Note to Ticket
Add Meeting to Company
Search multiple contacts (filter criteria)
Get Ticket Details
Add Product Item to Deal
Search Products (Filter Search)
Get Owner (Representative) Information
Get List of Owners (Assignees)
Search Multiple Companies (Filter Conditions)
Add a Note to a Custom Object Record
Retrieve Company IDs Associated with a Specific Contact
Retrieve the Custom Object Record ID Associated with a Specific Deal
Create user
Retrieve Service Custom Properties
Create Meeting Log
Get ticket custom properties
Get quote
Update quote
Create task
Delete quote
Search quotes
Create form
Create Call Log
List tax rates
Search deals (filter)
Search fees (filter)
Search discounts (filter)
Search quote templates (filter)
Add signer to quote
Create Quote
Get line items for a deal
Get line item details
List tasks
Get task
Check object associations
Get user details
Search users (keyword)
Search users (filter)
Get subscription definitions
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
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
Register Event in Own Calendar
Create Calendar
Register Event in Specified User's Calendar
Get Email Attachment Information
Download Email Attachment
Delete Event from Specified User's Calendar
Update Event in Specified User's Calendar
Delete Event from My Calendar
Update Event in My Calendar
タスクを作成する(リマインド設定対応)
タスクを作成する(リマインド設定非対応)
Search My Calendar Events
Search Specified User's Calendar Events
Find meeting times
Get calendar view