Wrapper around Google Sheets API v4. You will need:

  • a Google Cloud service account
  • the Google Sheets API v4 enabled in your Google Cloud project
  • the spreadsheet ID (provide it in the sheetId parameter)
  1. Share the spreadsheet with the service account
  2. Make a JSON key for the service account, minify it and set it as a secret.
  • Use the secret for the serviceAccount parameter.
  1. Figure out the action you want to perform.
  • You will need to provide everything that comes after {spreadsheetId}/ as the action parameter. For example: values/A1:C1:append?valueInputOption=RAW
  1. Figure out the request body. For example: {values: [["foo", "bar", "baz"]]}