An automated data pipeline using R and GitHub Actions

In the April 2022 afrimapr community meetup,, Anne Treasure showcased a data pipeline developed for reading data from a Google Form & Spreadsheet to visualise via interactive web apps: R Shiny and Kumu. We looked at steps for setting up non-interactive authorisations to enable automation and integrating with Google Spreadsheets. The workflow is automated using GitHub Actions.

The workflow is currently under development for the ESCALATOR programme (https://escalator.sadilar.org) and forms part of the South African Digital Humanities and Computational Social Sciences Stakeholder Map project (https://escalator.sadilar.org/stakeholder-map/).

To learn more about the workflow or ESCALATOR programme, please contact Anelda van der Walt (escalator@talarify.co.za) or Anne Treasure (dhcss-stakeholdermap@talarify.co.za)

afrimapr’s monthly virtual meetups aim to support the development of an active African R mapping community. It offers you a chance to learn about new resources, ask questions, showcase your work, and grow your R mapping network. Join our Google Group to stay up to date about upcoming opportunities and events: https://groups.google.com/u/0/g/afrimapr Website: https://afrimapr.org Twitter: https://twitter.com/afrimapr