Review resumes submitted through a form with OpenAI and add them to Google Sheets
Review resumes submitted through a form with OpenAI and add them to Google Sheets
Launch this workflow to connect
OpenAI &
Google Sheets
!
■Overview
Reviewing, evaluating, and managing the many resumes submitted through forms can be a time-consuming and labor-intensive part of the hiring process. This workflow uses OCR to automatically read resumes submitted through a form, has OpenAI review their contents, and automatically adds the evaluation results to Google Sheets. Streamline the review process during the early stages of hiring and build a smoother screening workflow.
■Who This Template Is For
- Recruiters who spend significant time screening resumes
- HR leaders who want to automate the initial evaluation of application materials using OpenAI
- Anyone looking to streamline centralized applicant data management with Google Sheets
■Benefits of Using This Template
- When a resume is submitted through a form, OpenAI automatically reviews it and records the results in Google Sheets, reducing the time spent on manual evaluation and data entry.
- Because OpenAI reviews resumes based on predefined criteria, this workflow helps reduce variations in evaluations, prevent the screening process from relying on individual judgment, and standardize operations.
■Workflow Steps
- First, connect Google Sheets and OpenAI to Yoom.
- Next, select Form Trigger as the trigger and configure the workflow to start when a resume is submitted.
- Next, select the OCR feature as an operation to extract text from the resume file (image or PDF) submitted through the form.
- Next, configure OpenAI's "Generate text (Chat completion)" action as an operation to review the resume based on the content extracted by OCR.
- Finally, configure Google Sheets' "Add a record" action as an operation to append the applicant's information and OpenAI's review results.
※ "Trigger": An action that starts the workflow. "Operation": An action that processes data within the workflow after the trigger starts.
■Customization Options
■Customization Options
- When configuring the action to add a record in Google Sheets, specify the ID of the spreadsheet where you want to record applicant information and the sheet name (tab name) within that spreadsheet.
■Notes
- Connect both Google Sheets and OpenAI to Yoom.
- Files up to 300 MB can be downloaded. Depending on the app specifications, the limit may be lower than 300 MB.
- For details on the file size limits supported by the trigger and each operation, see File Size Limits.
- OpenAI charges for ChatGPT API usage based on the number of tokens used during API communication. Please note that an error will occur if payment cannot be made when using the API.
- To run ChatGPT (OpenAI) actions, you need to subscribe to a paid OpenAI API plan. (You must be able to make payments when the API is used.)
- OCR may not be able to read data containing more than 6,500 characters or text that is too small. Please take note of this limitation.
Check Out Similar Templates!
Create a task in Asana, generate a detailed description of the task using OpenAI, and add it as a comment.
This is a business workflow that utilizes Yoom to add automatically generated detailed descriptions from OpenAI as comments to tasks in Asana. It enhances the overall work efficiency of the team.
Transcribe Zoom call content, summarize it with OpenAI, and add it to Google Sheets.
This is a workflow that automatically transcribes the content of Zoom calls, summarizes it with OpenAI, and adds it to a Google Spreadsheet. It efficiently organizes the call content, making it easy to manage and utilize later.
See more
About the Apps
OpenAI
Related apps
Templates using
OpenAI
Create a task in Asana, generate a detailed description of the task using OpenAI, and add it as a comment.
This is a business workflow that utilizes Yoom to add automatically generated detailed descriptions from OpenAI as comments to tasks in Asana. It enhances the overall work efficiency of the team.
The workflow involves OpenAI analyzing data received from Zoho Forms and automatically sending emails. This saves time in drafting responses and enables quick and consistent communication.
Summarize the chat content of Microsoft Teams using OpenAI and send an email to stakeholders via Outlook.
This is a business workflow that summarizes Microsoft Teams chats using OpenAI and sends emails to stakeholders via Outlook. It enhances information sharing efficiency and saves time.
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.
About the apps you use
OpenAI
At Yoom, you can utilize OpenAI's API without any coding. By integrating OpenAI with Yoom, you can instruct OpenAI using information from the Yoom database and various SaaS platforms. For example, you can automate various tasks using OpenAI, such as summarizing meeting minutes, extracting text from email content, and creating product descriptions.
see detailsTemplates
Create a task in Asana, generate a detailed description of the task using OpenAI, and add it as a comment.
This is a business workflow that utilizes Yoom to add automatically generated detailed descriptions from OpenAI as comments to tasks in Asana. It enhances the overall work efficiency of the team.
Create a task in Asana, generate a detailed description of the task using OpenAI, and add it as a comment.
The workflow involves OpenAI analyzing data received from Zoho Forms and automatically sending emails. This saves time in drafting responses and enables quick and consistent communication.
Generate responses to the contents of Zoho Forms using OpenAI and send them via email.
Summarize the chat content of Microsoft Teams using OpenAI and send an email to stakeholders via Outlook.
This is a business workflow that summarizes Microsoft Teams chats using OpenAI and sends emails to stakeholders via Outlook. It enhances information sharing efficiency and saves time.
Summarize the chat content of Microsoft Teams using OpenAI and send an email to stakeholders via Outlook.
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.
No-Code API Actions
Executable API actions
Flowbot triggers
When a Row Is Added
When a Row Is Updated
Flowbot operations
Generate Image from Text
Upload File
Create Assistant (Assistants API V2)
Create Thread (Assistants API V2)
Add Message to Thread (Assistants API V2)
Run Assistant (Assistant API V2)
Get Latest Messages in Thread (Assistant API V2)
Create Vector Store (Assistant API V2)
Add Files to Vector Store (Assistant API V2)
Delete Vector Store (Assistant API V2)
Check Execution Status (Assistants API V2)
Text Generation (Chat Completion)
Run Web Search (Responses API)
Generate Model Response (Responses API)
Retrieve Model Response (Responses API)
Delete Model Response (Responses API)
Cancel Model Response (Responses API)
List Model Responses (Response API)
Flowbot triggers
There is no action.
Flowbot operations
Generate Image from TextUpload FileCreate Assistant (Assistants API V2)Create Thread (Assistants API V2)Add Message to Thread (Assistants API V2)Run Assistant (Assistant API V2)Get Latest Messages in Thread (Assistant API V2)Create Vector Store (Assistant API V2)Add Files to Vector Store (Assistant API V2)Delete Vector Store (Assistant API V2)Check Execution Status (Assistants API V2)Text Generation (Chat Completion)Run Web Search (Responses API)Generate Model Response (Responses API)Retrieve Model Response (Responses API)Delete Model Response (Responses API)Cancel Model Response (Responses API)List Model Responses (Response API)Generate VideoConvert Audio to TextEdit ImageEdit Image (GPT Image Model)Edit Image (Using File ID)Upload File (by Purpose)Create SessionRun SessionRetrieve Session
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 RowsMore inspiration for you
Discover step-by-step guides for automating your work using the apps featured in this workflow!
