Export Wordpress Posts to CSV and Upload to Google Drive

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "c3f63a01-1450-4f97-ab2d-16414613f50c",
      "name": "When clicking \u2018Test workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        400,
        320
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bc725e33-353d-4b3d-b65f-eb295053e5cc",
      "name": "Get Wordpress Posts",
      "type": "n8n-nodes-base.wordpress",
      "position": [
        640,
        320
      ],
      "parameters": {
        "options": {
          "status": "publish"
        },
        "operation": "getAll",
        "returnAll": true
      },
      "credentials": {
        "wordpressApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "07ed3f2a-c2b6-4e3c-80d7-425adc6ad36d",
      "name": "Adjust Fields",
      "type": "n8n-nodes-base.set",
      "position": [
        860,
        320
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "39ade710-ebe5-4c4d-9bc8-5ad86a3c76b5",
              "name": "id",
              "type": "number",
              "value": "={{ $json.id }}"
            },
            {
              "id": "2714c21d-5ad3-408b-b91d-aa4513f384f3",
              "name": "title",
              "type": "string",
              "value": "={{ $json.title.rendered }}"
            },
            {
              "id": "71194450-c5c6-4bf0-8a33-5aa88d02ddf4",
              "name": "link",
              "type": "string",
              "value": "={{ $json.link }}"
            },
            {
              "id": "69b5c680-965e-4078-809d-74b10da1a29f",
              "name": "content",
              "type": "string",
              "value": "={{ $json.content.rendered }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "234d6755-e862-4277-b0b7-1ac65cd87c12",
      "name": "Convert to CSV File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        1080,
        320
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "49901cd8-5ef5-41b5-87c3-a5979cf11644",
      "name": "Upload to Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1300,
        320
      ],
      "parameters": {
        "name": "Wordpress-Posts.csv",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "options": {},
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "root",
          "cachedResultUrl": "https://drive.google.com/drive",
          "cachedResultName": "/ (Root folder)"
        },
        "authentication": "serviceAccount"
      },
      "credentials": {
        "googleApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 3
    },
    {
      "id": "a36bccd7-9298-4c96-8f4e-83b9096e53dd",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        160
      ],
      "parameters": {
        "height": 140,
        "content": "### Adjust fields\nYou can add more fields to the CSV file by editing this node"
      },
      "typeVersion": 1
    },
    {
      "id": "5d86d3be-dd69-454a-b739-17ded5636ee1",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        100,
        220
      ],
      "parameters": {
        "height": 260,
        "content": "### Export WordPress Posts to CSV and Upload to Google Drive\n\nSteps:\n- Set your WordPress credentials in the \"Get WordPress Posts\" node\n- Set your Google Drive access in the Drive node\n- Click Test workflow"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Adjust Fields": {
      "main": [
        [
          {
            "node": "Convert to CSV File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to CSV File": {
      "main": [
        [
          {
            "node": "Upload to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Wordpress Posts": {
      "main": [
        [
          {
            "node": "Adjust Fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Test workflow\u2019": {
      "main": [
        [
          {
            "node": "Get Wordpress Posts",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• googleApi
• wordpressApi

About this workflow

This n8n workflow automates the process of extracting published WordPress posts, converting them into a CSV file, and uploading it to Google Drive. It’s perfect for content backups, SEO audits, and data migration. Fetches all published posts from a WordPress website Extracts key…

Source: https://n8n.io/workflows/2889/ — original creator credit. Request a take-down →

More Content & Video workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.