Execution output is not visible in editor for google sheet

Questions
,
#1

Describe the issue/error/question

I’m setting up an automation to send mails to folks in google sheet, I executed the google sheet node and it is stuck in executing workflow in editor window. However when checked fr executions I see that the node has finished execution and the output is also right. This issue started after upgrading to latest stable version.

What is the error message (if any)?

no error message the workflow is in the state of executing without ending

Please share the workflow

  "meta": {
    "instanceId": "4a1d5d5144e1d06fa84217c508c3d70bbe46964ac5177d5b51e46752455d094c"
  },
  "nodes": [
    {
      "parameters": {},
      "name": "Start",
      "type": "n8n-nodes-base.start",
      "typeVersion": 1,
      "position": [
        780,
        -300
      ],
      "id": "fbbdf115-0868-4f2e-90dc-a9660f5a9f61"
    },
    {
      "parameters": {
        "resource": "message",
        "subject": "Buddy mail test",
        "includeHtml": true,
        "htmlMessage": "=Hi {{$json[\"Buddy name\"]}}, {{$json[\"First Name\"]}},\n\n<br><br>Hope you both are doing well.\n\n<br><br>You are receiving this email since you signed up for Upekkha Buddy. The two of you have been paired with each other.\n\n<br><br><b>Expectations from Upekkha Buddy:</b> Please introduce yourselves to each other and decide on a mutually agreeable cadence to catch up with each other.\n\n<br><br>The purpose of having a Upekkha Buddy is to both give and receive help to and from founders. A founder’s journey is tough and it takes another founder to empathise. \n\n<br><br>We will send you a bi-monthly reminder on Slack. For any questions and queries, do write to me.\n\n<br><br>Warm regards,\n<br><br>Ananya George",
        "message": "=",
        "toList": [
          "="
        ],
        "additionalFields": {
          "ccList": []
        }
      },
      "name": "Gmail1",
      "type": "n8n-nodes-base.gmail",
      "typeVersion": 1,
      "position": [
        1200,
        -300
      ],
      "id": "ffe1a377-d774-48da-94c8-9f7936641d83",
      "credentials": {
        "gmailOAuth2": {
          "id": "31",
          "name": " Gmail Account"
        }
      }
    },
    {
      "parameters": {
        "authentication": "oAuth2",
        "sheetId": "",
        "range": "Test!A:O",
        "options": {}
      },
      "name": "Buddy list10",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 1,
      "position": [
        1000,
        -300
      ],
      "id": "fdcc8b36-60ba-4678-a11f-aa94c4f894d0",
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "23",
          "name": "Abhay's Google sheet"
        }
      }
    }
  ],
  "connections": {}
}
(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:[email protected]
  • Database you’re using (default: SQLite):
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]:
#2

Just check this issue is also there for other nodes too, how are we suppose to connect to nodes if outputs are not displayed in the editor?

#3

Hi @Abhay, sorry that you’re having this problem. I assume you’re on n8n Cloud?

1 Like
#4

Yes we are running n8n cloud.
An observation we made is, This issue is only happening for already configured google sheet node before upgrading to new version of n8n.

when we added a new google sheet node and executed it we are able to see the output.

#5

Also one other thing we noticed.

While sending out email using Gmail node, if we had multiple people in To, CC etc emails separated by ', ’ used to work.
No the ', ’ separated format is not working they have to be added as individual To, CC address.

#6

@abhay could you try updating your Cloud instance to version 0.218.0? Instructions for how to do so here.