When a Burmese-language file is submitted through Google Forms, extract the text with OCR and add it to Google Sheets

■Overview

Are you spending too much time and effort digitizing documents and image files written in Burmese? Manual data entry is not only time-consuming but also prone to human errors such as transcription mistakes. With this workflow, files in Burmese uploaded to Google Forms are automatically read using OCR, and the extracted content is added to Google Sheets. Automate Burmese OCR processing to improve the accuracy and speed of data entry tasks.

■Who Should Use This Template

• Anyone who manually digitizes Burmese documents and finds the process time-consuming
• Anyone who manages data with Google Forms and Google Sheets and wants to streamline data entry
• Anyone considering business process automation using Burmese OCR

■Benefits of Using This Template

• When a file is submitted through Google Forms, everything from Burmese OCR processing to transferring the data to Google Sheets is automated, reducing the time spent on manual work
• By eliminating the need to manually transfer data, this workflow helps prevent human errors such as input mistakes and missed checks, keeping your data accurate

■Flowbot Process

1. First, connect Google Sheets and Google Forms with Yoom
2. Next, select Google Forms as the trigger and set it to “When a response is submitted to the form”
3. Next, configure Google Drive’s “Download a file” action as an operation to retrieve the file attached to the form
4. Next, configure the OCR operation “Extract text from images and PDFs” to extract Burmese text from the downloaded file
5. Finally, configure Google Sheets’ “Add a record” action to add the extracted text data as a row to the specified spreadsheet

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

■Customization Options

• In the Google Forms trigger settings, enter the ID of the form you want to use
• In the OCR operation, configure the fields to extract based on the format of the documents you want to read
• In the Google Sheets settings, enter the ID and sheet name of the spreadsheet where you want to write the data

■Notes

• ‍‍Connect both Google Forms and Google Sheets with Yoom.
• You can choose a trigger interval of 5, 10, 15, 30, or 60 minutes.
• Note that the shortest available trigger interval varies by plan.
• AI operations for OCR and audio transcription are available only on the Team and Success plans. On the Free and Mini plans, operations in configured Flowbots will result in errors.
• Paid plans, such as the Team and Success plans, include a two-week free trial. During the free trial, you can use apps and AI features (operations) that are otherwise subject to restrictions.
• The maximum downloadable file size is 300 MB. Depending on the app specifications, the limit may be less than 300 MB.
• For details on the file sizes that can be handled by triggers and individual operations, see below.
  See file size limits‍
• For details on how to retrieve response contents when using Google Forms as a trigger, see below.
  See how to retrieve response contents