Is it possible to automatically create columns in a Google spreadsheet?

Question

Google Sheets

Hello.
Is it possible to set Google Spreadsheet to automatically create columns?
Example:
For example, today is the 27th, and at 00:00, instead of column C, a new column with the number 28 is created.

Answer 1

Related links
https://www.quora.com/How-can-I-periodically-run-a...
https://developers.google.com/apps-script/guides/t...
In general, easily googled. There further knowledge of JS is needed.