Просмотреть исходный

Insert table Version 6 (Net)

Action group: Google services

Description

The action writes data from a variable of type Table to the specified area of the active google table page.

Action icon

Settings of parameters

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Indentifier of session for action	Robin.SpreadShee ts	SpreadSheets context	Yes
Document ID	Indentifier of document for action	Robin.String		Yes
Sheet	Name of working sheer. По умолчанию первый лист документа.	Robin.String		No
From сell	Address of starting сell to set values In fomat «XY», where «X» - column name and «Y» - row index	Robin.String		Yes
Data table	Data table to set values	Robin.DataTable		Yes
Whith heading	If value is «true», the table header will be inserted into the document along with its rows.	Robin.Boolean	true	No

Special conditions of use

The Google Sheets API has a limit of up to 60 read-requests per user per minute. To ensure that the action does not immediately generate an error when the limit on the number of requests is reached, the action includes a loop operation that will resend requests within a minute.

If the request is completed in that time, the action will complete successfully.
If the request cannot be sent in this time, the robot will terminate with an error.

For the "With heading" parameter:

When true, the action will write the header row of the source table as the first row in the document along with the rest of the main rows of the table. Example: the Studio specifies that the table "Columns: 3; rows: 2", when pasted into the document, 3 columns and 3 rows will be filled in.
If "false", the action will only write to the document the main rows with the contents of the source table. Example: the Studio specifies that the table "Columns: 3; rows: 2", when inserted into the document, 3 columns and 2 rows will be filled.

Target table	Table after insertion without checkbox "With header" checked	Table after insertion with checkbox "With header" checked

Example of use

Task

There is a Google spreadsheet with values:

It is necessary to take the area of values from cell "B1" to "C4". And then insert the obtained table (area) starting from cell "A7".

Solution

Use "Context Google tables", "Get area form table", "Insert table" actions.

Implementation

Assemble a robot scheme with the actions:
Set the "Context Google tables" action parameters.

Fill in the "File path" and "Project name" fields (more information about filling in these fields in the Instructions for setting up a connection to Google Sheets/Docs/Drive)
Set the parameters for the "Get area from table" action:

In the "Document ID" field, specify the reference part of the table.
Set the parameters for the "Insert table" action:

In the "Document ID" field, specify the reference part of the table.
Click "Start" in the top panel to start the robot.

Result

The program robot completed successfully.

Документация ROBIN > Insert table (Google services) > image2024-1-24_16-49-29.png

The required value area is obtained and inserted into the given sheet starting from cell "A7".

Документация ROBIN > Insert table (Google services) > image2024-1-24_16-49-4.png