📝 Overview
By integrating Yoom with Google Sheets, you can automatically generate and retrieve a UUID (Universally Unique Identifier), such as:
550e8400-e29b-41d4-a716-446655440000
This guide explains the entire setup process.
Flowbot Overview
This is the structure of the Flowbot we will create.
In this guide, we'll send the retrieved UUID to Slack, but you can also send it to another app or store it in Yoom’s database.
🛠️ Setup Steps
1️⃣ Create a UUID Generator Using Google Apps Script (GAS)
1. Open the Google sheet you want to use.
2. Go to Extensions → Apps Script.
3. Paste the following code:
function getUuid() {
return Utilities.getUuid();
}4. Click Save.
💡 Refer to official Google Sheets documentation for detailed GAS setup if needed.
2️⃣ Configure UUID Generation in Google Sheets
In the target Google Sheets enter this formula in cell A2.
=IF(B2<>"",(getUuid()),"")
How it works: When you enter a value in B2, a UUID will be automatically generated in A2.
3️⃣ Automatically Trigger UUID Creation from Yoom
In Yoom, select Google Sheets from the App Integration options.
Choose the action "Input value in cell".
Configure the following:
Spreadsheet ID: select the Google sheet you set up.
Sheet name: Choose the specific sheet.
Target cell: Select the cell in which you will place the text or string you want to process.
(In this example, we select B2).Value: Enter the text or data you want to process (or embed an output from a previous step).
👉 For more details on embedding the output, check the guide here.
💡 When B2 is filled, A2 will auto-generate a UUID.
4️⃣ Retrieve the Generated UUID
In Yoom, select Google Sheets again.
Choose the "Retrieve Value" action.
Configure the following:
Spreadsheet ID: Same as above.
Sheet name: Same as above.
Range: Select the cell where the UUID appears.
(In this example, we select A2.)Direction: Select the column.
5️⃣ Reset the Trigger Cell for Next UUID Generation
In Yoom, select Google Sheets again.
Choose the "Delete Value" action.
Configure the following:
Spreadsheet ID: Same as above.
Sheet Name: Same as above.
Range: Select the cell whose post-function processing value you want to retrieve.
(In this example, we select B2).
💡 Clearing B2 allows the next UUID generation to work properly.
6️⃣ Send UUID to Another App or Database
Use the retrieved UUID as an output and send it to any tool such as:
Slack
Yoom Database
CRM/ERP System
Example: Send the UUID to Slack to confirm its generation.
‼️ Important Notes
Avoid Duplicate Triggers
Since the value in the target cell (in this example, B2) is overwritten every time, ensure the current Flowbot process finishes before running another.
(Simultaneous runs may cause UUID duplication retrieval errors).
Step 5 is Mandatory
Deleting the trigger cell is essential to generate new UUID in future runs.
🎉 You’ve Completed the Setup!
You can now generate and retrieve UUIDs using Google Sheets and Yoom. 🚀
Search keywords
Search keywords
Google sheets, Google, Yoom, UUID, GAS, Spreadsheet Automation