Need Help: Google Workflow Not Sending Leads

[goekhan_celik]

Hi,

I need your help. I’ve been trying to fix this issue for hours now. Somehow, the workflow to Google doesn’t go through. No matter what I try I watched tutorials and everything

it just doesn’t put the leads into the table.

My account with the API is connected, but the leads are not being generated. As you can see, there’s no error message, but it’s not making a connection.

Any tips, guides, or videos would be great. I’m from Germany. Thanks in advance for your help!

[mohamed3nan]

Hi @goekhan_celik Welcome to n8n community

From what I see in the screenshot, it looks like you’re using the wrong Google Sheets node create: spreadsheet, This node will basically just create a new spreadsheet.

Depending on the data coming from the SplitOut node, I think you’ll need something like the append operation instead…

[goekhan_celik]

Hi Mohammed,

Thanks a lot for the quick reply.

I don’t fully understand what you mean do you maybe have a small guide or some screenshots?

[mohamed3nan]

If you don’t mind sharing your workflow here, it’ll save everyone a lot of time.

To share your workflow, select all the nodes (after removing any sensitive credentials or information), then paste it here like this:
```your workflow```

[goekhan_celik]

Hi Mohamed,

sorry, I’m new here in the forum. Unfortunately, I don’t know how I can send you the workflow here.

[polo]

Hey @goekhan_celik , you can just select your workflow in n8n, copy, and then paste it here . Exactly the same as you would copy paste in a doc.

Export and import workflows | n8n Docs

You will have something which looks like that :

