Developer & DevOps
Extract Google Sheets data and send via Gmail automatically
14 nodes
189
98
Manual trigger
Workflow Description
Automation that reads data from Google Sheets, processes and converts it into files, then sends them automatically via Gmail with local storage and manual tracking capabilities.
How it works
- 1.Read data from the specified worksheet in Google Sheets
- 2.Process and convert data into binary or text files
- 3.Send files via Gmail with extracted data attached
Use cases
- Send weekly reports from spreadsheets to team members via email
- Extract customer lists from Sheets and distribute them automatically
- Save data files locally and send them as email attachments
Requirements
- Google Workspace account with Sheets and Gmail permissions
- Active Google Sheets spreadsheet containing data to extract
- Active Gmail account for sending emails
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Google Sheets
Spreadsheet File
Gmail
Details
Trigger
Manual trigger
Nodes
14
Apps
3
Views
189
Downloads
98
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 (14)
/
HTTP Request
HTTP Request
Google Sheets
Google Sheets
Set
Set
Spreadsheet File
Spreadsheet File
Spreadsheet File1
Spreadsheet File
Write Binary File
Write Binary File
Move Binary Data1
Move Binary Data
Gmail1
Gmail
Google Sheets2
Google Sheets
Move Binary Data2
Move Binary Data
Note
Sticky Note
Note1
Sticky Note
Note2
Sticky Note
Note3
Sticky Note