AI Resume Processing Workflow using Google Forms, Google Drive, Google Sheets & Gmail

This workflow automatically processes resumes submitted through Google Forms, downloads the resume file from Google Drive, uses GPT models (via Needle AI) to extract structured candidate data, stores the extracted information in Google Sheets, and sends a professional HTML email notification via Gmail. It eliminates manual resume screening and ensures structured, searchable candidate records.

Quick Implementation Guide (Fast Setup)

1. Connect Google Forms, Google Drive, Google Sheets, and Gmail via Pipedream connectors.
2. Enter your:
   • formId
   • sheetId
   • worksheetId
   • Recipient email address
3. Ensure your Google Form includes a resume upload field (PDF).
4. Map the uploaded file ID dynamically to the Google Drive download node.
5. Activate the workflow.

Once activated, every new form submission will:

Extract resume data → Add it to Google Sheets → Send HR a notification email.

What It Does

This workflow automates resume intake and processing from start to finish. When a candidate submits a Google Form with a resume attachment, the workflow immediately triggers and retrieves the uploaded file from Google Drive. The resume file (PDF) is then sent to GPT via Needle AI, where structured candidate details are extracted.

The AI extracts:

• Full Name
• Email
• Phone
• Key Skills (comma separated)
• Years of Experience
• Current Job Title
• Education
• A 5–6 line Professional Summary

The extracted data is returned in JSON format and then added to a Google Sheet. Finally, a professionally formatted HTML email notification is sent to the configured recipient with the candidate’s details.

This creates a streamlined, AI-powered candidate intake system without manual resume review.

Who’s It For

This workflow is ideal for:

• HR departments
• Recruiters
• Staffing agencies
• Talent acquisition teams
• Startups hiring at scale
• Companies receiving resumes via Google Forms
• Organizations that want structured candidate data automatically

Prerequisites

Before using this workflow, ensure you have:

• A Google account
• A Google Form with:
  • Resume upload field (PDF format recommended)
• Access to Google Drive
• A Google Sheet created to store candidate data
• Gmail access for sending notifications
• Connected Pipedream connectors for:
  • Google Forms
  • Google Drive
  • Google Sheets
  • Gmail
• Needle AI access with GPT model enabled

How to Use & Setup

Follow these steps carefully to configure the workflow correctly.

1) Google Forms – New Form Answer (Trigger)

Node Type: pipedream_google_forms_new_form_answer

Setup Steps:

• Create and connect a Google Forms connector.
• Replace your_form_id with your actual Google Form ID.
• Ensure your form includes a resume upload field.
• Confirm file uploads are stored in Google Drive.

This node triggers the workflow every time a new form submission is received.

2) Google Drive – Download File

Node Type: pipedream_google_drive_download_file_v1

Setup Steps:

• Create and connect a Google Drive connector.
• Ensure the uploaded resume is in PDF format.
• Map the fileId dynamically from the Google Form response.
• Keep:
  • mimeType: application/pdf
  • getBufferResponse: true

This node downloads the uploaded resume file for AI processing.

3) Needle AI – Resume Data Extraction (GPT)

Node Type: needle_ai_v1

Configuration Details:

• Model: gpt
• Temperature: 0
• Run Mode: item
• Max Steps: 1

AI Prompt Behavior

The AI is instructed to:

• Act as an HR assistant
• Extract structured fields from the resume
• Return output in strict JSON format:

{
  "full_name": "",
  "email": "",
  "phone": "",
  "skills": "",
  "experience_years": "",
  "job_title": "",
  "education": "",
  "summary": ""
}

Temperature is set to 0 for consistent and predictable extraction results.

4) Google Sheets – Add Column

Node Type: pipedream_google_sheets_add_column_v1

Setup Steps:

• Create and connect a Google Sheets connector.
• Replace:
  • your_sheet_id
  • your_worksheet_id with actual values.
• The node:
  • Adds a new column
  • Inserts candidate fields in separate rows within that column

Ensure your sheet structure is ready to receive:

• Full Name
• Email
• Phone
• Skills
• Experience Years
• Job Title
• Education
• Summary

5) Gmail – Send Email Notification

Node Type: pipedream_gmail_send_email_v1

Setup Steps:

• Connect a Gmail connector.
• Set:
  • to → HR recipient email
  • subject
• Keep bodyType as html

The email will:

• Notify HR that a resume was processed
• Include structured candidate information
• Be formatted professionally in HTML

How To Customize Nodes

You can modify the workflow as follows:

Modify AI Extraction Fields

Edit the Needle AI prompt to:

• Add LinkedIn URL
• Extract certifications
• Extract location
• Extract portfolio links

Change Google Sheets Structure

Instead of adding a column, modify to:

• Add a new row per candidate
• Create separate columns per field

Customize Email Formatting

• Change HTML styling
• Add company branding
• Include conditional formatting
• Add attachments

Change AI Model

Replace gpt with another supported model if required.

Add-ons

You can extend this workflow with:

• ATS integration
• Slack notifications
• Candidate scoring logic
• Auto-shortlisting rules
• Resume duplicate detection
• CRM integration
• Auto-reply email to candidates
• Interview scheduling automation
• Google Drive folder organization
• Webhook integration

Use Case Examples

This workflow supports many real-world hiring scenarios, including:

1. Startup hiring funnel automation
2. Recruitment agency resume intake
3. Campus hiring programs
4. Internal HR screening
5. Remote hiring pipelines

There can be many more use cases depending on business needs and integrations.

Troubleshooting Guide

Need Help?

If you need assistance with:

• Connector setup
• Dynamic field mapping
• Advanced AI customization
• Workflow optimization
• ATS or CRM integration
• Custom reporting dashboards
• Enterprise-grade automation

WeblineIndia can help you design, deploy and scale intelligent automation workflows tailored to your business.

Whether you want to enhance this workflow or build a fully customized hiring automation system, our needle automation experts are ready to assist.