AI Agents

Extract Gmail data intelligently and save to Google Sheets

7 nodes 325 133 Automatic trigger
Download

Workflow Description

An automation template that receives email messages through a form and processes them using Gemini AI to extract relevant information, automatically logging the results in a Google Sheets spreadsheet for tracking and analysis.

How it works

  1. 1.Activate the form trigger to receive new Gmail messages
  2. 2.Process email content using Gemini AI to identify and extract key data
  3. 3.Record extracted information directly into Google Sheets

Use cases

  • Automatically organize and categorize customer emails into a centralized tracking spreadsheet
  • Extract order details and customer information from incoming emails into a unified database

Requirements

  • Active Gmail account with API access permissions
  • Google account with ownership rights to target Google Sheets

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Gemini Gmail LLM Chain Form Trigger Google Sheets

Details

Trigger Automatic trigger
Nodes 7
Apps 5
Views 325
Downloads 133

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (7)

Google Gemini Chat Model

Gemini Model

#1

Confirmation of CV Submission

Gmail

#2

Inform HR New CV Received

Gmail

#3

Using AI Analysis & Rating

LLM Chain

#4

Convert Binary to Json

Extract From File

#5

Application Form

Form Trigger

#6

Candidate Lists

Google Sheets

#7