Automatically activate on a specified day each month, extract the companies to be billed from YoomDB, and use an Excel invoice template to automatically send invoices.

No items found.

◼️Overview‍

This is a flow to automate the monthly invoice sending process.

Customer management is conducted using Excel and various databases, and it can be implemented if the invoice format is created in Excel.‍

‍

◼️Preparation‍

・Create a template document for issuing invoices in Excel.

・Set up the basic customer information, detailed information, and items indicating billing targets in the Yoom database.

・Excel sheet used in Flowbot (view-only permission. Please copy if you wish to use it).
https://yoominc-my.sharepoint.com/:x:/g/personal/demoyoominconmicrosoftcom/EW1ehdQKAudBtHDSCqJ0U4IB2uMwf6gMwEbpOc_WrIWsw?e=UuE3Wd

‍

◼️Creation Method

① Select the schedule trigger, configure the following settings, and save.

・Schedule setting: Specify date

・Day: Enter any date (input as half-width numbers like 1 or 10)

・Time: Enter any time (input as half-width numbers like 9 or 15)

※ You cannot set minutes in the date specification.

※ For details on the schedule trigger, please refer here. https://intercom.help/yoom/ja/articles/7983075

② Press the + mark under the trigger, select Yoom from the operation to manipulate the database, configure the following settings, test, and save.

・Execution action: Retrieve multiple records (up to 500)

・Project/Database/Table: Set the hierarchy of the project or database where the prepared target table is located.

・Condition for the records you want to retrieve: On the next page, select the database item from the left frame and search for the target record by setting the item equal to ○○.

・Detailed setting: Turn OFF "Make the operation an error if no records matching the condition are found."

③ Press the + mark, select the operation to branch, configure the following settings, and save.

・Operation: Select the operation from ②.

・Output: Set one of the outputs obtained in ②.

・Condition: Set the condition that the output is empty.

・Value: Leave it blank. By setting it this way, the Flowbot will end if the target does not exist.

※ For details on the branching operation, please refer here. https://intercom.help/yoom/ja/articles/5464146

④ Press the + mark, select the operation to repeat the same process, configure the following settings, and save.

・Operation: Select the operation from ②.

・Output: Set the unique value (non-duplicate value like ID) obtained in ②. If using YoomDB, the Yoom record ID will always be a unique ID, so use that.

※ For details on the setting to repeat the same process, please refer here. https://intercom.help/yoom/ja/articles/6265153

⑤ Press the + mark in the loop direction, select Yoom from the operation to manipulate the database, configure the following settings, test, and save.

・Execution action: Retrieve a record

・Project/Database/Table: Select the same table as in ②.

・Condition for the records you want to retrieve: On the next page, set the left frame to the unique value item set in ④ (Yoom record ID if using YoomDB) and retrieve the record by setting it equal to the output of {{〇〇 loop variable}} obtained in ④. By doing this, you will re-retrieve records one by one using the unique value obtained in ④.

⑥ Press the + mark, select Excel from the operation to issue documents, configure the following settings, test, and 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 from the candidates.

・File name (optional): If the item is not displayed in the item ID, enter the file name here and select the item ID again.

・Folder ID for storage: Select the folder ID from the candidates where the document will be stored after issuance.

・Folder name for storage (optional): If the item is not displayed in the folder ID, enter the folder name here and select the folder ID again.

・Output file name: Set any file name. You can also embed the value obtained in ④ (embedding of output). ・String to be replaced: Embed the value obtained in ④ for the corresponding string.‍

※ For the setting method, please refer here. https://intercom.help/yoom/ja/articles/8237765

※ For embedding of output, please refer here. https://intercom.help/yoom/ja/articles/8223528

※ If the site ID is not displayed in SharePoint, please refer here. https://intercom.help/yoom/ja/articles/9003081

④ Press the + mark, select any email tool from the operation to send emails, configure the following settings, and save.

・To: Click the field and embed the address obtained in the record retrieval of ④.

・Subject/Body: Enter any value. As before, you can also embed the value obtained in ④.

・Attachment: Press add attachment, use the output, and select the issued document from the candidates.

・Test: You can also 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. Below is a reference guide for integration.

※ There may be no detailed guide available for apps that can be integrated simply. https://intercom.help/yoom/ja/collections/3041779

このテンプレートを試してみる

How to request materials and apply for a demo

Here

Here are some Similar Templates!

Read business card data using AI-OCR and store it in Excel.

When you upload business card data to the form, the AI operation automatically extracts the necessary information from the business card and stores it in Excel. Then, a workflow is set up to automatically send an email to the specified recipient.

See details

Extract information from the body of the email and store it in Microsoft Excel.

Extract arbitrary information from the body of an email using AI and store the information in Excel.‍

See details

Analyze the content of the application email using AI, create a quotation in Microsoft Excel, and send it via Outlook.

When a response is submitted to the application form, data is extracted using AI to create a quotation from a Microsoft Excel template, which is then sent via Outlook email. This flow significantly reduces the time spent manually creating and sending quotations, thereby improving operational efficiency.

See details

Add the content answered in the form to a Microsoft Excel sheet, and simultaneously add it to another sheet.

This flow adds the responses from the Yoom form to a Microsoft Excel sheet and simultaneously adds them to another sheet. It allows you to organize data in a separate sheet while collecting it and extract only the necessary information to another sheet.

See details

Store responses in a Microsoft Excel database when they are entered and submitted in a Google Form.

This is a flow that adds new responses from Google Forms to a Microsoft Excel database (table). By linking Google Forms with Microsoft Excel, when a form response is submitted, the response content can be added to Microsoft Excel without any omissions or missing information. Additionally, depending on the settings, it is possible to branch the route according to the form response content and add information to another Microsoft Excel based on the response content.‍

See details

Store form responses in an Excel database.

Automatically store the responses from input forms created with Yoom into an Excel database (table). Feel free to modify the form fields and the destination Excel file as needed.

See details

See all templates