Email from Google Sheet list of email addresses

Hello,
I currently have a list of email addresses within a Google Sheet which I have asked the user to amend when there is a change.
What I would like to do is take these email addresses (currently 10 rows) from the Google Sheet and transfer to the Gmail node.
How do I do this?
Thanks
Alex

Information on your n8n setup

  • n8n version : 1.72.1
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

:hammer_and_wrench: Steps to Send Emails from Google Sheets to Gmail in n8n

:one: Set Up Google Sheets Node

  • Node: Google Sheets
  • Action: Read Rows
  • Authentication: Connect your Google account
  • Spreadsheet ID: Select your Google Sheet
  • Range: Specify the column that contains the emails (e.g., A2:A11 if emails are in column A)
  • Output Data Format: Simple

:white_check_mark: This will fetch the 10 email addresses from your sheet.


:two: Connect Google Sheets Node to Gmail Node

  • Node: Gmail
  • Action: Send Email
  • To Field: Use {{$json["email"]}} (or select the correct column if named differently)
  • Subject: Example: Important Update
  • Body: Example: Hello, this is an automated message from n8n!

:white_check_mark: This sends an email to each address in the Google Sheet.

Thank-you for the answer has worked very well.
My next question is that I have 2 nodes, google sheets and Read/Write to Disk which I merge, wait for 15 seconds and then attempt to use both in a GMail node. The issue issue when starting the workflow based on a Scheduled trigger it only merges the one node that trigger is attached to. How do I get the trigger to run the 2 nodes at the same time? Workflow is below
Thanks

I’m trying to answer but they keep blocking me as spam. Hopefully moderators will take the spam block on my account.

  • Connect the Trigger to BOTH Nodes:
  • Connect to Google Sheets Node:
    • Click on the Schedule Trigger node to select it.
    • Drag a connection from the Schedule Trigger node’s output to the Google Sheets node.
      Connect to Read/Write Files Node:
      ** Similarly, drag another connection from the Schedule Trigger node’s output to the Read/Write Files from Disk1 node.
    • Ensure that both Google Sheets and Read/Write Files from Disk1 nodes have
      incoming connections from the Schedule Trigger node.

Adjust the Merge Node if Necessary:

  • Ensure that the Merge node is set up to receive inputs from both Google Sheets and Read/Write Files from Disk1.
  • This setup allows the workflow to wait for both nodes to complete their tasks before proceeding.
3 Likes

Thank-you, I knew it was something simple. when I run the gmail node it comes up with the following error

Problem in node ‘Gmail‘

This operation expects the node’s input data to contain a binary file ‘data’, but none was found [item 0] (item 0)