Search code examples
iosfirebasefirebase-realtime-databasezapier

Add unique random identifier to new Firebase child with Zapier/Google Sheets


I am connecting a Google Sheets file to Zapier to automatically create a new child in my cards Firebase node when a new spreadsheet row is created. The problem is that I can't find a way to generate an unique identifier with Zapier and/or Google Sheets. What's the best way to generate an unique ID for every child created?

enter image description here

enter image description here

enter image description here

I could add a new column in the Google Sheets to generate a new UID based off the time stamp that row was created but adding a different time stamp every time seems a bit cumbersome.


Solution

  • Here is a third alternative as a python script (using only one step)

    import uuid
    
    return {
    'unique_id': str(uuid.uuid4())
     }