Update post Wordpress CSV

Questions
1

Hello, I’ve finished an automation to update the post content on my WordPress Site. It works, but there’s a manual part involved.

When I export the posts from WordPress to my Drive, I end up with a CSV file (see image 2). However, it’s not recognized as a CSV by Drive, so I have to manually open it with Google Sheets for it to be detected by the rest of the automation.

wordpress post 2
wordpress post 21118×174 27.3 KB

wordpress post
wordpress post539×162 2.93 KB

image
image718×193 19.5 KB

Information on your n8n setup

  • n8n version: 1.84.1
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Dcoker
  • Operating system:
2

Could this have anything to do with the delimeters?
I just uploaded a random manually created csv file and it was instantly recognized by Drive a spreadsheet-compatible document.

A workaround could be to have a Sheets template doc, copy it and fill in every time. Or just creating new sheets in existing Sheet.

3

Do you have this setting in your Drive settings on?

image
image849×323 17 KB

1 Like
4

Hello Olek, thank you it’s work. :grinning:

5

Glad to hear that. Please mark the post that worked as a :white_check_mark: Solution.

1 Like
6

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.