Read the receipt data received from the form, verify the contents, then add it to the spreadsheet and notify via LINE WORKS.

No items found.

■Overview

・The image data of receipts answered in the form is analyzed and added to the database, and notifications are sent to the chat.

・By adding a request to the person in charge in the middle, more reliable data addition is made possible.

■Preparation

・Set the column names of the information in the receipts you want to add to the spreadsheet in advance.

※Column names refer to items like these: "Company Name", "Name", etc.

※Here is an example of an actual spreadsheet▼

https://docs.google.com/spreadsheets/d/1ycU6GwWe9PCK6sHrd0lsZRooa3VxxEWJfJ7N9wl-k/edit#gid=2096323134

■Creation Method

①Select the form trigger from the trigger.

②Prepare a file type question to attach receipt data and various questions such as name and address in the form's question items.

③In the next screen, store and input a demo receipt image and various questions as a sample and save them.

④Press the + mark under the trigger and select the operation to read characters from images/PDFs.

⑤Select "Read Qualified Invoice" from the action and proceed to the next step.

⑥In the file attachment method, select "Use Retrieved Value" and set the receipt file set in the form from the candidates.

⑦For additional items to extract, the following are obtained by default. If you want to add other values such as the receipt date, please input additionally.

※"Issuer's Name", "Issuer's Registration Number", "Transaction Details", "Amount Subject to 10%", "Consumption Tax Subject to 10%", "Amount Subject to 8%", "Consumption Tax Subject to 8%", "Subtotal", "Total"

※If the above default items are not included in the invoice, they will not be obtained.

※Please refer to the detailed setting method here. https://intercom.help/yoom/ja/articles/8679686

⑧Conduct a test, confirm if the values can be obtained, and save.

⑨Press the + mark and select the operation to request a response from the person in charge.

⑩Set an arbitrary person in charge, click the message field, and embed the values obtained in test ⑧ like "Business Name: {{Issuer's Name}}". By doing this, the obtained values are displayed as they are in the request to the person in charge.

※Please refer here for dynamically changing values using output. https://intercom.help/yoom/ja/articles/8223528

※You can also specify the person in charge by email address (external users can be specified) in the person in charge item, and dynamically embed the email address obtained in trigger test ③. By doing this, the respondent can check whether the receipt information analyzed by the image is correct.

⑪Click Add Form and directly input the item names obtained in ⑧ into the items. By doing this, it is possible to inherit the output obtained in ⑧ or use the values modified by the person in charge.

※Please refer here for output inheritance. https://intercom.help/yoom/ja/articles/6780877

⑫Press the + mark, select the spreadsheet from "Operate Database", then select the prepared spreadsheet and set the action to add a record.

⑬On the next page, the pre-set column names will be displayed, so click each column name field and input the items obtained in the operation to request a response from the person in charge in ⑪ into the corresponding column names.

⑭Press the + mark, select LINE WORKS from "Integrate with App", and choose the action to send a message to the talk room.

⑮On the next page, set the BotID and talk room ID, and complete the setting by providing any content in the message content.

※Please refer here for detailed settings of LINE WORKS. https://intercom.help/yoom/ja/articles/6228178

※AI operations are available only in the Team Plan and Success Plan. In the Free Plan and Mini Plan, the operations set in the flow bot will result in an error, so please be careful.

※Paid plans such as Team Plan and Success Plan offer a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations).

How to request materials and apply for a demo
Here
More flowbot templates
Here are some Similar Templates!
Record the contents of the inquiry form in a Google Spreadsheet.
The content submitted through the inquiry form will be recorded in a spreadsheet, and a reply email will be sent automatically. The spreadsheet can include not only the inquiry details but also the reception date and time, as well as the sender's information.‍
Read business card data using AI-OCR and store it in Google Sheets.
When you upload business card data to the form, the AI operation automatically extracts the necessary information from the business card, stores it in a Google Spreadsheet, and sets up a workflow to automatically send an email to the specified recipients.‍
When a schedule is added to Google Sheets, register it in Google Calendar as well.
When an event is added to Google Sheets, this flow retrieves that information and registers the event in Google Calendar as well. By adding information to Google Calendar along with the registration in Google Sheets, it reduces manual operations and prevents missing information additions.
When employee information is added to Google Sheets, register it in HRMOS.
This is a flow for registering employee information in HRMOS when it is added to Google Sheets. By using the registered employee information to register in HRMOS, it reduces manual time. Additionally, using the quoted content prevents human error.‍
When there is a response to the form, add the information to a Google Spreadsheet and send a notification on LINE.
When there is a response to the inquiry form, the information will be added to a Google Spreadsheet and a notification will be sent to the LINE chat room.‍
Add a record to kintone when a row is added in Google Sheets.
This is a flow where a record is added to kintone when a row is added in Google Sheets. Once information is added, the registration to kintone can also be automatically completed based on the added content, eliminating the need for manual input and ensuring the accuracy of the content.‍
See all templates
What is Yoom hyperautomation?
Conventional RPA can only automate simple repetitive tasks, and the setup process was very complicated.
With “hyperautomation,” which combines various technologies such as AI, API, RPA, and OCR, it is possible to automate many tasks that could not be realized until now more easily than before.
Don't Just Connect Apps—Automate Everything
Most tools simply connect one app to another, leaving the complex tasks to you. Yoom goes much further: From document creation and browser automation to OCR and generative AI, Yoom handles it all seamlessly in one platform.

Why settle for basic integrations? Streamline your entire workflow with Yoom’s powerful hyperautomation.
Learn more about Yoom
About the Apps You Use
Google Sheets
Google Sheets
 Templates using
LINE WORKS
LINE WORKS
Templates using
Related apps
No items found.
Templates using
No items found.
About the apps you use
Google Sheets
At Yoom, you can utilize the Google Sheets API without any coding. By integrating Sheets with Yoom, you can automate data entry into spreadsheets and automatically create documents based on spreadsheet templates. Additionally, you can sync spreadsheet information with Yoom's database for various applications.
see details
templates
LINE WORKS
Yoom allows you to integrate with LINE WORKS API without any code, enabling the automation of various tasks. You can automatically send messages and files to LINE WORKS or register events in the LINE WORKS calendar. Additionally, it is possible to link information from various SaaS platforms such as kintone, Salesforce, and CloudSign with LINE WORKS.
see details
templates
templates
No items found.
Similar apps
No items found.
API Actions That can be No-Code
Executable API actions
Flowbot triggers
    Flowbot operations
      Flowbot triggers
        Flowbot operations
          Flowbot triggers
            Flowbot operations
              Flowbot triggers
                Flowbot operations
                  Work Smarter 
                  with Yoom
                  Get started in
                  30 sec!
                  Try for free now!
                  Try for free now!
                  How to request materials and apply for a demo
                  Here
                  See Details