Hello, I’m trying to create unique SKU’s and add to a Google sheet. My trigger is a form submission with attached CSV file, containing product information. I’m importing the file and adding all rows to a google sheet. I need to add a unique value to each row to function as the SKU. Currently I’m testing random number generation and Looping, but have also tried Zapier Storage + Looping, with no success.
It’s the looping step that I can’t figure out. I’ve read tutorials and watched videos, but there is obviously a key concept or limitation that I am not grasping. I’ll appreciate any guidance that can be offered.
Below are my zap steps and where I’m placing the output in my google sheet. Here I’m testing the random number step before and after the loop, and testing all three outputs from steps 4,5,and 6 in the Google sheet. On this test, all three outputs populated with the same value on each row. Does anyone know what I need to do to have a unique value on each row? Thank you