Post automation using AI and google sheets

I am trying to post content everyday at 7 am for my business, so my trigger is set in pabbly to begin daily at 7, using google sheets to pull from, I have A column for Topics, B column for my Standpoint, C column for the Tone I want AI to write in. I have the workflow going and it posts to Facebook already, I am having issues setting up the workflow to pull from each column a different topic, standpoint, and tone to give AI each day so it does not repeat a post. I have enough topics, standpoints, and tones that it would take years of posting everyday before it ran out of the options, I just cant get it to randomize the cell it pulls from in google sheets so the topics are not in a pattern when posted but not duplicated either. Or is there a better way to achieve this same concept and I just do not see it? Please help, greatly appreciated by a new user.
 

ArshilAhmad

Well-known member
Staff member
Hi @Levi Cossairt,

You can follow the steps given in the video shared below to setup your workflow. This will provide you with new data every day by changing the row from which the data is fetched using the Counter feature.
 
Top