Welcome to the Tableau Public Auto-refresh wiki! This step-by-step guide will walk through how to reproduce this project. By the end of this tutorial you will be able to use R to create a simple dataset, export the data to Google Drive as a Google Sheet file and set up a Github Action to run the script on a schedule.

The R script in this example creates a dataset that changes each time the script is run. The data itself is meaningless but is useful for showing how automation within a Tableau Public dashboard is possible.

The end product for this tutorial (the Tableau Public dashboard) can be found here.

I would like to give credit to R by R(yo) whose intuitive article on building a data pipeline with Github Actions and the googledrive package helped guide this project.

Steps in the workflow

1. Getting started
2. Set up Google Cloud services
3. Set up Google Drive services
4. Set up R script
5. Set up GitHub Actions
6. Set up Tableau Public dashboard