When a Kannada file is submitted via Google Forms, use OCR to extract the text and add it to Google Sheets

■Overview

Tired of manually transcribing information from images and PDF files written in Kannada? With this workflow, files received through Google Forms are automatically converted into text using OCR and added to Google Sheets. Automate tedious data entry, prevent human errors such as input mistakes, and improve the accuracy and efficiency of your operations.

■Who Should Use This Template

• Anyone who wants to efficiently digitize Kannada documents using OCR
• Anyone who wants to reduce the effort of manual data entry in workflows using Google Forms and Google Sheets
• Anyone who wants to automate routine data entry tasks and focus on more valuable work

■Benefits of Using This Template

• When a file is attached to a Google Form, everything from OCR-based text extraction to transcription is automated, helping you save the time previously spent on manual work.
• Because data is transcribed without manual intervention, this workflow helps prevent human errors such as misreading and missing entries, maintaining data accuracy.

■Workflow Steps

1. First, connect Google Forms and Google Sheets to Yoom.
2. Next, select Google Forms as the trigger and set the action to “When a response is submitted to the form.”
3. Then, set the Google Drive “Download a file” action as an operation and specify the file attached to the form.
4. Next, set the OCR “Extract text from an image or PDF” action as an operation to extract Kannada text from the downloaded file.
5. Finally, set the Google Sheets “Add a record” action as an operation and add the extracted text information to the specified sheet.

■Customization Options

• In the Google Forms trigger settings, enter the ID of the form you want to include in the automation.
• In the OCR operation settings, customize the extraction fields according to the information you want to read from the file.
• In the Google Sheets operation settings, enter the ID and sheet name of the spreadsheet where you want to output the data.

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

■Notes

• Connect both Google Forms and Google Sheets to Yoom.
• You can select a trigger interval of 5, 10, 15, 30, or 60 minutes.
• Note that the shortest available trigger interval varies by plan.
• The AI operations for OCR and audio transcription are available only on the Team and Success plans. On the Free and Mini plans, operations configured in your workflow will result in an error.
• 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 size limits supported by triggers and individual operations, see
  File size limits
• For information on how to retrieve response details when using Google Forms as a trigger, see
  How to retrieve Google Forms responses