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
2. Click on Step 1: "Schedule"
Then select the Day of the week, Hour of the day and Timezone
3. Test the step
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.
5. Connect your Google Sheet account
6. Select your desired spreadsheet. Once you connect your Google Sheets account, all spreadsheets associated with that account will be displayed in your builder.
7. Select the specific sheet you want to use.
8. Test your step
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.
10. Pass in the data from your Google Sheet. This is the data that would be looped on
11. Test the step
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.
13. Add your API key to connect your Firecrawl account
14. Pass in the URL of the website you want to scrape with Firecrawl
15. Test the Step
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
17. Select the AI model you want to use.
18. Select the AI model
19. Pass in the data of the old price from the Google sheet and the data of new price from Firecrawl
20. Test the step
21. Click on Step 6: "Router"
This step helps us to add conditions to our automation
22. Test the step
23. Click "Branch 1"
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.
25. Test your step
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
27. Connect your Google Sheets account and select your desired spreadsheet and target sheet
28. Add the row number to identify the row you want to update
29. Pass in the new price from step 5
30. Test the step
31. Click on Step 8: "Send Email"
32. Connect your Gmail account
33. Add the receiver email address
34. Add the email subject
35. Add the email body
36. Test the step