Skip to content

All projects

Automated reporting

A report gathered from sheets, on demand or on a schedule. This is the kind of work, not a client’s name.

The problem

Someone copied the same columns every month, from several sheets, to get one table.

What I built

  • A script that reads the source sheets.
  • One table with the same columns, every time.
  • It can start from a menu or from a time trigger.

Stack

Google SheetsApps Script