issue creating posts on wordpress

[serwar24554]

hi this is the output i am getting for rewritten content. it automatically adds the that code in header when i ask it to rewritter and split the output in h2 tags. i have tried changing prompt but this is the only output that i creating the content and formatting it nicely, the only issue is it adds this doctype code in header. if i ask it to provide without that code then it would add '''html in start which shows in published post and i dont want that too.

the workflow was publising the posts on wordpress even like this earlier which was fine for me. but now i noticed it is creating issue for that doctype code. and when i remove that then posts are publised again on wordpress.

could you please recommend or optimise my prompt so it generates the nicely formatted wordpress post with proper h2 tags.

this is workflow url.

Pabbly

connect.pabbly.com

 

[serwar24554]

i made some changes even then the post is not getting published on wordpress

 

[Preeti Paryani]

Hello @serwar24554,

Could you please share a screen recording explaining your exact concern and use case? This will help us understand the issue more clearly.

Additionally, please let us know how you had previously set up the workflow, especially the action step where the issue is occurring. Also, mention any changes you recently made that may have caused the content to stop publishing on WordPress.

This information will help us investigate the concern effectively and assist you accordingly.

 

[serwar24554]

i figured out the issue. the issue is when i map the categories then the posts were not being published.

now this is what i want to do next. i am updating the google sheet when a new wordpress post is published. i am updating the sheet with the newly created post url.
now that is a sheet which i am using to repurpose the content. in that sheet i already have title, content, featured image and the link field which gets updated via this workflow.
now that sheet has many stories added. now i want the workflow to take posts from the sheet from top to bottom, rewrite them and update the link fields. i want the workflow to start for all the posts one by one which dont have link field filled. meaning it should rewrite the row 1, then row 2 then row 3 etc. and consider each row complete when there is a link url in link column. and also if all the link fields are filled, i want it to stop and only work when there are row which dont have link field filled.

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @serwar24554,

Thanks for the update, glad you got the issue sorted out.

To achieve your new use case, you can set up the workflow as follows:

1. Scheduler – Set it to run once (or as needed).
2. Google Sheets: Get Rows (Advanced Format) – To fetch all rows.
3. Iterator – To loop through each row.
4. Filter – Check if the link column is empty (i.e., process only unprocessed rows).
5. Delay – Add a delay step (you can configure the time as needed between each post).
6. Content Rewriting Action – Use the tool or service you prefer for rewriting.
7. WordPress: Create Post – To publish the rewritten content.
8. Google Sheets: Update Row – To update the link column with the newly created post URL.

 

[serwar24554]

Google Sheets: Get Rows (Advanced Format)
in get rows i dont see advanced format anywhere?

 

[Preeti Paryani]

Hello @serwar24554,

Please check the attached image.

 

[serwar24554]

hi i setup iterator action. now how would i use filter action? i am not understanding which values to select there. as i selected advanced response in google sheet action so i am only getting the array data that is mapped in iterator but for filter action google sheet is not showing any data. that could be mapped in filter action.
do i add one more action to get rows of google sheet and map that data in filter? plus i need to know how to use filter action. so it detects if link column has any url added or is empty. it should work when the column is empty.

Pabbly

connect.pabbly.com

 

[Preeti Paryani]

Hello @serwar24554,

You can set up the filter as per the attached image.

 

[serwar24554]

ok now i was able to setup this filter. now if the condition is false then the workflow will not proceed further after this? and when the workflow starts again at next scheduled time then it will start from 3 row now? as previously it worked in row 2 ?

 

[Preeti Paryani]

Hello @serwar24554,

Just wanted to clarify a few things regarding your workflow setup:

The scheduler you've configured runs at a specific time as expected. However, since we're using an Iterator in the workflow, it will loop through each row in the Google Sheet because we’re passing an array into it.

To align this with your use case, I recommend setting the scheduler to run only once, as shown in the attached image. Then, immediately after the Iterator, you can add a Delay step. For example, you can set a delay of 24 hours, so that each post is spaced one day apart.

This way:

• If the first post goes out today at 10:00 AM,
• The second post will go out tomorrow at 10:00 AM,
• And so on...

This approach ensures that your posts are spaced correctly without needing the scheduler to run multiple times.

 

[serwar24554]

i see. if i setup schedule once per day then everytime it runs it will processs all the rows? lets say if there are 10 rows in the google sheet even if it runs once per day. it will still process all 10 rows when it runs? and therefore we need to add delay. if this is the case then i understand.

and instead of running it once should i not run it even 24 hours? because the google sheet will continuously be getting updated with new content. so i want it to run at regular intervals like 24 hours.

 

[ArshilAhmad]

No, that won't work. You cannot achieve both use cases within the same workflow. The current workflow is set up correctly to create and post content using the existing data in your Google Sheets spreadsheet. You just need to run it once, and once all the rows of existing data have been processed, you can disable the workflow.


Now, to create content using newly added data in the spreadsheet, you’ll need to set up a separate workflow with Google Sheets as the trigger step. Simply create a new workflow with a Google Sheets trigger and add steps 4 to 10 from your current workflow. This will ensure that whenever a new row is added to your Google Sheets spreadsheet, it triggers the workflow and generates new content.


Watch the video shared below: