Store json data to excel file

Questions
1

[

{

“output”: “Here is the breakdown of the total durations for each event requirement:\n\n- Santa Costumes/Props: 9 days\n- Brand Ambassadors’ Costumes: Elf Outfits: 6 days\n- Platform Fabrication: 3 days\n- Red Carpet: 3 days\n- Christmas Tree: 3 days\n- Decor for the Tree: 3 days\n- Gift Boxes and Branding: 36 days\n- Brand Ambassadors: 9 days\n- Project Leader: 3 days\n- Labour for Setup and Set Down: 15 days\n- Transport and Lunch for Brand Ambassadors: 9 days\n- Transport to and from Venue: 3 days\n- Lunch for Brand Ambassadors: 3 days\n\nThese durations will be used in calculating the total costs for each event requirement.”

}

] I have the following data that I want to store in an excel file. How exactly can I do that?

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

n8n version: 1.62.4
database: sqlite (but in my workflow I am using pinecone database)
n8n execution process setting: default
running n8n via n8n cloud
operating system: windows

1 Like
4

Quite simple actually, just use a Convert to File node

{
  "meta": {
    "instanceId": "671617e7a282a2e4a7f1c2f31e173b514b8bf274eec75011b7395ad1596580d8"
  },
  "nodes": [
    {
      "parameters": {},
      "id": "b53fd0ba-9400-4387-8eba-416f5fc251d2",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        360,
        220
      ]
    },
    {
      "parameters": {
        "options": {}
      },
      "id": "867b0080-2263-461b-8769-ce703fc5b791",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "typeVersion": 1.1,
      "position": [
        540,
        220
      ]
    }
  ],
  "connections": {
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {
    "When clicking ‘Test workflow’": [
      {
        "output": "Here is the breakdown of the total durations for each event requirement:\n\n- Santa Costumes/Props: 9 days\n- Brand Ambassadors’ Costumes: Elf Outfits: 6 days\n- Platform Fabrication: 3 days\n- Red Carpet: 3 days\n- Christmas Tree: 3 days\n- Decor for the Tree: 3 days\n- Gift Boxes and Branding: 36 days\n- Brand Ambassadors: 9 days\n- Project Leader: 3 days\n- Labour for Setup and Set Down: 15 days\n- Transport and Lunch for Brand Ambassadors: 9 days\n- Transport to and from Venue: 3 days\n- Lunch for Brand Ambassadors: 3 days\n\nThese durations will be used in calculating the total costs for each event requirement."
      }
    ]
  }
}```