Convert image content to text using AI and add it to Google Sheets when an image is sent in Gmail.
Launch this workflow to connect
Gmail &
Google Sheets &
OCR
!
■Overview
Manually transcribing information from image files—such as invoices or business cards—received in Gmail is time-consuming. With this workflow, simply receiving specific emails lets AI convert the content of attached images into text and automatically record it in Google Sheets.
■Who should use this template
- Accounting or sales teams who manually enter data from image attachments received in Gmail
- Anyone who wants to use OCR to streamline how they manage and leverage image data
- Anyone looking to reduce rework and input errors caused by manual data entry
■Benefits
- Automatically convert images received in Gmail to text and save them to a specified Google Sheet, reducing time spent on manual transcription
- Prevent human errors common with manual work—such as copy mistakes or missing entries—and keep data accurate
■Workflow steps
- First, connect Gmail and Google Sheets to Yoom
- Next, choose Gmail as the trigger and set the action "When an email with a specific label is received"
- Then, in an operation, add the OCR action "Read any image or PDF" to read the image files attached to the received email
- Finally, in an operation, add the Google Sheets action "Add record" and add the OCR-converted information to the specified spreadsheet
※「trigger」:the action that starts the flow、「operation」:the action that runs within the flow after the trigger fires
■Customization tips for this workflow
- In the OCR action settings, specify the fields you want to extract as text—such as invoice date and amount, or the company name on a business card
- In the Google Sheets action settings, specify the target spreadsheet ID and sheet name where the extracted data will be recorded
■Notes
- Connect Gmail and Google Sheets to Yoom
- You can choose trigger polling intervals of 5, 10, 15, 30, or 60 minutes
- Minimum polling intervals vary by plan
- Downloadable file size limits vary by operation and app
- For details on file size limits for the trigger and each operation, see 「File size limits」
- OCR may not read text if characters are small or if the data exceeds 6,500 characters
Check Out Similar Templates!
Add Gmail inbox content to Notion
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
When you receive an email in Gmail that matches a specific keyword, generate text with DeepSeek and add a label to a specific Gmail message
When an email containing specific keywords arrives in Gmail, DeepSeek automatically generates a reply and applies a label. Reduce time spent on manual sorting and initial responses while ensuring no email is missed.
See more
About the Apps
Gmail
Related apps
Templates using
Gmail
Activate the flow bot at the end of each month to send an email in Gmail.
This is a flow that is triggered at the end of each month to send an email via Gmail. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
Add Gmail inbox content to Notion
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
Google Sheets
Related apps
Templates using
Google Sheets
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
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.
Add order information to WooCommerce when a row is added in Google Sheets.
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.
Add a new tab to the Google Spreadsheet at the beginning of each month.
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.
OCR
Templates using
OCR
About the apps you use
Gmail
Yoom allows you to integrate with Gmail's API without code and automate email sending from Gmail. You can automatically create and send invoices and contracts via Gmail, or automatically reply to inquiries.
see detailsTemplates
Activate the flow bot at the end of each month to send an email in Gmail.
This is a flow that is triggered at the end of each month to send an email via Gmail. It can be used for various purposes such as aggregation processing in Microsoft Excel or monthly invoice issuance.
Activate the flow bot at the end of each month to send an email in Gmail.
Add Gmail inbox content to Notion
This is a business workflow that automatically adds Gmail received content to Notion. It streamlines email management and information organization, eliminating the need for manual transcription. By ensuring important emails are securely saved and shared, it enhances the team's operational productivity.
Add Gmail inbox content to Notion
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
This is a flow to automatically sort emails received in Gmail by keywords and forward them to the appropriate person in charge. By using this flow, you can detect specific keywords and forward them to the appropriate person. This will likely lead to improved customer response times.
Automatically sort incoming emails in Gmail by keywords and forward them to the person in charge.
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 detailsTemplates
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
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.
A workflow to generate invoices using Google Sheets with the information entered in the form, and send them after approval.
Add order information to WooCommerce when a row is added in Google Sheets.
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.
Add order information to WooCommerce when a row is added in Google Sheets.
Add a new tab to the Google Spreadsheet at the beginning of each month.
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.
Add a new tab to the Google Spreadsheet at the beginning of each month.
OCR
もちろんです。以下が翻訳されたテキストです。
---
```
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>サンプルページ</title>
</head>
<body>
<header>
<h1>ようこそ</h1>
<nav>
<ul>
<li><a href="#home">ホーム</a></li>
<li><a href="#about">私たちについて</a></li>
<li><a href="#contact">お問い合わせ</a></li>
</ul>
</nav>
</header>
<main>
<section id="home">
<h2>ホーム</h2>
<p>これはサンプルのホームページです。</p>
</section>
<section id="about">
<h2>私たちについて</h2>
<p>私たちはウェブ開発を専門としています。</p>
</section>
<section id="contact">
<h2>お問い合わせ</h2>
<p>お問い合わせはメールでお願いします。</p>
</section>
</main>
<footer>
<p>著作権 © 2023 サンプル会社</p>
</footer>
</body>
</html>
```
---
この翻訳でHTML構造はそのままに、テキストのみを英語に変換しました。
see detailsTemplates
No-Code API Actions
Executable API actions
Workflow triggers
Workflow operations
Workflow triggers
Workflow operations
Workflow triggers
Workflow operations
Workflow triggers
There is no action.
Workflow operations
There is no action.
More inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!