Client's task:
It was necessary to set up a system that automatically checks product prices on different websites and inputs them into a Google spreadsheet.
The spreadsheet already had links to product cards (columns with URLs), as well as separate fields for prices. It was required to ensure that for each row, the link was taken, the current price was extracted, and placed in the corresponding column.
What was implemented:
The Make platform (ex-Integromat) was used to build the automation.
A scenario was set up that:
- goes through all the rows of the spreadsheet,
- retrieves the HTML page from the specified link,
- parses the price from it using regular expressions (Match Pattern),
- inputs the result into the required column of Google Sheets.
Additionally, price change monitoring was implemented:
- if the new price differs from the previous one, a notification with details (old price, new price, percentage change) is sent to a Telegram chat.
Special cases were handled (spaces, non-breaking spaces, fractional values with a dot/comma).
Result:
The client received a convenient monitoring system that operates without manual actions.
Prices in Google Sheets are always up to date.
All changes are monitored in Telegram, and the scenario automatically runs at the specified time.
It was necessary to set up a system that automatically checks product prices on different websites and inputs them into a Google spreadsheet.
The spreadsheet already had links to product cards (columns with URLs), as well as separate fields for prices. It was required to ensure that for each row, the link was taken, the current price was extracted, and placed in the corresponding column.
What was implemented:
The Make platform (ex-Integromat) was used to build the automation.
A scenario was set up that:
- goes through all the rows of the spreadsheet,
- retrieves the HTML page from the specified link,
- parses the price from it using regular expressions (Match Pattern),
- inputs the result into the required column of Google Sheets.
Additionally, price change monitoring was implemented:
- if the new price differs from the previous one, a notification with details (old price, new price, percentage change) is sent to a Telegram chat.
Special cases were handled (spaces, non-breaking spaces, fractional values with a dot/comma).
Result:
The client received a convenient monitoring system that operates without manual actions.
Prices in Google Sheets are always up to date.
All changes are monitored in Telegram, and the scenario automatically runs at the specified time.