Skip to main content

I need to create a Zap where it takes random image URL from a Google sheet and post it to a Facebook Page, can you direct me to the correct way to do this, I can create a Zap to post a URL to a Facebook page, but the part that I don’t know how to do is how to have the Zap select a random URL from a list of URLs in a Google Sheet?

Thanks

Hi @ayman.roshdy 

Good question.

You’ll need a Status (Used, Unused) column in the GSheet.

Here’s a help article about finding and updated GSheets rows: https://zapier.com/help/doc/finding-and-updating-rows-in-google-sheets

 

Why does it need to be a random selection?

If the links on the GSheet are already in a random order, then finding the next unused row would produce random results.

 

Terms & Conditions