Hey Peeps,
Hope you all well. Pls help me figure this simple issue out.
I got a google sheet with 3 columns: Published, Content and Photo Url
When I run my scenario, the Instagram module takes the first row where published = NO and goes ahead and makes a post with the content and the photo, so far so good.
What I need to do now is change the value of published to YES.
I’m trying to use a update-a-cell module but it takes a specific cell only and it works only the first time around, whereas my cell keeps changing every time a post is published.
Is there a way to add a dynamic value to the cell field so that it changes only the first cell that reads NO or a different module to fix my issue?
Here’s my blueprint if it helps
blueprint.json (21.0 KB)
Many thanks in advance.