AI Resume Parser to JSON & Sheets

What This Agent Does

This Resume Processing Agent automates the entire workflow of collecting, analyzing, and organizing resume submissions. When a candidate submits their resume URL through a simple form, the agent automatically fetches the content, intelligently extracts key information using AI, and stores the structured data in Google Sheets for easy recruitment tracking and analysis.

Key benefits include:

• Eliminate manual data entry – Save hours by automatically parsing resume information instead of copying and pasting details
• Standardized data collection – Every resume is analyzed consistently, making candidate comparison effortless
• Real-time organization – Submissions appear instantly in your Google Sheets, keeping your recruitment pipeline always current
• Intelligent extraction – AI-powered analysis captures essential details like skills, experience, and qualifications with remarkable accuracy

Perfect for:

• Recruiting teams managing high-volume applications
• HR departments streamlining candidate screening
• Talent acquisition platforms automating intake processes
• Career fairs and recruitment events collecting candidate information

Who Is It For

This agent is ideal for HR professionals, recruiters, and hiring managers who want to modernize their application process. Whether you're a startup receiving your first wave of applications or an enterprise managing thousands of candidates, this workflow eliminates tedious manual work and creates a clean, searchable database of qualified prospects.

You'll benefit most if you:

• Receive resume submissions regularly
• Want to maintain organized candidate records
• Need to quickly identify key qualifications
• Prefer automated workflows over manual data entry
• Use Google Sheets for recruitment tracking

Required Integrations

Browser Automation

Why it's needed: This integration fetches the actual content from resume URLs submitted by candidates. Since resumes are often hosted on various platforms (personal websites, cloud storage, portfolio sites), Browser Automation reliably retrieves the webpage content so the AI can analyze it.

Setup steps:

1. Navigate to Integrations in your TaskAGI dashboard
2. Search for Browser Automation and click Connect
3. Review the permissions requested (webpage content access)
4. Click Authorize to enable the integration
5. Verify the connection shows Active status

How to obtain credentials: Browser Automation typically requires no API key – it uses your TaskAGI account permissions to access public web content. If prompted for additional setup, follow the in-app guidance.

Configuration in TaskAGI:

• The integration is automatically available for the "Fetch Resume Content" node
• No additional API keys needed
• Ensure your TaskAGI account has internet access enabled

OpenAI

Why it's needed: This integration powers the intelligent resume parsing. GPT-4o analyzes the raw resume text and extracts structured information like job titles, skills, education, and experience in a consistent format that's perfect for spreadsheet storage.

Setup steps:

1. Visit platform.openai.com and sign in (create an account if needed)
2. Click your profile icon → API keys
3. Click Create new secret key
4. Copy the generated key (it won't be shown again)
5. In TaskAGI, go to Integrations → OpenAI
6. Paste your API key in the API Key field
7. Click Test Connection to verify
8. Click Save when confirmed

How to obtain API keys:

• OpenAI requires a paid account with billing set up
• Visit platform.openai.com/account/billing/overview
• Add a payment method and set usage limits for cost control
• Generate your API key from the API keys section

Configuration in TaskAGI:

• Model: gpt-4o (already configured – this is the latest, most capable model)
• Temperature: Keep default (0.7) for balanced accuracy and creativity
• Max tokens: 2000 (sufficient for resume analysis)

Google Sheets

Why it's needed: This integration stores all extracted resume data in an organized, searchable spreadsheet. Your team can instantly access candidate information, sort by qualifications, and maintain a permanent record of all submissions.

Setup steps:

1. Go to Integrations in TaskAGI → Search for Google Sheets
2. Click Connect with Google
3. Sign in with your Google account (use your organization's account if available)
4. Grant TaskAGI permission to access Google Sheets
5. Click Allow on the permissions screen
6. Return to TaskAGI – you'll see Connected status

How to obtain credentials:

• No manual API key needed – Google OAuth handles authentication
• Ensure you have a Google account with Google Sheets access
• The connected account must have permission to create/edit sheets

Configuration in TaskAGI:

• You'll specify your Google Sheet URL in the workflow configuration (see Configuration Steps below)
• The sheet must already exist before running the workflow
• Ensure the Google account used for integration has edit access to the target sheet

Configuration Steps

Step 1: Set Up Your Google Sheet

Before configuring the workflow, create your destination spreadsheet:

1. Open Google Sheets

2. Click + Create new spreadsheet

3. Name it something descriptive like Resume Submissions 2024

4. Create column headers in the first row:

   • A1: Submission Date
   • B1: Candidate Name
   • C1: Email
   • D1: Phone
   • E1: Current Title
   • F1: Key Skills
   • G1: Years of Experience
   • H1: Education
   • I1: Resume URL

5. Copy the sheet URL from your browser (you'll need this in Step 4)

Step 2: Configure the Form Node

The Submit Resume URL node collects candidate submissions:

1. Click the form node to open its settings

2. Set Form Title to Resume Submission Form

3. Add a form field:

   • Field Type: Text Input
   • Field Label: Resume URL
   • Field Name: resume_url
   • Required: Toggle ON
   • Placeholder: https://example.com/my-resume.pdf

4. Optionally add additional fields:

   • Candidate Name (Text Input)
   • Email Address (Email Input)
   • Phone Number (Phone Input)

5. Click Save Form

Step 3: Configure the Browser Automation Node

The Fetch Resume Content node retrieves the resume:

1. Click the "Fetch Resume Content" node
2. In the URL field, select the variable from the form: {{resume_url}}
3. Set Wait for Page Load: ON (ensures full content loads)
4. Set Timeout: 30 seconds
5. Click Save

Data flow: The form's resume_url output flows into this node's URL input.

Step 4: Configure the OpenAI Node

The Extract Structured Resume node analyzes the content:

1. Click the "Extract Structured Resume" node

2. Verify Model is set to gpt-4o

3. In the Prompt field, ensure it contains:

   Analyze and parse the following resume content into structured data. 
   Extract: Full Name, Email, Phone, Current Job Title, Key Skills (comma-separated), 
   Years of Experience, Education (degree and institution), and any certifications. 
   Format as JSON with these exact keys: name, email, phone, current_title, skills, 
   years_experience, education, certifications.
   
   Resume Content:
   

4. In the Input field, select: {{fetch_resume_content.output}}

5. Click Save

Data flow: The browser automation node's output (resume text) flows into this node's input.

Step 5: Configure the Google Sheets Node

The Save to Google Sheets node stores the data:

1. Click the "Save to Google Sheets" node

2. In Sheet URL, paste your Google Sheet URL from Step 1

3. In Sheet Name, enter Sheet1 (or your sheet's name)

4. Map the extracted data to columns:

   • Column A (Submission Date): {{now()}}
   • Column B (Candidate Name): {{extract_structured_resume.name}}
   • Column C (Email): {{extract_structured_resume.email}}
   • Column D (Phone): {{extract_structured_resume.phone}}
   • Column E (Current Title): {{extract_structured_resume.current_title}}
   • Column F (Key Skills): {{extract_structured_resume.skills}}
   • Column G (Years of Experience): {{extract_structured_resume.years_experience}}
   • Column H (Education): {{extract_structured_resume.education}}
   • Column I (Resume URL): {{resume_url}}

5. Click Save

Data flow: The OpenAI node's extracted data flows into this node, which appends a new row to your sheet.

Testing Your Agent

Test Execution

1. In the TaskAGI workflow editor, click Test Run (top right)
2. The form will appear – fill in test data:
   • Resume URL: Use a publicly accessible resume (try a LinkedIn profile URL or a PDF hosted on Google Drive)
3. Click Submit
4. Watch the execution progress through each node

What to Verify at Each Step

Form Submission:

• ✅ Form accepts the resume URL without errors
• ✅ Data is captured correctly

Browser Automation:

• ✅ Resume content is successfully fetched (check node output)
• ✅ Text is readable and complete

OpenAI Analysis:

• ✅ Structured data is extracted in JSON format
• ✅ All fields (name, skills, experience) are populated
• ✅ Data accuracy looks reasonable

Google Sheets:

• ✅ New row appears in your spreadsheet
• ✅ Data is in the correct columns
• ✅ Formatting is clean and readable

Expected Results and Success Indicators

Successful execution shows:

• All 5 processing nodes complete with green checkmarks
• Resume content displays in the Browser Automation node output
• Structured JSON appears in the OpenAI node output
• New row with all candidate data appears in Google Sheets within 10 seconds
• No error messages in the execution log

Common issues and solutions:

• "Invalid URL" error: Ensure the resume URL is publicly accessible and complete (includes https://)
• Empty extraction: Some PDF formats don't parse well; try a different resume source
• Sheet not updating: Verify the Google Sheet URL is correct and your connected account has edit permissions
• Timeout errors: Increase the Browser Automation timeout to 45 seconds for slower-loading pages

Once testing succeeds, your agent is ready for production use. Share the form link with candidates, and watch as their resumes automatically populate your organized candidate database!