Use OCR to extract mill sheet data uploaded to Box and add it to Google Sheets

Launch this workflow to connect Google Sheets !

■Overview

Do you find it time-consuming to manually review mill sheets (steel inspection certificates) managed in Box and transfer their data to another system? With this workflow, when a mill sheet is uploaded to Box, AI OCR automatically extracts the text and adds the data to Google Sheets. Automate repetitive data entry and streamline your operations.

■Recommended for

Manufacturing and quality control teams that manually review and transfer the contents of mill sheets stored in Box
Anyone experiencing issues such as data entry errors or omissions when entering mill sheet data
Anyone looking to digitize and manage documents received as paper or PDF files more efficiently

■Benefits of using this template

Automate everything from OCR processing to data entry when a file is uploaded to Box, reducing the time spent on manual tasks.
Eliminate manual data entry to prevent human errors such as incorrect entries and missing fields, improving data accuracy.

■Flowbot steps

First, connect Box and Google Sheets to Yoom.
Next, select Box as the trigger, set the action to “When a file is uploaded to a folder,” and specify the folder to monitor.
Then, set the Box “Download a file” action as an operation and specify the file detected by the trigger.
Next, select the AI feature’s “Extract text from images and PDFs” operation to extract text from the downloaded file.
Finally, set the Google Sheets “Add a record” action as an operation and add the extracted information to the specified sheet.

“Trigger”: An action that initiates a flow. “Operation”: An action that processes data within the flow after the trigger is activated.

■Customization options

The AI OCR feature used in this workflow (the “Extract text from images and PDFs” operation) is available on Yoom’s Team and Success plans. Please note that it is not available on the Free or Mini plans.
Features available on paid plans, such as the Team and Success plans, can be tried during the 2-week free trial. Take this opportunity to experience how they work in practice.

Check Out Similar Templates!

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.

View template

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.

View template

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.

View template

Use OCR to extract text from PDFs and images uploaded to Box, then add the results to Google Sheets

Upload files to Box to automatically extract text with OCR and log it in Google Sheets. Reduce manual data entry time, prevent input errors, and keep your document management organized.

View template

Add a record to Notion when a row is added in Google Sheets.

In this workflow, simply adding a new row in Google Sheets automatically creates a corresponding record in Notion. This automation eliminates the need for manual data entry and dual management, ensuring consistency of information.

View template

Add a record to Salesforce when a row is added in Google Sheets.

This is a flow that adds a record to Salesforce when a row is added in Google Sheets. By referencing the registration details in Google Sheets, you can also register them in Salesforce, preventing manual errors and saving effort.

View template

About the Apps

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.

Related apps