Public
Like
6
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in miliseconds.
Wrapper around Google Sheets API v4.
- service_account: JSON string containing Google Service Account key
- sheet_id: Google Sheet ID
- method: HTTP method to use
- action: Full URL with
https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/removed - data: HTTP request body
- a Google Cloud service account
- the Google Sheets API v4 enabled in your Google Cloud project
- the spreadsheet ID (provide it in the sheet_id parameter)
- Share the spreadsheet with the service account
- Make a JSON key for the service account, then set it as a secret. Use the secret for the service_account parameter.
- 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 - Figure out the request body. For example:
{values: [["foo", "bar", "baz"]]}
Migrated from folder: gsheets/gsheet_call