Content teams often need a fresh list of live posts for reports and audits. This setup pulls all published posts from WordPress and saves a clean CSV file straight to Google Drive. It is ideal for marketers, editors, and agencies that want quick exports without copy and paste.

Under the hood, a manual trigger starts the run. The workflow fetches all published posts from WordPress, then uses a field mapping step to keep only the columns you want, like id and title. Next it turns the result into a CSV file and uploads it to your chosen Google Drive folder using a service account. You get a consistent file that is ready for Google Sheets, with only live content included, and the same format every time.

You will need WordPress access and a Google Drive account with a service account set up. Connect both in n8n, select the fields you care about in the Adjust Fields step, and click Test to generate your first export. Expect a ready file in minutes and a big cut in manual work. This is great for monthly content reviews, SEO audits, campaign summaries, and client deliverables.

• Manual start for on demand exports when you need a fresh report.
• Fetches all published posts from WordPress with status filter set to publish.
• Adjust Fields step lets you pick and rename the exact columns for the CSV.
• Converts the dataset to a clean CSV file ready for Google Sheets.
• Uploads the CSV to Google Drive using a service account for secure access.
• Consistent file structure so reports look the same every time.

• Reduce manual reporting from 2 hours to 5 minutes
• Streamline content export steps by 80 percent
• Improve data accuracy by 90 percent by avoiding copy and paste
• Connect WordPress and Google Drive in one repeatable flow
• Handle thousands of posts without extra effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with WordPress and Google Drive. See the Tools Required section above for links to create accounts with these services.
3. Open the Get WordPress Posts node, click Credentials, choose Create new credential, and follow the on screen steps to connect your WordPress site. Use the method your site supports, such as application passwords or OAuth.
4. Click Execute Node on Get WordPress Posts to confirm you can pull published posts. If nothing returns, check the site URL and user permissions.
5. In Get WordPress Posts, keep Operation as Get All, set Status to publish, and confirm Return All is enabled so every live post is included.
6. Open the Adjust Fields node. Add or rename fields you want in the CSV, such as id, title, date, slug, link, and author. Remove any fields you do not need.
7. Open Convert to CSV File and confirm Format is CSV. Leave defaults or set a file name if you want a custom name.
8. Open the Upload to Google Drive node. Click Credentials, choose Create new credential, select Service Account, and paste your JSON key. Share the target Drive folder with the service account email so it can upload files.
9. In Upload to Google Drive, choose My Drive or pick a specific folder. Set the file name you want to appear, such as Wordpress Posts.csv.
10. Run the workflow with Test. After it finishes, open Google Drive and check that the CSV file was created. Open it in Google Sheets to confirm columns and rows look correct.
11. Troubleshooting: If the file is empty, remove extra filters or confirm there are published posts. If upload fails, verify folder permissions for the service account. If you do not want overwrites, add a timestamp to the file name using the n8n expression editor.