CSV to Google Sheets + History

[mgifford]

Clear and concise description of the problem

Seems to me that I should be able to run something like this #135 (comment)

But have that result get automatically dumped into a Google Sheet.

Using something like:
https://developers.google.com/drive/api/guides/manage-uploads#http_1

Which could then have formatting/charts added, sorta like what they do for
https://github.com/cloudfour/lighthouse-parade

But you could actually run this all from Cron & provide a historical view of how accessibility, performance & SEO issues are addressed on a sample of web pages over time.

This would allow folks to see progress.

It could also be possible to more easily highlight those pages which need the most work.

Suggested solution

Document how Unlighthouse can be used to illustrate progress over perfection.

Bring in Google tools to provide an easily sharable chart based presentation with the results from Google Lighthouse.

Alternative

No response

Additional context

Just trying to demonstrate progress over time. I'd like to be able to do weekly monitoring and share results easily through a more automated process.

[mgifford]

Pretty simple bash script to do some of this:

#! /bin/bash
while IFS=',' read -r domain homepage sitemap; do
  if [ -z "$sitemap" ]; then
    timeout 60m npx unlighthouse-ci --no-cache --site $homepage --throttle --no-cache --reporter csvExpanded
  else
    timeout 60m npx unlighthouse-ci --no-cache --sitemaps $sitemap --site $homepage --throttle --no-cache --reporter csvExpanded
  fi
  filename="unlighthouse_${domain}_$(date '+%Y-%m-%d_%H-%M-%S').csv"
  mv ./.unlighthouse/ci-result.csv ~/Unlighthouse/Unlighthouse_files/$filename
done < unlighthouse_sitemaps.csv

CSV is essentially just:
example.com, https://www.example.com, https://www.example.com/sitemap.xml

This just dumps the csv into a directory.

You need to create these directories from your home directory:
~/Unlighthouse & ~/Unlighthouse/Unlighthouse_files/

Create a run.sh file and give it write permissions (chmod 777 run.sh)

I've got a basic GoogleSheet history up and running too.