By integrating Yoom with Google Sheets, you can add, retrieve, or manipulate values from specific cells or rows.

This article explains how to configure the “Range Settings” for the actions “Integrate with Apps” and “Manage Databases.”

The following actions in the "Integrate with Apps" actions require setting a range:

In this operation, the range refers to specific cells. When setting the range, specify the cells where you want to add or retrieve data.

Example 1:
If you want to retrieve ID column values (from row 1 onward), set the range as A2:A in the "Retriev Value" action and select Column Direction.

Example 2:
If you want to retrieve values from row 2 only, set the range as A2:2 in the "Retrieve Value" action and select Row Direction.

In the "Manage Databases" actions, the range refers to the entire database, including column headers. This operation allows you to add or retrieve full rows, so you need to set the range for the whole table.

Example:
If you want to add rows under the column headers in the spreadsheet, set the table range for the Add Record action to something like A1:D, including the headers.

This way, the column names (headers) will appear on the next page, and you can input values under each corresponding column.

When you click Test, it will be reflected as shown in the image below.