I want to send out a message in Teams once a week, with a different one of our 5 core values and a gif, on rotation so that each value will repeat every 5 weeks.
I tried ChatGPT, but the instructions it provided did not align with what was available to me when creating the Zap. When I got to the Utilities event, spreadsheet-style formula was not an option. And, tbh, what came after that was a bit beyond me as well...
Rotating Through Core Values
Since Zapier doesn’t have a direct way to rotate through a list every time a zap runs, we'll need to use a bit of a workaround:
- Add an action by searching for the app called "Formatter by Zapier."
- Choose the “Utilities” event.
- In the “Transform” drop-down, select “Spreadsheet-Style Formula.”
- For the Input, you could do something like: Week 1,Value 1,URL_to_gif_1 Week 2,Value 2,URL_to_gif_2 Week 3,Value 3,URL_to_gif_3 Week 4,Value 4,URL_to_gif_4 Week 5,Value 5,URL_to_gif_5
