Skip to main content

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

 

Hi there! Thanks for reaching out to the community. It sounds like you’re making great progress, but running into a common challenge with creating unique SKUs in a Zapier workflow. I’d love to help clarify the process and get your loop working as expected!

 

So when testing, the loop is limited in the sense that it will always provide the same results when it tests it, however, when it runs live, it should run properly for all the iterations with different values. Can you give this a try but turning it on and then triggering it to see if it reflects the result we’re looking for?

You can read more about this here too: Why do I only see one loop when I test my Zap?

If you’d like deeper assistance with troubleshooting this issue, please also feel free to reach out to the team at: https://zapier.com/app/get-help

 

Best of luck and let me know if that helps here! 😀


Hi ​@DenverGuzzi 

Try turning your Zap ON and testing live, then check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace the data flow and troubleshoot: https://zapier.com/app/history/

 

NOTE: A random number number does not guarantee a unique number for the SKU.

 

TIP: I recommend using Airtable instead of GSheets.

Airtable has a Formula field.

Airtable Formula fields can be configured to generated the internal record ID value, which is a unique value.

RECORD_ID()

 


Reply