Skip to content

write-cell.md

Latest commit

 

History

History
36 lines (25 loc) · 1.17 KB

write-cell.md

File metadata and controls

36 lines (25 loc) · 1.17 KB

Write Cell

➡️ See the sendTo API documentation for general usage and all available commands. The write cell feature allows you to write data to a specific cell in a Google spreadsheet.

Used API endpoint: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets.values/update

The feature accepts the following parameters:

  • sheetName: The name of the sheet.
  • cell: The cell address (e.g. A1).
  • data: The value to write.
  • alias (optional): The spreadsheet alias if you have multiple spreadsheets configured.

Callback result: { success: true } on success, or { error: string } on failure.

Blockly

Blockly

In Blockly, the parameters sheetName and cell are combined to form the range-parameter for the Google API. The range-parameter can accept a sheet name and a cell in A1 notation. For instance, you can use 'Sheet1!A1' to target a specific cell.

Javascript

The given code snippet writes data to a specific cell in the spreadsheet.

sendTo(
  "google-spreadsheet", 
  "writeCell", {  
    "sheetName": "nameOfTab", 
    "cell": "A1",
    "data": "Hello, World!"
  }
);