Problems with creating uid in spreadsheets using zapier

Hello. This is my problem situation.

  1. The two Google Forms receive different data from users.

  2. Using zapier, combine the two data into one Google spreadsheet “A”.

  3. Each row of “A” needs a unique ID, so I wrote the script with the help of
    Google Sheets UniqueId Apps Script

  4. However, scripts do not work on data coming through the zapier.

  5. And unique IDs are also required for existing data, not new data. However, this script seems impossible because the trigger is ‘onedit’.

How can I solve this problem?
To sum up, what I’m asking is,

“I want to give a unique ID to the data that Zapier automatically puts in”.
“I want to give unique ID to existing data”.

I tried to solve this problem for a long time, but I couldn’t solve it. If you give me advice, I think it will be a great help. Thank you.

0 4 145
4 REPLIES 4

SkrOYC
Participant V

Welcome to the community.
I suggest you to ask for help on that post since your usage of both AppScript and Zapier makes your case a kinda niche one

You’re right. I’m not familiar with the rules of this community. Thank you.

Use onChange() instead.

https://community.appsheet.com/search?q=onchange

Thanks, I solved one problem thanks to you.

Top Labels in this Space