ukwa-gsheets-utils

Add-On for Google Sheets to help those working with web archives.

Features

• Custom functions that use the Memento API (specifically the TimeGate) to look up whether a given archive holds a given URL. Currenly supports:
  • UK Web Archive via =WEBARCHIVE_STATUS_UKWA(<url>)
  • Internet Archive via =WEBARCHIVE_STATUS_IA(<url>)

There's probably quite a lot more this could do, given these capabilities.

The main restriction here is the 20,000 calls/day default quota per user -- you should bare this in mind if attempting to check large numbers of URLs.

Getting Started

To install it, go here

To see an example of it in use, see this read-only Google Sheet.

Development

This repo is mostly a back-up of the Google Script version, and editing should likley happen there, while we use clasp to make this backup occasionally.

That's a view-only link to the Google Script view, you'll need to request permission to edit.

Ideas

• Via Memento API:
  • Add custom functions to support TNA and Parliamentary archives TimeGates?
  • Add custom function to talk to the Memento Aggregator? Needs to return archival URL rather than just the status?
  • Add functions to return first/last memento datestamps?
  • Add functions to return counts? e.g. number of copies, or number of URLs starting like X?
  • Add functions return the archived URL?
  • Add button to replace URLs with archived URLs?
  • Add button to colour cells holding URLs based on archival status of URL? (Could also be applied to Google Docs? e.g. get all links)
• Via suitable custom API:
  • Add a custom function to take a URL and report if there is a record in W3ACT that covers it? (and link to it?) Has it cleared the criteria for NPLD?
  • Add a custom function that checks holdings, but also immediately enqueues a request for the URL. i.e. handle in-scope nominations quickly.