Hi, really struggling to build my workflow despite trying for the last few days. The workflow needs to do the following:
- Gmail Module that watches for a new email from a sender that has an attachmen - this is OK
2.The attachment (.csv or .xlsx file will be downloaded to my Google Drive with file name “contacts” with received date included in file name Contacts (e.g. Contacts_1.1.2025)
- Data from the file will then be copied over to my Google sheet called Leads
- There will be correct mapping between the received attachment and my Google sheet called all field names are the same between the two
- Any duplicate contacts containing all the same data will be deleted.
- Once the spreadsheet is populated with all contact details, a whatsapp module will send a Whatsapp message to all NEW contacts with a message I will choose. Whatsapp message will contain data from fields in Leads (e.g. Name, address, city)
- It will listen to responses to my messages and utilise a chatgpt module to summarise and save responses to column Response in sheet Property_Leads
- Once a response is received, it will be updated in the Response column of my spreadsheet called Leads.
- If no responses are received, it will try again after 2 days with a message text that I will choose, again referring to the information in the Leads Google sheet.
I am struggling with downloading the data into google - with the following error Input Data Field Name. Really finding this workflow hard to do but it shouldn’t be. Thank you all for your help.
Hi @Equinox, hope all is well and welcome to the community!
Can you also show an input to the Upload to Google Drive node?
1 Like
Hi -thank you for replying. Please see below…
The input would be to the left from the node configuration section, that’s what I wish to see please.
thank you- pls see here.There does not seem to be any input. The second screenshot is the before and it, too, does not have any input - despite my configuration of the gmail and all connections that mean it should work.The last screenshot is the trigger -connections to google account exist. So unsure what the issue is.The first module listens for an email form a sender with an attachment, the second should take the attached csv file, then covert it, copy it to my google sheet and so on…thank you.
Did you take this screenshots after executing the workflow or these are just the images of nodes configurations? The input is going to be there only right after it is executed (triggered or manually). Maybe post your workflow for us to better understand how things are connected (preferably the workflow itself, not a screenshot. You can copy and paste the workflow into a post, make sure to surround it with triple backticks).
My understanding is
- there is a gmail trigger, which receives an email with an attachment.
- the attachment is copied to Google Drive
- the attachment is copied to Google Sheets
- <more steps, which are irrelevant, to the problem…>
The input is only going to be there when the trigger is actually triggered (or you can also look up the input in previous executions).
In the Gmail node make sure you also toggle the “Download Attachments” under Options:
Here you go and thank you again.
Let’s try a different approach, let me share an example:
In this pipeline, I have an email trigger, which results in getting email both with and without an attachment, so the first step is we check if there an attachment. If there is one, we store it to the Drive, and if not - we go through the false branch, which leads up to other nodes (noop is just an example).
In the gmail trigger you can see I have “Download attachments” enabled: img, in the the IF node I simply check if the the $binary is not empty to send the pipeline through the “true” branch, and then in the Drive node I grab this binary by the name *attachment_0" and upload it: img.
Does this help in any way with what you are trying to do? If not, share your workflow the way I did above, it will help me to try to understand the issue.
This is going to be a long post, so here goes. My flow should do the following (likely to have overcomplicated it with this workflow):
-
Watches for a new email from a sender that has an attachment.
-
The attachment will be downloaded to my Google Drive with file name “Real Estate Contacts” with received date included in file name.|
3.Data from the file will then be copied over to a brand new spreadsheet called Property_Leads, in my google drive – it will update rows in the Property_Leads spreadsheet, which will remain the master sheet for all contacts and will be updated with data from the attachment every time it is received.
4.There will be correct mapping between the received attachment and my Google spreadsheet called Property_Leads – all column names are the same between the two|
5.Any duplicate contacts containing all the same data will be deleted with the mobile number being the criteria to determine if a record is duplicated.
6.Once the spreadsheet is populated with all contact details, a whatsapp module will send a Whatsapp message to all NEW contacts with a message from my Whatapp business template in Facebook. Whatsapp message will contain data from fields in Property_Leads
7.It will listen to responses to my messages and utilise a chatgpt module to summarise and save responses to column Response in sheet Property_Leads
8.Once a response is received, it will be updated in the Response column of my spreadsheet called Property_Leads.
9.If no response is received within 48 hours, a follow-up message will be sent. Workflow will monitor responses and update to Response tab of my spreadsheet, based on the reply that will be analysed through a Chatgpt module.
Let’s focus on the part which doesn’t work. My understanding it is primarily with “Upload to Google Drive”. If the email passes the Check CSV Attachment check it goes to Upload to Google Drive with an attachment.
In the Upload to Google Drive node you should see something like this on the left side under the Binary tab. Do you?
The node should be configured with the proper input data field name, which should match the orange text on the left. Does it?
Hi- I actually do not see the binary tab whatsoever.This is what I see,
The step before that, to check for csv, does not see to have any output…
Can you build a quick repro for this with just “gmail”, “if” and “google drive” nodes and share it as copiable workflow, so I could try to run it?
