📝 Overview

With Yoom, you can retrieve text and adjust its length using Google Sheets functions. This guide explains how to use Google Sheets to modify the character count of the retrieved text, allowing you to meet specific character length requirements.

In this example, we'll show you how to adjust the character count using the LEFT function in Google Sheets.

🛠️ How to Set Up

1. Prepare the Sheet with the LEFT function

In Google Sheets, set the function for the character limit in a specific cell (e.g., cell B2) to process the text in cell A2.

Use the formula: =LEFT(A2, 2000) to limit the text to 2,000 characters.

2. Enter the Original Text into the Specified Cell

In the Flowbot edit screen, click on the + after the trigger.

Select Google Sheets, select Input value into cell action, and configure the following:

Spreadsheet ID: Choose the spreadsheet where the function was inserted.
Sheet Name: Select the sheet containing the function.
Target Cell: Choose the cell where you want the text to be processed (e.g., A2).
Value: Select the operation that retrieves the text to apply the character limit, then embed the output.

3. Retrieve the value of the cell processed by the function

In the Flowbot edit screen, click on the + after the action you just set up.

Select Google Sheets, select the Retrieve value action, and configure the following:

Spreadsheet ID: Choose the spreadsheet containing the processed function.
Sheet Name: Select the sheet where the processed function is located.
Range: Choose the cell containing the result after processing (e.g., B2).
Direction: Choose the column direction.

4. Send the Text After Applying the Character Limit to the Chat Tool

In the Flowbot edit screen, click on the + after the action you just set up.

Select Slack, select the Send message to Channel, and configure the following:

Destination Channel ID: Copy the channel ID from Slack and paste it here.
Message: Select the output from step 3 that contains the value after applying the character limit.

☝️ Notes

This process will allow you to adjust the length of the retrieved text according to your needs, using Google Sheets to set the desired character limit.

📚 Related Guides

What is Retrieved Value? - View Guide Here
Useful Google Sheets Functions for Yoom Integration - View Guide Here

Search Keywords

Slack, Google Sheets, Yoom integration, text trimming, character count, retrieve text

How to Adjust the Character Count of Retrieved Text Using Google Sheets