‘’'{
“nodes”: [
{
“parameters”: {},
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
-160,
0
],
“id”: “4b63d398-5ab2-4e18-a28e-d6aa1c22d07c”,
“name”: “When clicking ‘Test workflow’”

[goekhan_celik]

{
“nodes”: [
{
“parameters”: {
“fieldToSplitOut”: “output.results”,
“options”: {}
},
“id”: “ad04b323-bc55-4f53-aff0-093e1643cf7e”,
“name”: “Split Out”,
“type”: “n8n-nodes-base.splitOut”,
“position”: [
-380,
-560
],
“typeVersion”: 1
},
{
“parameters”: {
“model”: “gpt-4o”,
“options”: {}
},
“id”: “7cf5a74b-d0f2-4953-b406-7826eb3fec75”,
“name”: “OpenAI Chat Model”,
“type”: “@n8n/n8n-nodes-langchain.lmChatOpenAi”,
“position”: [
-680,
-380
],
“typeVersion”: 1,
“credentials”: {
“openAiApi”: {
“id”: “dfVHacY3e2uoVb6Q”,
“name”: “OpenAi account 2”
}
}
},
{
“parameters”: {
“text”: “={{ $json.data }}”,
“schemaType”: “manual”,
“inputSchema”: “{\n "results": {\n "type": "array",\n "items": {\n "type": "object",\n "properties": {\n "price": {\n "type": "string"\n },\n "title": {\n "type": "string"\n },\n "image_url": {\n "type": "string"\n },\n "product_url": {\n "type": "string"\n },\n "availability": {\n "type": "string"\n } \n }\n }\n }\n}”,
“options”: {
“systemPromptTemplate”: “You are an expert extraction algorithm.\nOnly extract relevant information from the text.\nIf you do not know the value of an attribute asked to extract, you may omit the attribute’s value.\nAlways output the data in a json array called results. Each book should have a title, price, availability and product_url, image_url, company e-mail, company name, rating score”
}
},
“id”: “093e9033-b2bc-4de7-a836-77e8afca5458”,
“name”: “Information Extractor”,
“type”: “@n8n/n8n-nodes-langchain.informationExtractor”,
“position”: [
-740,
-560
],
“typeVersion”: 1
},
{
“parameters”: {
“url”: “https://r.jina.ai/https://www.dastelefonbuch.de/Suche/Friseur/Köln”,
“authentication”: “genericCredentialType”,
“genericAuthType”: “httpHeaderAuth”,
“options”: {
“allowUnauthorizedCerts”: true
}
},
“id”: “cd448456-c69f-479c-add8-e1d0d7679e42”,
“name”: “Jina Fetch”,
“type”: “n8n-nodes-base.httpRequest”,
“position”: [
-960,
-560
],
“typeVersion”: 4.1,
“credentials”: {
“httpHeaderAuth”: {
“id”: “tY7PqqSQ4pIc8Rvk”,
“name”: “Header Auth account”
}
}
},
{
“parameters”: {},
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
-1120,
-560
],
“id”: “9d8e3df9-6fdb-4454-b0c3-ce95d01b58b9”,
“name”: “When clicking ‘Test workflow’”
},
{
“parameters”: {
“resource”: “spreadsheet”,
“options”: {}
},
“id”: “d0143bc5-fbf6-4083-95a3-1ad1c0c77efd”,
“name”: “Save to Google Sheets”,
“type”: “n8n-nodes-base.googleSheets”,
“position”: [
-220,
-560
],
“typeVersion”: 4.2,
“credentials”: {}
}
],
“connections”: {
“Split Out”: {
“main”: [
[
{
“node”: “Save to Google Sheets”,
“type”: “main”,
“index”: 0
}
]
]
},
“OpenAI Chat Model”: {
“ai_languageModel”: [
[
{
“node”: “Information Extractor”,
“type”: “ai_languageModel”,
“index”: 0
}
]
]
},
“Information Extractor”: {
“main”: [
[
{
“node”: “Split Out”,
“type”: “main”,
“index”: 0
}
]
]
},
“Jina Fetch”: {
“main”: [
[
{
“node”: “Information Extractor”,
“type”: “main”,
“index”: 0
}
]
]
},
“When clicking ‘Test workflow’”: {
“main”: [
[
{
“node”: “Jina Fetch”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “45568561f2a2daf5563323031b45fddb0d7855d0c695f3d268dc2ef7b4099a5d”
}
}

[goekhan_celik]

Hi Polo

Thanks for the info. I guess I was overthinking it a bit. You’ll find my workflow in the field.

[goekhan_celik]

Hi Mohamed,

I posted it

[mohamed3nan]

Hi, okay here’s what I mean:

for simplicity, I replaced your last node to manually select an existing spreadsheet and automatically map the columns…

You’ll need to update these fields to match your own sheet:

[goekhan_celik]

Hi Mohamed,

That’s exactly what I had already done before. Same problem. It doesn’t create it, even though everything is connected to each other. I don’t understand why, I’m getting desperate…

[mohamed3nan]

Edit the split Out node like this

it should work

Here is the workflow:

[goekhan_celik]

Hi Mohamed,

thanks a lot for all your tips and your effort. But now there’s still one more problem I think after this, everything should be fine.

Do you have any tip or solution for this?

It gives me this output: "http://json-schema.org/draft-07/schema#

[mohamed3nan]

edit the input schema like this:

{
  "results": {
    "type": "array",
    "items": {
      "type": "object",
      "properties": {
        "price": {
          "type": "string"
        },
        "title": {
          "type": "string"
        },
        "image_url": {
          "type": "string"
        },
        "product_url": {
          "type": "string"
        },
        "availability": {
          "type": "string"
        }
      },
      "required": ["price", "title", "image_url", "product_url", "availability"]
    }
  }
}

[goekhan_celik]

Hi Mohamed its me again

Sorry if I’m annoying you with this, you really helped me a lot. In the end it’s just giving different results. My question is more like: Mohamed, do you know a better workflow that doesn’t cause problems, where you can collect contact details or emails through Google or other directories?

This workflow is driving me crazy and you too

[goekhan_celik]

For example, you give Google or the AI the command to list all the emails from websites/databases in the field of car repair shops from Cologne.