When an email arrives, use the OCR function to read the contents of the attached photo and store it in a Google Spreadsheet.
■Overview
This is a flow where, upon receiving an email, the attached photo is read using AI's OCR function, and the extracted content is stored in a Google Spreadsheet.
■Recommended for
1. Those who work on extracting content from images for specific items
・Tax accountants or social insurance labor consultants handling year-end adjustment tasks
・Sales assistants or administrative staff who need to digitize business cards
2. Those who want to reduce manual input work and automate processes
・Owners of small and medium-sized enterprises aiming for operational efficiency
・Administrative or office staff with a lot of data entry tasks
・Marketing personnel conducting operations using digital tools
■Benefits of using this template
・It automatically reads text data from photos and inputs the content, eliminating the need for manual entry.
・The entire process is completed automatically, preventing errors from manual input.
■Notes
・Please link Google Spreadsheet with Yoom in advance.
・AI operations are available only with the Team Plan and Success Plan. For Free Plan and Mini Plan, the operation of the set flow bot will result in an error, so please be aware.
・Paid plans such as the Team Plan and Success Plan offer a two-week free trial. During the free trial, you can use restricted apps and AI functions (operations).
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
Once the billing information is filled out in the form, an invoice will be generated using the Google Spreadsheet invoice template. After that, it will undergo approval by the person in charge, and an email will be sent.
This is a flow for adding order information to WooCommerce when a row is added in Google Sheets. This flow significantly reduces manual effort and saves the time previously spent on registration, allowing you to focus on more important tasks and improving productivity.
You can add a new tab to a Google Spreadsheet at the beginning of each month. By being able to add a new sheet to a specific Google Spreadsheet at the start of each month, you can avoid forgetting to add sheets and prevent unnecessary rework.
When a row is added
When a row is updated
Set a value in a cell
Get values
Clear values
Create a new spreadsheet
Copy a sheet (tab)
Add a new sheet (tab)
Delete Sheet (Tab)
Replace values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get sheet names
Apply a formula to a range
Enter values in a range
Embed an image in a cell
Sort by specific column
Hide a sheet
Add a note to the specified cells
When a row is addedWhen a row is updated
Set a value in a cellGet valuesClear valuesCreate a new spreadsheetCopy a sheet (tab)Add a new sheet (tab)Delete Sheet (Tab)Replace valuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet sheet namesApply a formula to a rangeEnter values in a rangeEmbed an image in a cellSort by specific columnHide a sheetAdd a note to the specified cellsInsert columnsDelete columnsWrite values to multiple columns
