Incrementing Unique ID in Google Sheets

How To
1

Hi everyone,

I’m trying to set up a workflow to generate a unique sequential ID and add it to a Google Sheets column. The ID format is something like WIL001, WIL002, WIL003, etc. I need the workflow to do the following:

  • Start with a base value (e.g., WIL001).
  • Check if the value exists in a specific column of my Google Sheet.
  • If it exists, increment the number and check again.
  • Repeat until a unique value is found.
  • Insert the unique value into the next available row in the column.

I want to accomplish this using only Make.com modules (no external scripting like Google Apps Script). I’ve tried using Search Rows, Set Variable, and Iterator, but I can’t get it to loop correctly until a unique value is found.

Has anyone successfully implemented something like this? I would appreciate any guidance, screenshots, or step-by-step explanations on structuring the workflow.

I appreciate any help you can provide.

2

Hey Willie,

do you have these values in a specific column in the sheet already? You can use search rows to get them, add them to an array and find the largest one. Then +1 it and create your next entry.