Turn a shopping search into a price sheet
Runs one product search each week and writes a row per result - price, seller, delivery, rating - to your sheet.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads the price tab first to see whether it already has a header row or is still empty.
If
sheetHeadersis empty- 2Google SheetsAppend rowWrites the header row into an empty tab, then appends one dated row per product with price, seller, delivery, rating and link.
- 2
- 3SerperSearch shoppingRuns one shopping search for your product in your country, returning each result's price, seller, delivery, rating and link.
For each
productIf
productTitleis not empty- 4Google SheetsAppend row
- 4
How it works
What happens on each run, in plain English.
Every week, one shopping search for the product you describe is run for the country you are shopping in, and the results are pulled apart into columns you can sort and chart: the product name, the price as the seller listed it, that price as a number, the seller, the delivery terms, the star rating, the review count and the link.
No AI reads the page and no page is fetched: the shopping search already returns these as separate fields, so every cell is a value the search itself supplied. A field the seller did not publish is left empty rather than guessed, and a result with no product name is skipped and reported. Rows are only ever appended and each run stamps its date in the 'Checked' column, so the weekly schedule builds a price history for the same search rather than replacing last week's figures.
Before the first run you need a Google Sheet with a tab for this search; an empty tab gets its own header row the first time. Use one copy per product you want to track.
You may also be interested in
Personalised marketing emails from customer dataReads each customer's purchases and feedback, lets AI decide who earns a coupon, and sends a tailored email from Gmail.Low stock and expiry alerts for your pharmacyChecks your pharmacy inventory sheet every morning and emails the medicines running low or near expiry, marking each in the sheet.Daily inventory monitor for low stock and expiryChecks your inventory sheet every morning and emails what is out of stock, running low, expired or expiring soon, marking each row.Thank happy customers and win back unhappy ones with a couponEmails each customer about their purchase in your tone, reads their feedback first, and adds a coupon when the feedback is negative.Start from a workflow that already works.
Add "Turn a shopping search into a price sheet" to your workspace, connect its apps, and make it yours.
Free plan, no credit card