$integration.googleSheets.writeDataToLine

The method is used to write data to a new line in a Google spreadsheet.

Syntax

The method accepts 4 required arguments.

Argument	Description	Type
integrationId	Integration identifier	String
spreadsheetId	Google spreadsheet identifier	String
sheetName	The name of the necessary sheet	String
values	The data written to the spreadsheet	Array of strings

An example of calling the method:

ECMAScript 5

$integration.googleSheets.writeDataToLine(
    "4404df16-bfc7-4bc6-9f84-65d02d000217",
    "1gdkEwg2KMeKYJK-yrxgKuk9-uP7ntjtKg5ChDu8906E",
    "Sheet1",
    ["Margaret", "Wickham", "78121683203"]
);

ECMAScript 6

In the ECMAScript 6 runtime, the method is asynchronous.

await $integration.googleSheets.writeDataToLine(
    "4404df16-bfc7-4bc6-9f84-65d02d000217",
    "1gdkEwg2KMeKYJK-yrxgKuk9-uP7ntjtKg5ChDu8906E",
    "Sheet1",
    ["Margaret", "Wickham", "78121683203"]
);

Action

The method writes the values passed as arguments to the beginning of the first line in the necessary sheet where the required number of cells is not occupied.

tip

This means that the method does not overwrite data already existing in the spreadsheet, but appends new data instead.

Example

This is an example of using the method for adding a new client to the database.