Extract Data from Documents with Dynamic AI Prompts using Google Sheets
This workflow is triggered when a new row is added to a Google Sheet containing a document link. It processes the document (e.g., a PDF resume) by extracting its text content. Using prompts fetched from another Google Sheet, an AI extracts specific fields of information. Finally, the extracted data is updated back into the original Google Sheet row.
Apps Used:
Google Sheets
Google Drive
PDF OCR Reader
OpenAICategories:
How It Works
- 1When a new row is added to a Google Sheet
- 2Download the document (e.g., PDF) from Google Drive linked in the row
- 3Extract text from the document using OCR
- 4Get specific AI prompts for data extraction from a configuration Google Sheet
- 5Use AI to extract multiple fields (e.g., name, address, email) from the document text, guided by the retrieved prompts
- 6Update the original Google Sheet row with the extracted data
Related Templates
AI-Powered CV Extractor: Google Drive to Google Sheets with Slack Notification
This workflow monitors a Google Drive folder for newly uploaded PDF resumes. It automatically extracts text from the PDF using OCR and then utilizes AI (GPT-4) to extract structured candidate information, such as name, job title, and experience. The extracted data is then used to update an existing row or add a new row in a Google Sheet serving as a candidate database. Finally, the hiring team is notified via Slack with a summary of the new or updated candidate profile.
Extract Invoice Data from Gmail to Google Sheets with AI
This workflow monitors your Gmail for new emails containing PDF invoice attachments. It uses AI to extract key financial data such as company information, invoice numbers, line items, and taxes from the PDF. Finally, it creates a new Google Sheet, populates it with the extracted data, and organizes the file in Google Drive for accounting purposes.
Extract Invoice Data from Google Drive PDFs with AI and Email Alerts
This workflow automatically triggers when a new PDF invoice is uploaded to a specified Google Drive folder. It extracts key invoice details using AI, logs this data into a Google Sheet, and then generates and sends an email alert to the billing team via Gmail with a summary of the processed invoice.
AI Resume Screening & Evaluation for HR with AI & Google Workspace
This workflow automates the screening and evaluation of job applications. When a candidate submits their application, their CV is uploaded to Google Drive. The system then uses AI to extract candidate information from the CV, retrieves the relevant job description from Google Sheets and Google Drive, and evaluates the candidate against the job requirements. Finally, it stores the results in Google Sheets and sends conditional notifications via Gmail or Slack.
Extract Marketing Testimonials from Google Sheets with Gemini AI
This workflow monitors a Google Sheet for new customer feedback submissions. It then uses Gemini AI to analyze the feedback, extracting emotionally engaging and impactful testimonial quotes. Finally, the extracted testimonials are automatically added to a "Testimony" column in the Google Sheet, and an email notification is sent to the marketing team.
Screen Job Applicants with AI, Notify HR & Save to Google Sheets
This workflow automates the screening of job applicants. When a new job application (e.g., via Google Form with an attached CV) is received, the workflow extracts text from the submitted PDF CV. An AI then analyzes the CV to generate a compatibility rating, which is saved as a new row in a Google Sheet. Finally, both the candidate and the HR team receive email notifications regarding the application.