How to get the next item (next row) from Google Sheet

[Lars]

I really tried to understand the guide on how to the application to run all the rows from Google Sheet.

Not sure how to implement this: How to get the Google Sheets trigger to only pull one row each X hour? - #3 by ashrafsam

I want to run one post an hour. But not sure how and where to implement it to run new post in the long format each hour (or day)

[knightskid]

Add Schedule as trigger follow by your google sheet and choose Get next row(s).

[Lars]

Thanks knightskid. Appriciate your help.

I came up with another solution. It takes some tinkering to get it all to work. But worthwhile

[knightskid]

if you don’t mind, can share what is the other solution you came out with? Because, I have been using the schedule method for all my google sheet and hope to learn more on other way to do as well.

[Lars]

Hi again,

Firstly, I set up a trigger based on a schedule - it could be every x-minutes or even daily.

Then it will fetch the title in Google sheet on the first row. (It took awhile for me how to understand how it worked.)

But yeah, then I will get the activepices to fetch ChatGpt commands and answers based on the title. Writing the full article.

Then send it to wordpress and email me that it has been posted.

Finally. (And I guess this is what you were asking for), I get the activepieces to delete the first row.

So the second row will be the first, once the sequence triggers again.

Hope this make sense.

[knightskid]

yes…that is what i am interested in as my current row has been accumulate daily. Yet, I didn’t thought of using Delete Row. Am very grateful for your share.

[Lars]

Nice! Glad that I could give another perspective / solution

[knightskid]

right now, there is alot pieces i need to add delete row, but it is worth the time spend…