Hi All,
I have almost completed my first automation and very stoked with the result. It’s a simple one where I:
Search rows in gsheet → pull competitor URLs → inject into DumplingAI for screenshots of each homepage → Pass back to gsheet and input into a separate sheet.
The end result desired is to have a gsheet with WK numbers running along the top, and screenshots of all the competitor homepages running down the rows per week.
I have nailed all of the above except now I can’t seem to figure out how to run it once per week, and then dump the next week’s screengrabs into the next column along.
I imagine this is the most basic question which hopefully someone can steer me in the right direction with.
Thank you.
Welcome to the Make community!
You can click on the clock icon on your trigger module and select “Days of the week” and select a day.
For more information on scheduling, see https://www.make.com/en/help/scenarios/scheduling-a-scenario
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
2 Likes
Thanks. That part I understand, but how do I get it to drop the screenshots in a new column each time it runs instead of overwriting the same column every time.
For each column, you can use the if and length built-in functions to check if a previous column is not empty and current column is empty.
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
2 Likes
