# How To Automate Competitor Price Change Alert By Ginikachukwu Nwibe · 2025-09-30 · Source: https://www.activepieces.com/blog/how-to-automate-competitor-price-change-alert --- This guide provides a step-by-step process for automating alerts on competitor price changes, which can significantly enhance your competitive strategy. By implementing this automation, you can save time and ensure you stay informed about market fluctuations, allowing for timely adjustments to your pricing or marketing strategies. The detailed instructions make it accessible even for those with minimal technical expertise, empowering you to leverage data effectively for business growth. You can get the template here: https://cloud.activepieces.com/templates/2RrncY4W3FaRBsNVCZVgG 1\. Paste the template URL inside your browser ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/7e96a08d-6ba5-4c91-b79c-00b6e19b9bf0/ascreenshot.jpeg?tl_px=62,269&br_px=2539,1654&force_format=jpeg&q=100&width=1120.0) 2\. **Click on Step 1: "Schedule"** Then select the **Day of the week**, **Hour of the day** and **Timezone** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/7e96a08d-6ba5-4c91-b79c-00b6e19b9bf0/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=519,117) 3\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/aa2bbb85-9b52-404f-841f-748ef9f91a67/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=996,389) 4\. **Click on Step 2: "Google Sheets"** In this step, we used the **Find Rows** action on Google sheet. This step helps us to find the desired rows we want to work with. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/2b4c6640-15b0-4985-812e-e667891e40a2/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=500,229) 5\. Connect your Google Sheet account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/38d9f594-660b-4644-a029-3f84cbf1dc45/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=922,128) 6\. Select your desired spreadsheet. Once you connect your Google Sheets account, all spreadsheets associated with that account will be displayed in your builder. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/93d52805-3dc7-4622-be4c-d9844ca65837/ascreenshot.jpeg?tl_px=125,488&br_px=2602,1873&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=866,277) 7\. Select the specific sheet you want to use. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/0133618c-dda4-4071-9706-5281b796145c/ascreenshot.jpeg?tl_px=125,33&br_px=2602,1418&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) 8\. Test your step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/649271d1-680f-48ab-98b0-fa54fd7eccbc/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=997,338) 9\. **Click on Step 3: Loop on Items** A loop is used to go through a list of items one by one. In this case, the list comes from the rows in your Google Sheet. The loop will pick each row individually, so you can run actions for that specific row. Here, the loop makes sure every row of data from your sheet goes through the same steps, instead of handling them all at once. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/bc16eea3-0e66-4df0-ab7c-fed3b83c5ebf/ascreenshot.jpeg?tl_px=0,159&br_px=2476,1544&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=506,277) 10\. Pass in the data from your Google Sheet. This is the data that would be looped on ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/8eb3ce05-ff2d-4844-b34d-9519be5e564d/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=686,287) 11\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/271b6cc4-a02d-4e19-a313-8327efa61d41/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=997,326) 12\. **Click on Step 4: "Firecrawl"** Firecrawl is an AI-powered tool that crawls or scrapes websites through their URLs and converts the content into clean, LLM-ready data. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/29aa4e84-9047-4ee9-bacf-dde5ee922ef1/ascreenshot.jpeg?tl_px=125,102&br_px=2602,1487&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=611,277) 13\. Add your API key to connect your Firecrawl account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/b0751591-0d88-468d-82a5-be61c431052a/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,243) 14\. Pass in the URL of the website you want to scrape with Firecrawl ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/c096138f-0170-4c2b-bc5b-d7d64ae9ef2f/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=1015,257) 15\. Test the Step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/dcbb525d-c9f2-48c3-96ca-7ec839c3d713/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=1022,329) 16\. **Click on Step 5: " Check For Price Change"** This is the native AI piece that would be used to check for price change from the data returned from Firecrawl ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/a578fe3b-5980-4585-979f-3baae479e7e9/ascreenshot.jpeg?tl_px=125,15&br_px=2602,1400&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=596,277) 17\. Select the AI model you want to use. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/613a69c8-6335-46cc-9ad9-f8c4ea8853b7/ascreenshot.jpeg?tl_px=125,39&br_px=2602,1424&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=740,277) 18\. Select the AI model ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/748b3166-b97e-4e3f-bb5d-2cc5dac10e2a/ascreenshot.jpeg?tl_px=125,181&br_px=2602,1566&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=851,277) 19\. Pass in the data of the old price from the Google sheet and the data of new price from Firecrawl ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/ad64149e-de86-46b6-adb5-6a1457d58f5f/ascreenshot.jpeg?tl_px=125,140&br_px=2602,1525&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=1020,277) 20\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/7058d53a-5959-4ca5-a4c5-47886c12cb6c/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=1006,340) 21\. **Click on Step 6: "Router"** This step helps us to add conditions to our automation ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/01a0edc0-a876-4e21-8f65-85ba5f51c0df/ascreenshot.jpeg?tl_px=97,0&br_px=2574,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,265) 22\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/1cb382a9-7a32-4c30-ae51-88df58816ac1/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=998,330) 23\. Click "Branch 1" ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/fab1cfaf-2683-45ee-8c79-27aa3463054c/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=406,341) 24\. Add conditions to branch 1. Here our condition checks if there is a price change based on the analysis done in step 5. This means that the steps under branch 1 (step 7 and 8) will only be excuted if there is a price change. ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/e2641e41-f110-496a-b83e-3afbeef82583/user_cropped_screenshot.webp?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=408,581) 25\. Test your step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/a9bc974e-6ba7-4f13-89b0-52e6a99a0be4/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=995,339) 26\. **Click on Step 7: "Update Sheet"** This is the part where the sheet is updated with the new price. You need to select the **Update Sheet** action from Google Sheets ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/f77995a6-db19-4358-acc0-294c054b6141/ascreenshot.jpeg?tl_px=0,127&br_px=2476,1512&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=501,277) 27\. Connect your Google Sheets account and select your desired spreadsheet and target sheet ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/e3b6c478-73d9-484a-8593-559c9d9aff84/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,113) 28\. Add the row number to identify the row you want to update ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/8b7337da-36b4-4517-a69d-3af1014a5782/user_cropped_screenshot.webp?tl_px=0,45&br_px=2476,1430&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=472,277) 29\. Pass in the new price from step 5 ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/42598fb0-7fe9-4515-95f3-c45a974d9c72/user_cropped_screenshot.webp?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=599,410) 30\. Test the step ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/21619e40-6036-4bbd-b03b-cfe9b46c0fd8/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=998,330) 31\. **Click on Step 8: "Send Email"** ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/aa9c0c5f-0f67-4e8c-971e-37916577e027/ascreenshot.jpeg?tl_px=0,344&br_px=2476,1729&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=430,277) 32\. Connect your Gmail account ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/28c9ca6a-4e75-4e0a-b116-1447b9b28723/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=782,173) 33\. Add the receiver email address ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/50f57788-55ab-4702-90a1-ec7ef557ada7/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=819,260) 34\. Add the email subject ![](https://ajeuwbhvhr.cloudimg.io/https://colony-recorder.s3.amazonaws.com/files/2025-09-30/0bb3b226-8195-46a5-bb50-fbe0ee580f22/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=1054,200) 35\. Add the email body 36\. Test the step #### [Made with Scribe](https://scribehow.com/shared/How_To_Automate_Competitor_Price_Change_Alert__HBeWIkcRQxS7CGryHydv6A)