Use OCR to extract text from screenshots of web pages stored in Box and add it to Google Sheets
Use OCR to extract text from screenshots of web pages stored in Box and add it to Google Sheets
Launch this workflow to connect
Google Sheets &
Box
!
■Overview
Do you spend too much time manually extracting information from screenshots of web pages and entering it into Google Sheets after saving them to Box? Manual work like this can also lead to human errors, such as data entry mistakes.
With this workflow, when an image file such as a screenshot is uploaded to a specific Box folder, AI automatically extracts the text and adds the information to Google Sheets.
■Who This Template Is For
- Anyone who collects information or manages data using Box and Google Sheets
- Anyone who wants to streamline transcribing and transferring text from website screenshots
- Anyone who wants to automate manual data entry by leveraging OCR
■Benefits of This Template
- Simply upload a file to Box to automate everything from OCR-based text extraction to adding the data to Google Sheets, reducing the time spent on manual work.
- Eliminating manual data entry helps prevent human errors such as incorrect entries and missing information.
■Workflow
- First, connect Box and Google Sheets to Yoom.
- Next, select Box as the trigger and set the action to “When a file is uploaded to a folder.”
- Then, set the Box “Download a file” action as an operation and specify the file detected by the trigger.
- Next, set the AI feature’s “Extract text from an image or PDF” action as an operation to extract text from the downloaded file.
- Finally, set the Google Sheets “Add a record” action as an operation and add the extracted text to the specified sheet.
* “Trigger”: An action that starts the workflow. “Operation”: An action that processes data within the workflow after the trigger starts.
■Customization Options
- In the Box trigger settings, choose which folder should trigger the workflow when a file is uploaded.
- In the OCR action, you can choose which fields to extract from the file, as well as the AI model and language to use.
- In the Google Sheets “Add a record” action, specify the spreadsheet ID, sheet ID, and values to add to each column.
■Notes
- Connect Box and Google Sheets to Yoom.
- AI operations for OCR and audio transcription are available only on the Team and Success Plans. Please note that configured workflow operations will result in an error on the Free and Mini Plans.
- Paid plans, including the Team and Success Plans, come with a 2-week free trial. During the free trial, you can use restricted apps and AI features (operations).
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.
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.
See more
About the Apps
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.
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.
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.
Box
Related apps
Templates using
Box
By simply adding files to Box, they are automatically uploaded to Google Drive™, creating a business workflow. This streamlines file management across multiple clouds and eliminates the need for manual tasks.
The workflow automatically adds file information stored in Box to Notion. It facilitates smooth information sharing and reduces the hassle of management tasks.
This is a business workflow that automatically generates Box folders based on content posted in Microsoft Teams. It streamlines file organization and access management, achieving centralized information and rapid sharing.
About the apps you use
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.
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.
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.
Box
Yoom allows you to integrate with Box's API without any coding, enabling the automation of various tasks. You can automatically store files attached to emails in Box, and receive notifications in Slack or Chatwork when files are uploaded to Box.
see detailsTemplates
By simply adding files to Box, they are automatically uploaded to Google Drive™, creating a business workflow. This streamlines file management across multiple clouds and eliminates the need for manual tasks.
Add files added to Box to Google Drive™
The workflow automatically adds file information stored in Box to Notion. It facilitates smooth information sharing and reduces the hassle of management tasks.
Add file information stored in Box to Notion
This is a business workflow that automatically generates Box folders based on content posted in Microsoft Teams. It streamlines file organization and access management, achieving centralized information and rapid sharing.
Create a folder in Box based on the content posted in Microsoft Teams.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Row Is Added
When a Row Is Updated
When a File Is Uploaded to a Folder
When a Comment Is Created
When a File Name Is Changed
When a Comment Is Updated
When a Selected Event Occurs
When a File in a Folder Is Deleted
Flowbot operations
Set a Value in a Cell
Get Values
Clear Values
Create a New Spreadsheet
Copy a Sheet (Tab)
Add a New Sheet (Tab)
Delete Sheet (Tab)
Replace Values
Update Sheet Name
Delete Rows
Get Spreadsheet Info
Get Sheet Names
Apply a Formula to a Range
Enter Values in a Range
Embed an Image in a Cell
Sort by Specific Column
Hide a Sheet
Add a Note to the Specified Cells
Flowbot triggers
When a Row Is AddedWhen a Row Is Updated
Flowbot operations
Set a Value in a CellGet ValuesClear ValuesCreate a New SpreadsheetCopy a Sheet (Tab)Add a New Sheet (Tab)Delete Sheet (Tab)Replace ValuesUpdate Sheet NameDelete RowsGet Spreadsheet InfoGet Sheet NamesApply a Formula to a RangeEnter Values in a RangeEmbed an Image in a CellSort by Specific ColumnHide a SheetAdd a Note to the Specified CellsInsert ColumnsDelete ColumnsWrite Values to Multiple ColumnsAdd Rows
Flowbot triggers
When a File Is Uploaded to a FolderWhen a Comment Is CreatedWhen a File Name Is ChangedWhen a Comment Is UpdatedWhen a Selected Event OccursWhen a File in a Folder Is Deleted
Flowbot operations
Download FileGet List of Items in FolderCreate FolderSearch Content in Specific FoldersCopy FileUpload FileGet File InformationUpload File VersionCreate New UserAdd User to GroupDelete Registered WebhookRename FolderMove FolderGet Folder InformationGet List of Collaboration Information for a Specific FolderUpdate CollaborationGet Collaboration InformationRename FileMove FileCopy FolderCreate CollaborationSearch ContentAdd Shared Link to FolderAdd or Update File TagsGet File Tag InformationCreate a Shared Link for a FileCreate Metadata Instance on FileUpdate File Metadata InstanceGet File Metadata InstanceDelete File Metadata InstanceGet Group ListDelete FileMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
