Scheduled Wikidata queries in Google Sheets

​

​

With timeline visualization

Navino Evans

Histropedia co-founder

​

@NavinoEvans

tinyurl.com/wikidataspreadsheet

DATA RE–

USE DAYS

14 - 24 March 2022

Links

This presentation is a live demo, so here are links to the resources used:

1. Spreadsheet template (resulting timeline visualisation)

This spreadsheet gets a daily scheduled import from a Wikidata query, which is then used to power a Histropedia Sheets timeline. It includes an instructions page which shows you how to repurpose for your own use case.

• Histropedia Sheets

Tool for creating Histropedia timelines using Google Sheets as the data source. This is the final destination for the query data in the spreadsheet above, but any other tool using Google sheets can be used to consume the data.

2

Thanks for your attention!

Don’t hesitate to contact if you need assistance setting up your own scheduled query!

Navino Evans

​

Email: navino@histropedia.com

​

Twitter and Wikimedia: @NavinoEvans

DATA RE–

USE DAYS

14 - 24 March 2022