How do I transfer email addresses from a Google Sheet to a Gmail node in n8n?

Below is one approach to transfer your list of email addresses from Google Sheets to the Gmail node:

1. Retrieve the Email Addresses from Google Sheets

   • Create a Google Sheets Node:
     Use the “Get Row(s)” operation in the Google Sheets node to read the rows that contain your email addresses.

     Make sure that:

     • You have set up your Google Sheets credentials.
     • The node is configured to read from the correct sheet and range.
     • Since n8n treats the first row as headings, ensure that your data rows only contain the email addresses.

2. Process the Retrieved Data (if needed)

   • If you receive multiple rows in a single output and need to process them individually (for example, to send separate emails), add a node like SplitInBatches or Split Out to iterate over each email address row.
   • Alternatively, if the Gmail node supports accepting an array of email addresses in the field you want to map (for example, the “To” field), you can pass the entire collection directly.
   • If your data needs conversion (e.g., from an array to a JSON key-value pair structure), you could use a Code node or AI Transform.

3. Transfer Data to the Gmail Node

   • Add a Gmail Node:
     Use an operation like “Send” (assuming you want to send an email) or any other operation that fits your use case. For example, if you plan to send out an email using each email address:

     • Set your Gmail node to use the “Send Message” operation.
     • In the To field, map the email address from the output of your Google Sheets (or from your splitting node if you used one).
     • Configure additional fields like Subject and Message as required.

   • Ensure you have set up Google credentials for the Gmail node as well.

Here’s a simplified example of the workflow structure:

MERMAIDCopied
flowchart TD
    A[Google Sheets Node - Get Row(s)] -->|Output: email addresses| B[Split Node (Optional)]
    B --> C[Gmail Node - Send Message]

Example Configuration Details:

• Google Sheets Node (Get Row(s)):

  • Resource: Sheet Within Document
  • Operation: Get Row(s)
  • Document: Select your spreadsheet (by list, URL, or ID)
  • Sheet: Choose your sheet (by list, URL, ID, or name)
  • Filters: (Optional) Set filters if needed to only pick rows with email addresses

• Gmail Node (Send Message):

  • Operation: Send a Message
  • To: Map the email address field from your previous node
  • Subject/Message: Define your email content

By setting up your nodes in this way, you allow the workflow to automatically pull updated email addresses from your Google Sheet and process them through Gmail with each change.

If you have any further questions specifically about configuring these nodes or mapping their fields, feel free to ask!