So I did a really simple setup where everytime my google forms post a new row into my spreadsheet it should send a message.
This works when I input my number in the whatsapp send message event but I have found that the reason that it fails is because the spreadsheet also returns the header data which I dont need.
Workflow is really simple
Seems like the first data that retrieves is the header data which I dont need and those fails to create the phone number.
Any solution ?
n8n Version: 1.75.2
It looks like your topic is missing some important information. Could you provide the following if applicable.
Welcome to the community @Kurcano !
Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.
```
<your workflow>
```
That implies to any JSON output you would like to share with us.
Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!
Your spreadsheet looks unusual as if indeed you have an extra row. Try changing Header Row and First Data Row values.
This is the way google forms create the spreadsheets 
I also tried with a normal one and stills the same, I tink the trigger is buggy
Hey @Kurcano , I don’t think it is buggy. Looks like GSheet internally represent the form data differently from the standard spreadsheet data. You can actually get rid of the first item to resolve that issue. Take a look at Limit node. If the spreadsheet always contains 2 records that you can set it up as below. If not it is also possible but will be a bit more complex that that.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
