# Automate Topic Cluster Generation From Keywords By Ginikachukwu Nwibe · 2025-10-07 · Source: https://www.activepieces.com/blog/automate-topic-cluster-generation-from-keywords --- This guide provides a comprehensive workflow for automating the generation of topic clusters from keywords using Activepieces. By following the steps outlined, users can efficiently organize and analyze keyword data, ensuring they target relevant topics effectively. The automation not only saves time but also enhances the accuracy of data handling, making it an invaluable resource for marketers and content creators looking to optimize their strategies. 1\. Navigate to ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/9a7bb368-b89a-41ba-8a11-1cfd000ea387/ascreenshot.jpeg?tl_px=62,269&br_px=2539,1654&force_format=jpeg&q=100&width=1120.0) 2\. **Click on Step 1: "New Spreadsheet"** This is the first step of this workflow. It starts once a new spreadsheet is exported from Ahrefs ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/9a7bb368-b89a-41ba-8a11-1cfd000ea387/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=537,176) 3\. Connect your Google Sheet account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/bfdb4dbe-0899-476f-b797-0f987700e697/ascreenshot.jpeg?tl_px=125,184&br_px=2602,1569&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=869,277) 4\. Test your step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/cd111c30-24b3-4311-b887-7ce2b0326f50/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=921,329) 5\. **Click Step 2: The Find Rows action from the Google Sheet piece** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/546036b9-9fda-4472-8ceb-92317ac38941/ascreenshot.jpeg?tl_px=0,137&br_px=2476,1522&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=423,277) 6\. Connect your desired Google sheets account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/6a0def54-d430-46cb-ad49-5b856f4f7162/ascreenshot.jpeg?tl_px=125,214&br_px=2602,1599&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=876,277) 7\. Add the ID of the new spreadsheet. This will enable us to easily find the rows ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/0f79a737-8ca2-47a0-9dbd-04a922e11ad3/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=956,167) 8\. Select the name of the column you want to search ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/1e49b572-8c55-4252-be3a-a02a0530cfac/ascreenshot.jpeg?tl_px=125,330&br_px=2602,1715&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=807,277) 9\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/43a4a39b-13af-4a46-9bdd-632d880b39fd/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=904,334) 10\. **Click Step 3: Router.** This is the piece that helps you to add conditions to your automation ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/979cdbaa-12de-41c1-a719-7c766942fb7a/ascreenshot.jpeg?tl_px=8,0&br_px=2485,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=524,248) 11\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/bc03a92d-095a-4bc5-a986-05244e3acd0e/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=916,327) 12\. Click "Branch 1" ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/56260dcb-341f-4e76-95ae-3578be2e50b4/ascreenshot.jpeg?tl_px=0,62&br_px=2476,1447&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=278,277) 13\. **Set Conditions for branch 1:** The conditions are set to check each row for any presence of the words ***"keyword"*** and ***"Country"*** This shows that we are targeting the right spreadsheet and that data on the row is complete ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/2f702c22-39d0-46fb-8dd2-fbe0cf44a46a/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=865,148) 14\. Test the Step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/4546e9ce-56a7-498f-8ab1-803a6eb5b0d5/ascreenshot.jpeg?tl_px=0,0&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=1013,547) 15\. **Click Step 4:** Find Row action from Google Sheet piece ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-01/1b756c00-2b7d-43d3-af82-bfe51c155c6b/user_cropped_screenshot.webp?tl_px=0,8&br_px=2476,1392&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=440,278) 16\. Connect your Google Sheets account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/5b7676ba-b7f9-4b6b-9838-9e18127add27/ascreenshot.jpeg?tl_px=125,218&br_px=2602,1603&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=925,277) 17\. Add the spreadsheet ID ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/0f0f7e97-5d9a-4ec5-a5ee-eac70c8d9827/ascreenshot.jpeg?tl_px=76,539&br_px=2553,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=524,386) 18\. Select the specific sheet you want to use ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/33b3ceb1-0c3e-4613-8e92-124377e2d9f5/ascreenshot.jpeg?tl_px=125,199&br_px=2602,1584&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=823,277) 19\. Select the name of the column to search in ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/721aa7e5-9629-446a-9c20-3da3eb1e8f59/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=814,339) 20\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/fadc60ec-ccc0-46da-b4fe-58664f6be31b/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=902,337) 21\. **Click Step 5:** Create Worksheet ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/e723546c-a0ee-49d2-b81b-8155910350d8/ascreenshot.jpeg?tl_px=0,8&br_px=2476,1393&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=475,277) 22\. Connect your Google Sheet account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/3685664d-704a-4a35-af68-6fd0561aeef2/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=890,199) 23\. Add the ID of the spreadsheet you want to create the new worksheet in ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/cb4b9bb4-99f6-47c5-b2da-28de2c423a36/ascreenshot.jpeg?tl_px=125,74&br_px=2602,1459&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=964,277) 24\. Add the title of the new worksheet ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/5705976a-96f4-4363-aa10-9e45aed75297/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=931,223) 25\. Add the headers you want in the new worksheet ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/3b6f2520-8966-4fa4-b0e5-73135758c221/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=873,98) 26\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/3b4dc76e-a218-4674-bad6-5de4e0db4cf9/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=934,336) 27\. **Click step 6**: Loop on items ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/51e56681-f472-447e-8c58-d43893315d3b/ascreenshot.jpeg?tl_px=11,19&br_px=2488,1404&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=524,277) 28\. Pass in the data of the rows we found in step 4 ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/9b0de9da-e9bf-4ef0-8ae6-6579e23e95b3/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=671,385) 29\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/79c29431-8e46-4430-9bb1-16a5cf4ec7a2/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=904,332) 30\. **Click Step 7: Router** This enables you to add conditions to your workflows ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/0a044281-417f-4647-a4db-b479289bd639/ascreenshot.jpeg?tl_px=125,78&br_px=2602,1463&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=614,277) 31\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/886d40e5-2cd2-41b3-beae-f4eca2d8cf3c/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=916,331) 32\. Click "Branch 1" ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/1105da99-c0b4-4e01-aff6-479b80f6b52c/ascreenshot.jpeg?tl_px=0,0&br_px=2476,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=512,196) 33\. Add conditions for branch 1 This condition checks if the search volume of each keyword that has been looped on is more than 799 ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/bfe4f4f0-9544-4ecb-9ecc-a4dfb2bb4266/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=861,153) 34\. Test the branch step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/a09954ac-4fbf-4b09-a0c9-2280ec3ee6a5/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=994,333) 35\. **Click Step 8:** "Add To List" from the Storage Piece. This is where we add each keyword that's 799 and above to make a list which will be used later. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/7b40224f-2c86-4a80-a8a5-45c35e272345/ascreenshot.jpeg?tl_px=40,0&br_px=2517,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=524,191) 36\. Add the key, which is where you want to store the data. Data in storage is usually used in key-value pairs. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/6945229d-e763-47c8-a4e7-d42c9dcfab0f/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=1014,180) 37\. Add the value. In this step, we are trying to add all keywords that are above 799 into a list so that we can use them in the next steps. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/5dff9521-21d9-48f2-b218-4e42365089ff/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=1039,277) 38\. Now we need to select what scope we want the storage. for this usecase, we are storing the data to just be used in this project ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/a848a547-c3a4-4372-a4e4-9c36784d1fa4/ascreenshot.jpeg?tl_px=125,374&br_px=2602,1759&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=849,277) 39\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/20ffefad-8db9-4346-b88e-a77a5902fa69/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=887,336) 40\. **Click step 9: "Get " from the Storage piece.** This is where we retrive the data that was stored in a list in step 8 ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/74f1d353-9339-40ae-a7f1-3cd25cc08403/ascreenshot.jpeg?tl_px=0,195&br_px=2476,1580&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=431,277) 41\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/9ed4c37a-dce2-4f5b-9c93-a8c8cf1d813e/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=907,340) 42\. **Step 10: Extract structured data** Here we want to extract data from the storage and group them into clusters ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/1526b441-996f-48ab-947e-c633da35f711/ascreenshot.jpeg?tl_px=0,0&br_px=2476,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=463,265) 43\. Click "Test Step⌘ + G" ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/b7acd3dd-c8c6-4b05-99d9-f7b74b4dd328/File.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=920,338) 44\. Select Providers ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/5dbc77f1-4acb-4f8c-9895-2e7e1631693f/ascreenshot.jpeg?tl_px=125,27&br_px=2602,1412&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=799,277) 45\. Select Model ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/9aba8b24-c20c-4c02-a514-e1e35638ed16/ascreenshot.jpeg?tl_px=125,276&br_px=2602,1661&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=847,277) 46\. Pass in the text we want to extract structured data from. Here we want to extract structured data from the data stored in the storage piece. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/ec301ed9-bf4d-406f-ba8f-455c29f00d77/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=885,178) 47\. Add your guide prompt (This will be available in the template) ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/64d8c6ed-0555-4cca-a860-e8834816fba8/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=933,188) 48\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/280a122c-5bb1-45a7-ae37-456ec5a1f28c/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=919,329) 49\. **Click step 11: "Loop on Items"** Here we want to go over each data in the list of clusters and take individual actions on them. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/67ab7ad1-35e2-4f23-9025-991d978f812c/ascreenshot.jpeg?tl_px=0,0&br_px=2476,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=368,275) 50\. Pass in the data from **step 10** to be looped over. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/bb32e619-4a44-4992-a771-86db01364867/ascreenshot.jpeg?tl_px=125,49&br_px=2602,1434&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=1034,277) 51\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/2623a520-4a63-4fa5-8df2-7d4cf231b7a3/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=928,326) 52\. **Click step 12: Extract Structured Data** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/7475e85b-e25f-480a-b287-2e41ea93c524/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=548,230) 53\. After selecting AI provider and model, pass in the clusters you looped on into the text field. We are going to extract the data from each cluster. After that add your guide prompt (which will be provided in the template) ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/35109526-4080-4ef0-9791-a42ea00b5d5d/ascreenshot.jpeg?tl_px=125,96&br_px=2602,1481&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=975,277) 54\. Test your step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/b1f4b4f6-078e-413f-90d5-38a32d0e98c5/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=898,335) 55\. **Click step 13: Call Flow** This helps us to use data from this flow easily in another flow. This is because this workflow is accompanied by an outline generator flow which will use data from this flow. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/e613ee06-c606-4094-9ddc-41da80a24f86/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=534,256) 56\. Select the workflow where you want to use the callable flow ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/717afb09-01fc-47ce-9247-0562e5e3c371/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=847,248) 57\. Click "Simple" ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/6abffe06-b086-43a4-aba6-37750c597320/ascreenshot.jpeg?tl_px=125,30&br_px=2602,1415&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=825,277) 58\. Add the data you want to send to be used in the other flow ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/12b80e4e-9efd-41f1-ad02-a3566c057b70/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=929,161) 59\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/3431efc4-1c54-4801-9ae2-8c171f10a633/ascreenshot.jpeg?tl_px=125,518&br_px=2602,1903&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=904,277) 60\. **Click step 14: Loop on keywords** Here we will loop the keywords in the clusters from Step 11 ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/1d61b390-6015-442f-ab83-4e899ba235c9/user_cropped_screenshot.webp?tl_px=119,0&br_px=2596,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=524,247) 61\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/18961fa2-2a0b-486f-bb16-88472300f4c3/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=906,329) 62\. **Click step 15: "Find Rows"** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/16081f02-b6e3-44c4-aaf9-395e3ae90793/ascreenshot.jpeg?tl_px=125,304&br_px=2602,1689&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=581,277) 63\. Connect your Google sheet account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/4fe51a8d-a620-4cfc-bbf4-99475d610d39/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=917,188) 64\. Pass in the ID of your target spreadsheet ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/ff9e4525-6f0c-4edb-bc5c-7dc6404baecd/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=952,120) 65\. Pass in the value you want to search for and test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/d5747a6e-6bb4-4722-aa2f-19b0f23982a0/ascreenshot.jpeg?tl_px=125,0&br_px=2602,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=971,181) 66\. **Click step 15: Append** Here we are assembling the data in storage which will be retrieved and used later in step 17 ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/191f6316-96e4-47ad-a92a-3c38553c4e49/ascreenshot.jpeg?tl_px=389,0&br_px=2454,1153&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=538,254) 67\. Add the key which is the spreadsheet ID. Then add the value . ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/e6f5309d-a729-4c37-b872-987145b5c7fc/ascreenshot.jpeg?tl_px=389,0&br_px=2454,1153&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=1006,182) 68\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/e4e9fc47-7221-4179-9f85-9872130efeaf/ascreenshot.jpeg?tl_px=389,735&br_px=2454,1888&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=888,277) 69\. **Click step 16: Get** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/d6c6000d-8a9b-44c4-9980-3088c3702c60/ascreenshot.jpeg?tl_px=155,317&br_px=2220,1470&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=524,276) 70\. Add the ID of the spreadsheet you want to get data from ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/a708a7fc-49db-4878-a9ce-9f27fa7b50bd/ascreenshot.jpeg?tl_px=389,0&br_px=2454,1153&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=1008,171) 71\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/cc14c081-a88b-4aec-8732-b18a8a78606a/ascreenshot.jpeg?tl_px=389,723&br_px=2454,1876&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=930,277) 72\. **Click step 17: Insert Row** Here we will insert the data from step 15 ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/c0c21213-def9-43e7-8d68-fc17ca994964/ascreenshot.jpeg?tl_px=189,526&br_px=2253,1679&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=524,276) 73\. Connect your Google sheet account, select your spreadsheet and sheet ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/916dcd64-5c32-4e6f-8af0-7f035900c649/ascreenshot.jpeg?tl_px=389,0&br_px=2454,1153&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=969,137) 74\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/9f7e1885-b391-4d1d-96f8-83a39c8ad6c7/ascreenshot.jpeg?tl_px=389,714&br_px=2454,1867&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=911,276) 75\. **Step 18 & 19: Remove** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/bfc74943-2a79-467a-a573-bb8404b8fd70/user_cropped_screenshot.webp?tl_px=0,496&br_px=1830,1654&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=687,456) 76\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/3993763a-3dd6-4daf-bba0-cba829049b8f/user_cropped_screenshot.webp?tl_px=0,0&br_px=1511,1201&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=815,579) 77\. **Click step 21: Remove** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/f6d9919f-6c38-4783-aa8e-6b3a0bb97de4/user_cropped_screenshot.webp?tl_px=0,0&br_px=2029,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=439,161) 78\. Add the ID of the spreadsheet you want to remove data from ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-10-07/71a7c7b3-782c-41d6-8d9d-7af3820e9b9e/user_cropped_screenshot.webp?tl_px=0,0&br_px=1652,1384&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=932,180) 79\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/c539c61e-094e-4a54-8376-50a15da187f9/ascreenshot.jpeg?tl_px=125,539&br_px=2602,1924&force_format=jpeg&q=100&width=1120.0&wat=1&wat_opacity=0.7&wat_gravity=northwest&wat_url=https://colony-recorder.s3.us-west-1.amazonaws.com/images/watermarks/FB923C_standard.png&wat_pad=906,335)