What is your goal?
OK so I have a successful scenario using that template above so it connects to a single URL picture ,that I provided ,and it posts to my facebook business page.
What I was hoping is within that same scenario is there a way instead of selecting a single URL for the picture ,can I use a Google sheet added to one of the Functions with multiple Urls where they can change the picture on each run or at least once a week?? that how I’m gonna run it and it creates the post underneath the different picture?
What is the problem & what have you tried?
I’m kind of a beginner, so I’m not sure if I’m asking it the correct way,
but there are there are no errors it works it posts to my facebook with a picture and post text all fine.
I just want a solution, if any, for it to change pictures with each run or at least once a week Can I do that through Google Sheets and where would I add that in that scenario? I have not tried anything because I don’t know where to try it?
Hello Climate Experts, Yes, you can do that.
Just place a Google Sheets step right before the Facebook post, and use it to pull a different image URL each run (or once a week). So instead of hard-picking one URL, the scenario grabs the next row and posts whatever URL is in that row.
If you also want to mix in video later, you can use the same exact setup but store a video URL in the sheet too, so some runs post an image and other runs post a short video.
Let me know if it works
Well adding to the scenario seems like the easy part, but when I select Google Sheets, it asks if you want to add a cell ,a row, a sheet ,or other things,
So I’ll select Google Sheets and then the do I select simply add a new sheet and then put those in and then go back to the Facebook page part of the scenario and SELECT a different img input source and change it to use Map from previous module?
I’m a bit new at this so any help would be Appreciated, thank you..
Here’s what my scenario looks like and apparently I’m choosing something incorrectly.
Welcome to the Make community!
You cannot individually run a single module if you don’t have example input data values for each required field, which you must input into the dialog box when you manually run a single module. This is because when you only run a specific module, the mapped variables in the module’s fields are null (do not contain any value), as the previous modules do not run and produce any output values. Does this make sense?
Instead, try running the full scenario by clicking the “Run Once” button:
For more information, see these duplicate questions previously asked and answered by other community members:
— @samliew
Hey there! You’re almost there!
So, when you’re adding the Google Sheets module, you don’t need to add a new sheet. Instead, choose “Search Rows” ( this will let you pull the image URLs from the rows you already have in your sheet).
Once that’s done, you’ll map the image URL from Google Sheets into the Facebook Pages module where you create your post. Just map the image field to the output from Google Sheets, and it’ll automatically grab the image URL for each new post.
Let me know if that clears things up, or if you need more help! 
OK so I changed the scenario and use the search rose instead and I changed my facebook page scenario and when I ran it it worked however the new problem is it took all four photo URLs and sent out for posts all at once. Did it only do this because I haven’t set it to run once a week on a schedule yet?
Or how do I fix it to where once a week it pulls the first URL and then the next week it takes the second URL because I only want one post with one new picture a week I don’t want 4 at a time as you can see in the corner of in the ICU Singapore Police it ran all four Picture UR LS with all four posts at right one after another
Where is the setting where I can have this read one line per week and send out one post per week…
thanks in advance
I could still use a little help here I know you guys are pretty pretty busy but my Last Post showed you that my scenario is not working but now it’s pulling all four pictures and posts at the same time when it runs so it’s sending out 4 in row.. I’d like it to choose one picture and one post once a week when I have it scheduled and next week pull a different picture you know and however it rewards the post the next week and goes through my google sheet and when it gets to the end it can go back to the top so I’m not having too many at once sent out.. As you can see in the other post the screenshot shows the Facebook sent for it has four checkmarks how do I accomplish what I’m trying here by scheduling it once a week and it pulls one picture per line each week and 10 starts back at the top?.
So will this theoretically now that I switch my limits to one if I run my scenario once a week will it change pictures each week as it goes through each row it’ll show a different picture with the post until it gets to the last one and it starts over from the top?
I had the limits set to five, which was to default, and it was sending out four posts with all four different pictures at once, at each run cycle/
so I went back and changed it to limit one now.
I’m curious well it run down the sheet rows each week?
A setup like this usually works best once text and image generation are treated as two separate steps. Generating captions first, then pairing them with visuals, keeps things predictable in Make. Adding a bit of randomness to prompts also helps posts feel less robotic. Testing everything on a private page saved me from plenty of embarrassing mistakes early on.
