Developer & DevOps

Extract Google Sheets data and send via Gmail automatically

14 nodes 189 98 Manual trigger
Download

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. 1.Read data from the specified worksheet in Google Sheets
  2. 2.Process and convert data into binary or text files
  3. 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. 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 (14)

/

HTTP Request

HTTP Request

#1

Google Sheets

Google Sheets

#2

Set

Set

#3

Spreadsheet File

Spreadsheet File

#4

Spreadsheet File1

Spreadsheet File

#5

Write Binary File

Write Binary File

#6

Move Binary Data1

Move Binary Data

#7

Gmail1

Gmail

#8

Google Sheets2

Google Sheets

#9

Move Binary Data2

Move Binary Data

#10

Note

Sticky Note

#11

Note1

Sticky Note

#12

Note2

Sticky Note

#13

Note3

Sticky Note

#14