Git Product home page Git Product logo

gsheets-append-action's Introduction

gsheets-append-action

Inputs

Input Required Default Description
GOOGLE_USER_MAIL true The user ID to authenticate the service account user.
GOOGLE_USER_KEY true The users private key to authenticate the service account user.
SPREADSHEET true The spreadsheet ID to append the data to.
DATA_FILE_PATH false The csv file containing the data to upload. Use either this or DATA_ENV_NAME. NOTE: If DATA_FILE_PATH is configured, DATA_ENV_NAME will be ignored.
DATA_ENV_NAME false The environment variable containing the data to upload in CSV format. Use either this or DATA_FILE_PATH. NOTE: If DATA_FILE_PATH is configured, DATA_ENV_NAME will be ignored.
TABLE_START_CELL false A1 The cell that defines the "table anchor" in the format sheetName!A1.
UPDATE false false Update or append data.

About private key

If you use GitHub Secrets to store a JSON private key, be mindful that you need to change all embedded \n linebreaks with real ones.

Given your JSON's private_key content is along the lines of:

-----BEGIN PRIVATE KEY-----\nBLABLABLABLABLA\nBLABLABLABLABLA\n-----END PRIVATE KEY-----\n

Change it to:

-----BEGIN PRIVATE KEY-----
BLABLABLABLABLA
BLABLABLABLABLA
-----END PRIVATE KEY-----

And use that as your GOOGLE_USER_KEY input.

Credit: https://github.com/dibenlloch/google-sheets-secrets-action

For action authors

After editing the action, run npm ci to regenerate dist/ and put edits into effect.

gsheets-append-action's People

Contributors

demonnic avatar dependabot[bot] avatar iamazeem avatar keneanung avatar vadi2 avatar

Stargazers

avatar

Watchers

avatar avatar avatar avatar avatar avatar

Forkers

keneanung vadi2

gsheets-append-action's Issues

List inputs in README in a table format

Please add the list of inputs in the README in a table format.

The table generation can be automated with yq:

$ cat action.yml | yq -r '.inputs | keys[] as $k | "| `\($k)` | \(.[$k].description) |"'
| `DATA_ENV_NAME` | The environment variable containing the data to upload in CSV format. |
| `GOOGLE_USER_KEY` | The users private key to authenticate the service account user. |
| `GOOGLE_USER_MAIL` | The user ID to authenticate the service account user. |
| `SPREADSHEET` | The spreadsheet ID to append the data to. |
| `TABLE_START_CELL` | The cell that defines the "table anchor" in the format `sheetName!A1`. |
| `UPDATE` | Update or append data. |

The generated table would look like this:

Input Description
DATA_ENV_NAME The environment variable containing the data to upload in CSV format.
GOOGLE_USER_KEY The users private key to authenticate the service account user.
GOOGLE_USER_MAIL The user ID to authenticate the service account user.
SPREADSHEET The spreadsheet ID to append the data to.
TABLE_START_CELL The cell that defines the "table anchor" in the format sheetName!A1.
UPDATE Update or append data.

This can further be refined to add required and default columns.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.