Skip to main content

Hello, ManyChat Community!

I am looking for assistance with generating unique IDs for each new row inserted in Google Sheets after users complete a flow in ManyChat. Here’s what I have set up so far:

  • Google Sheets Integration: I have a Google Sheet where I want to insert new rows based on user interactions in ManyChat.
  • Insert Row After Flow: A new row is added automatically after a user completes a specific flow in ManyChat.
  • Unique ID Requirement: I want to generate a unique ID for each new row that is added to the sheet.

Specific Requirements:

  • The unique ID should be formatted consistently (e.g., GL-0001, GL-0002, etc.).
  • I need guidance on how to implement this using Google Apps Script or another method to ensure that the unique IDs do not duplicate.

If anyone has experience with this or can point me in the right direction, I would greatly appreciate it!

Thank you!

Hey @Ziad Amr the easiest way to achieve this is with a number Bot Field in Manychat, that you increment by 1on each run, and then you concatenate with the ‘GL-’.

The only restriction here would be the preceding ‘000’, but if you can live with having the numbers start at 1000 then it’ll work perfectly.

You can also solve with with App Scripts if you want, or using other tools like Make or Zapier - but it’s probably not necessary to overcomplicate it.

Reply


Community Terms & ConditionsCookie settings