help me create this canva + pinterest automation

[serwar24554]

i saw a member working on this automation. i would like to do same. if pabbly team could help please.

The automation follows the following steps:

1 reads a post from my blog
2 creates the pin layout in Canva and creates design in canva according to blog post title.
3 publishes canva design on Pinterest

 

[Preeti Paryani]

Hello @serwar

Please let us know the application to be used as the trigger to read the blog post and what you refer to by - creates the pin layout in Canva.

 

[serwar24554]

hi i was able to setup the automation using pabbly youtube videos. there is one issue I am facing. on my google sheet I don't want the work flow to only trigger after I add a new row.
i want the workflow to daily take one quote from google sheet rows. and each day take quote from the the below row than the row that It used earlier.
now I saw a solution that I could create a date column so everyday that current date row will be used to create new quote. but I want to schedule lets say 5 quotes daily.
now do I setup the workflow in such a way that it daily takes the 5 rows to create quotes. and then next day takes below 5 rows to create new quotes. please advise.

 

[serwar24554]

how do i schedule using google sheets on social media lets say facebook. basically I want to schedule 5 posts daily which get published at 2 hour intervals.
this is where I am struggling.
1 how do I make workflow take data from different rows each days
2 how do I make workflow take certain number of posts from sheet rows and schedule lets 5 posts daily which get published every 2 hours. thanks

 

[ArshilAhmad]

You can set up the first three steps of your original workflow in this manner, which will allow you to fetch data from a new row of the Google Sheets spreadsheet at an interval of 2 hours.

Pabbly

connect.pabbly.com

Then, you would need two other workflows: one to disable the original workflow and one to enable the original workflow.

Enable Workflow every day at 9 AM

Pabbly

connect.pabbly.com

Disable Workflow every day at 11 PM

Pabbly

connect.pabbly.com

Combined, these 3 workflows will help you achieve the desired use case of posting 5 times daily from a new row of a Google Sheets spreadsheet.