Use OCR to extract text from business card images uploaded to Box, translate it with AI, and add it to Google Sheets

■Overview

Do you spend too much time managing business cards received at overseas trade shows or business meetings? Reviewing each image, translating the information manually, and entering it into your customer list is time-consuming and prone to errors. With this workflow, simply upload business card images to Box to automate everything from OCR-based text extraction and AI-powered translation to adding the data to Google Sheets—helping you resolve these challenges smoothly.

■Who This Template Is For

• Anyone who spends significant time digitizing and translating business card data received from customers overseas
• Anyone who uses Box and Google Sheets but feels that manually managing information is becoming inefficient
• Anyone who wants to prevent data entry errors and build an accurate global customer list

■Benefits of Using This Template

• Automatically perform OCR, translation, and data entry by simply uploading business card images to Box, reducing the time spent on manual work.
• Reduce the risk of human error, such as data entry mistakes and omissions when manually transcribing or translating information.

■Flowbot Steps

1. First, connect Box and Google Sheets to Yoom.
2. Next, select Box as the trigger and set the action to “When a file is uploaded to a folder.”
3. Then, set the Box “Download a file” action as an operation to process the uploaded file.
4. Next, use the OCR “Extract text from images and PDFs” action to extract text from the business card image.
5. Next, set the AI “Translate” action to translate the extracted text into the specified language.
6. Next, use the OCR “Extract data from text” action to extract the required fields from the translated text.
7. Finally, set the Google Sheets “Add a record” action to add the extracted data to the specified sheet.

※“Trigger”: An action that starts the flow. “Operation”: An action that processes data within the flow after the trigger starts.

■Customization Options

• In the Box trigger settings, specify the folder where business card images will be uploaded using its content ID.
• For the file download action, you can specify the content ID of the file detected by the trigger.
• When extracting text with the OCR feature, you can freely configure the fields to extract, the AI model to use, the source language, and more.
• When translating with the AI feature, specify the text to translate and the target language.
• When extracting data from the translated text, you can freely configure the fields to extract, such as the company name and contact name.
• When adding a record to Google Sheets, you can configure the target spreadsheet ID, tab name, values to write, and more.

■Notes

• Connect both Box and Google Sheets to Yoom.
• The AI operations for OCR and audio transcription are available only on the Team and Success plans. Please note that if you are on the Free or Mini plan, the configured Flowbot operation will result in an error.
• Paid plans, including the Team and Success plans, offer a two-week free trial. During the free trial, you can use apps and AI features (operations) that are subject to plan restrictions.