Python

You might say

What's the language everyone recommends for automating spreadsheets and files with a script?

A programming language often used to automate work on a computer or serverA Python script can read three Markdown notes and write their titles into summary.csv. It runs on a local machine or server; an ordinary web page does not execute a local Python script by itself.
Know first
Py
Further reading