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.

Ginika Nwibe
36 steps
3 minutes

Activepieces

Paste the template URL inside your browser<https://cloud.activepieces.com/projects/PYEQJnN4o2x6okfrsworQ/flows/CbazcjxsEPy6q3ta7Eeis>

**Click on Step 1: "Schedule"** Then select the **Day of the week**, **Hour of the day** and **Timezone**

Test the step

**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.

Connect your Google Sheet account

Select your desired spreadsheet. Once you connect your Google Sheets account, all spreadsheets associated with that account will be displayed in your builder.

Select the specific sheet you want to use.

Test your step

**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.

Pass in the data from your Google Sheet. This is the data that would be looped on

Test the step

**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.

Add your API key to connect your Firecrawl account

Pass in the URL of the website you want to scrape with Firecrawl

Test the Step

**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

Select the AI model you want to use.

Select the AI model

Pass in the data of the old price from the Google sheet and the data of new price from Firecrawl

Test the step

**Click on Step 6: "Router"** This step helps us to add conditions to our automation

Test the step

Click "Branch 1"

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.

Test your step

**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

Connect your Google Sheets account and select your desired spreadsheet and target sheet

Add the row number to identify the row you want to update

Pass in the new price from step 5

Test the step

**Click on Step 8: "Send Email"**

Connect your Gmail account

Add the receiver email address

Add the email subject

Add the email body

Test the step

How To Automate Competitor Price Change Alert

Ginika Nwibe
36 steps
3 minutes

Activepieces

Paste the template URL inside your browser<https://cloud.activepieces.com/projects/PYEQJnN4o2x6okfrsworQ/flows/CbazcjxsEPy6q3ta7Eeis>

**Click on Step 1: "Schedule"** Then select the **Day of the week**, **Hour of the day** and **Timezone**

Test the step

**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.

Connect your Google Sheet account

Select your desired spreadsheet. Once you connect your Google Sheets account, all spreadsheets associated with that account will be displayed in your builder.

Select the specific sheet you want to use.

Test your step

Pass in the data from your Google Sheet. This is the data that would be looped on

Test the step

**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.

Add your API key to connect your Firecrawl account

Pass in the URL of the website you want to scrape with Firecrawl

Test the Step

**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

Select the AI model you want to use.

Select the AI model

Pass in the data of the old price from the Google sheet and the data of new price from Firecrawl

Test the step

**Click on Step 6: "Router"** This step helps us to add conditions to our automation

Test the step

Click "Branch 1"

Test your step

**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

Connect your Google Sheets account and select your desired spreadsheet and target sheet

Add the row number to identify the row you want to update

Pass in the new price from step 5

Test the step

**Click on Step 8: "Send Email"**

Connect your Gmail account

Add the receiver email address

Add the email subject

Add the email body

Test the step