Export WordPress Content to Google Drive CSV - n8n Workflow

• Content Managers needing regular backups or audits of their live content.


• SEO Specialists requiring bulk data exports for keyword and content analysis.


• Technical users looking for a reliable, automated n8n workflow for data synchronization.


• Anyone seeking a reliable n8n template to bridge CMS data extraction and cloud storage.

Manually exporting large amounts of content data from a Content Management System (CMS) like WordPress can be time-consuming and prone to errors. This specialized n8n workflow provides a complete, automated solution.

The automation addresses the critical need for content portability and backup. Once activated, the n8n node responsible for WordPress interaction securely pulls all published post data. The flow then standardizes this data, converting it into a universal CSV format, and instantly stores it in Google Drive. This n8n workflow is highly valuable for ensuring data compliance, facilitating content migration, or simply providing a structured data source for reporting outside the WordPress dashboard.

This efficient n8n workflow operates in five distinct phases, starting with a simple execution and ending with secure cloud storage.

1. Initiation (Manual Trigger): The n8n trigger starts when the user clicks 'Test workflow' or manually executes the production n8n workflow instance.


2. Data Extraction (WordPress n8n Node): The flow immediately connects to the specified WordPress instance and uses the getAll operation to retrieve every published post. This ensures comprehensive data collection.


3. Data Transformation (Set n8n Node): The core JSON data received from WordPress is often nested and complex. The 'Adjust Fields' n8n node simplifies this by mapping key data points (id, title.rendered, link, content.rendered) into a flat structure suitable for CSV creation. As noted in the sticky note, users can easily customize this n8n node to include more metadata.


4. File Generation (Convert to CSV File): The normalized data items are passed to the 'Convert to CSV File' n8n node, which bundles all post entries into a single, structured CSV binary file.


5. Cloud Storage (Google Drive): Finally, the 'Upload to Google Drive' n8n node securely uploads the generated 'Wordpress-Posts.csv' file to the designated folder (root directory in this case), completing the automated backup process.

To utilize this powerful n8n template, follow these steps:

1. Import: Copy the provided n8n workflow JSON and import it into your n8n instance.


2. WordPress Credentials: Locate the 'Get Wordpress Posts' n8n node. You will need to set up a new WordPress API credential, providing the necessary URL and authentication details (usually application passwords for security).


3. Google Drive Credentials: Open the 'Upload to Google Drive' n8n node. You must configure a Google API credential, typically using a Service Account for unattended file operations, and ensure it has write access to your desired Google Drive location.


4. Customization: Review the 'Adjust Fields' n8n node if you need to include custom fields or modify the data structure.


5. Execution: After saving all credentials, click the 'Test workflow' button on the n8n trigger to run a trial execution and verify the file appears correctly in your Google Drive.

When clicking ‘Test workflow’ (Manual Trigger): Serves as the initial n8n trigger to start the entire data export process. Ideal for one-off exports or testing.
Get Wordpress Posts (WordPress n8n Node):
Function: Connects to the WordPress API to fetch post data.
Key Configuration: Operation is set to getAll, and the status filter is set to publish, ensuring only live content is retrieved.
Adjust Fields (Set n8n Node):
Function: Transforms and cleans the complex JSON output from WordPress into specific, flat fields (id, title, link, content) required for the CSV file.
Key Configuration: Uses expressions like ={{ $json.title.rendered }} to extract embedded data.
Convert to CSV File (Convert to File n8n Node):
Function: Takes the structured item data generated by the previous n8n node and converts it into a single binary CSV file.
Upload to Google Drive (Google Drive n8n Node):
Function: Handles the final storage operation, uploading the generated CSV file to the cloud.
Key Configuration: File name is specified as Wordpress-Posts.csv, and it uses 'Service Account' authentication for robust, non-interactive use of this n8n workflow.