In a new row, enter:
The Sheet ID where you want to insert row IDs.
The Column Name where the row IDs should be written.
(Make sure this column already exists in the target sheet before using the configuration sheet.)
Once the required fields are filled in, check the Enable checkbox and save your changes (Ctrl + S). This tells the script to process that row during the next run.
The Status column will be automatically updated by the script, which runs every 15 minutes. Possible status messages include:
ACTIVE – The row IDs have been inserted successfully.
INACTIVE – The row is not being processed (Enable box is unchecked).
INVALID INPUT – There is an issue with the provided Sheet ID and/or Column Name.
If you want to stop indexing a sheet, simply uncheck the Enable box, save your changes (Ctrl + S), and the status will update to INACTIVE during the next script run.