I have a simple Google sheet (it's literally a line), which has A2
= now () to calculate the current time, and then a series of formulas that calculate several dates / hours based on the current date in column A2 to column R (column 18)
What I would like to do is that when cell J2 reaches the value of "8" it is to insert a new row and copy the formulas from A2 to R2 in the new row, which will be executed every month.
How do you script this? I have no experience in scripting.