Gmail parameter error

Questions
1

Describe the problem/error/question
I am trying to get Gmail to automatically send emails based on parameters defined from a google sheets node. The problem itself seems to live in the Gmail node itself, as I have tried in other workflows that use Gmail and I get the same error.

What is the error message (if any)?
“The request is missing a required parameter, includes an invalid parameter value, includes a parameter more than once, or is otherwise malformed. (item 0) [item 0]”

All of the parameters in the node have been defined, and the JSON is correct. The node was working fine yesterday, but today it doesn’t seem to work.

Please share your workflow

  • n8n version: 1.41.0
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system: windows 11 pro
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

Hi @Oliver_Stonehouse ,

Welcome to the community! :dizzy:

From what I understand you want to send an email that automatically includes the correct venue name in the body text. Is the error that you are getting coming from the Initial email to send user node?

Could you share the output that you get from your G.Sheets node?

4

Hello.

Yeah, the venue name and also the name of the user. Yeah, the error is coming from the ‘Initial email to end user’ node.

This is the output from the google sheet node:
[
{
“row_number”: 2,
“First Name”: “Susy”,
“Last Name”: “Welch”,
“Email Address”: “[email protected]”,
“Venue”: “ABC Corp”,
“Date of visit”: “19/07/2024”,
“Time of visit”: “18:08”
},
{
“row_number”: 3,
“First Name”: “Nicola”,
“Last Name”: “Doran”,
“Email Address”: “[email protected]”,
“Venue”: “ABC Corp”,
“Date of visit”: “22/07/2024”,
“Time of visit”: “14:14”
}
]

5

Hi @Oliver_Stonehouse, I couldn’t reproduce your issue on my end. I can’t seem to find any issues with the parameters. Could you check to make sure that your credentials are working?

There’s an issue around Google Cloud Sign in on n8n Cloud that came up recently:

6

Hi @aya ,

No, nothing in our credentials has changed.

The error message references “(item 0)” which doesn’t make sense, so I suspect it may be something to do with the Google Cloud Sign in known issue?

Is there anyway we can check to see if that is the issue?

7

@Oliver_Stonehouse this is unrelated to the Google Cloud Sign in issue as the GMail node is not one that would be impacted.

Are you able to share the full error and a screenshot showing the node input along with the error?

8

Hi Jon, sure.

image
image1867×851 87.2 KB

9

Thanks @Oliver_Stonehouse,

Would you be able to try updating your cloud instance, 1.51.1 should be availble on Cloud now and would be a good option to move to. The only difference I can think of between what you have and what I have been testing against is the version.

10

Hi @Jon ,

This seems to have solved the issue. I appreciate your help here.

11

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.