Write metricminer data to Google Sheets using GitHub Actions

[howardbaek]

Purpose/implementation Section

What changes are being implemented in this Pull Request?

• .github/workflows/write-data.yaml: YAML file that triggers a GitHub Action every 2 minutes.
• R/write-data.R: R script that grabs data from Google Analytics in a list format and writes the data to this publicly accessible Google Sheet.

What was your approach?

I followed these two blog posts:

1. https://rfortherestofus.com/2023/05/github-actions
2. https://www.simonpcouch.com/blog/2020-12-27-r-github-actions-commit/

However, I think that in order to authorize("google"), we will need to store the token somewhere and then point to the location of this token in the YAML.

Tell potential reviewers what kind of feedback you are soliciting.

This PR is not ready yet, so will be in draft mode.

[howardbaek]

I found it complicated to be running GHA within an R package, so created another repo solely for running GHA: https://github.com/fhdsl/metricminer-actions

[cansavvy]

Based on the strategy I've outlined above and toward the goal of making maintenance easier, let's not use the https://github.com/fhdsl/metricminer-actions repo. Is that okay? hopefully you've not done too much work on that yet.

Edit: I think we will actually probably publish github actions on the marketplace as their own repo, but that will be down the road and will not be an R package.

[cansavvy]

I'm going to close this PR in favor of #52 And then I will be using that foundational work to return to this goal.