Google sheets node not working

Questions
1

“Hello friends of the community, I need help to unblock 2 basic workflows. The first one sends an email to contacts from a spreadsheet, which is fine. The other one receives email replies, classifies the leads, and then updates this spreadsheet with categories, but in the last node it gives an error not finding the column value. I’ve tried everything and I can’t solve it. If anyone can help, I would be immensely grateful.”

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

image
image1531×865 169 KB

Share the output returned by the last node

Information on your n8n setup

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

Hey Felipe,

One suggestion is to check the “Email” column name as the key field may be case-sensitive. Is the column actually “email” ? Also, does the range (“A:D”) include the Email column ?

Rgds

Si

3

Hey @Felipe_Alemao hope all is good! Welcome to the community.

It appears you are using the old version of the node. Did you copy the workflow from elsewhere?

4

yes a did copy from elsewhere

5

Hy, i did cjeck these infos and its all good

6

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