Extract email data and save to Google Sheets automatically
Workflow Description
This workflow captures incoming emails, analyzes their content using AI models (Gemini and Groq), extracts structured data from the message body, and automatically appends the results to a Google Sheets spreadsheet for centralized tracking and review.
How it works
- 1.Trigger workflow when new emails arrive in Gmail
- 2.Analyze email content using AI language models
- 3.Parse and structure extracted data
- 4.Insert data row into Google Sheets spreadsheet
Use cases
- Track customer inquiries and requests automatically in a shared sheet
- Capture invoices and financial details from emails for accounting
- Archive meeting notes from emails in an organized Google Sheet
Requirements
- Active Gmail account with API access
- Pre-configured Google Sheets spreadsheet
- Gemini and Groq API keys
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (24)
Get invoice
Gmail
Get payment
Gmail
Extract invoice
Extract From File
Extract payment
Extract From File
HTML
HTML Page
Split Out
Split Out
Structured Output Parser1
Output Parser Structured
Google Gemini Chat Model1
Gemini Model
Send
Google Sheets
Set data 0
Set
Set data 1
Set
Set data 2
Set
Invoice data
Set
Payment data
Set
Switch
Switch
Groq Chat Model
Lm Chat Groq
Structured Output Parser
Output Parser Structured
Send1
Google Sheets
Extract details1
LLM Chain
Merge
Merge
Extract details
LLM Chain
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note