Hi,
I'm tracking the rankings for a list of keywords on a monthly basis.
There is a script I'm using to
- Create a new column
- Copy paste the data from my current column to the newly created one
However I have two issue I would like to solve:
1. I have some conditional formatting running on column F (color to track the change in keywords ranks), however when my new column is being created, the conditional formatting is not updated and stick to the old column. Is there any way I can change this and automate it on Apps Script ?
2. How can I automate the script so it runs by itself without any human interaction on the 1st of each month ?
Link to Google sheet: https://docs.google.com/spreadsheets...Ye8/edit#gid=0
My script:
Thanks a lot for your help in advance.Please Login or Register to view this content.
Bookmarks