如果一个单元格包含任何文本，我想在序列1-9中添加一个计数器

I am feeding a spreadsheet from Zapier so when a action happends a row is added to the bottom. I want to use an arrayformula that adds a counter to the new row that has been added. I want it to count from 1-9 and then restart. So my plan was to use a formula similar to this.I am feeding a spreadsheet from Zapier so when