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:
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)