Best answer

Collect info from my old Wordpress posts and send to Google Sheets

  • 14 December 2019
  • 1 reply
  • 333 views

Userlevel 3

Hey Zap-crafter !

Is there an easy/fast way to create a Google sheet with some datas from our old WordPress posts

I already have something like :


« When I post on WP »

« Add datas from posts to this specific Google sheet » 


It’s easy to create this zap with the trigger « new posts ». 

But how can I do that with the old posts already published on my Wordpress ? 


The datas I need are :

- Published date

- Title

- Excerpt

- Url post


I already tried to export my datas from Wordpress to the email parser, but that wasn't so efficient...


icon

Best answer by PaulKortman 15 December 2019, 22:10

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +10

@Scendre this is a limitation of Zapier in that it only processes data moving forward, however we can "fool" zapier to trigger on other data... In your case since it's a one time "import" this is the easiest method I would recommend:

----

Note: After writing up the description below I realized your goal was to just get this data into a google sheet, running it through Zapier is unneeded as you'd need to export the data from wordpress (try this plugin) and that would provide you with a CSV of the data, just open that file in Google Sheets and remove the columns/rows you don't want and then if you need to copy the data from the remaining 4 columns and past it into your desired Google Sheet. If, however, you need to run these 4 data points through Zapier to process/format them etc then you can follow the instructions below.

----

First export your data from Wordpress and remove everything except the 4 columns you want:

  • Published date
  • Title
  • Excerpt
  • Url post

Second create a Google Sheets file with those 4 column names (in the same order as the exported data you have).

Third copy your existing zap and change the trigger to Google Sheets -> New row in Sheet point to the sheet you created in the second step above. Then map the four data points (the four columns) to however you use it in the rest of the zap.

Fourth, copy a row from the exported data to the sheet you created in step 2 above. To test it... if the zap fires and ran the way you wanted to, copy up to 100 rows at a time and paste them into the second spreadsheet.

(If you do more than 100 in ~3 minutes Zapier will hold the tasks as a task flood protection. While doing something similar recently, I knowingly flooded Zapier with 1000 rows, and then logged into Zapier and told it to play all 1000 tasks... after a few minutes it finished everything fine. )