Runs one product search each week and writes a row per result - price, seller, delivery, rating - to your sheet.
Uses
Google Sheets
Serper
Turn a shopping search into a price sheet
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.
Run every 7 days.Run every 7 days.
Set searchQuery to blank.Set searchQuery to blank.Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.Set sheetName to blank.Set sheetName to blank.Set countryCode to blank.Set countryCode to blank.Set maxProducts to 20.Set maxProducts to 20.Google SheetsRead the rows of spreadsheetUrl. Save it as sheet.Read the rows of spreadsheetUrl. Save it as sheet.Set sheetHeaders to sheet.headers.Set sheetHeaders to sheet.headers.
If sheetHeaders is emptyIf sheetHeaders is emptyGoogle SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.SerperSearch Google Shopping for searchQuery. Save it as search.Search Google Shopping for searchQuery. Save it as search.Set products to search.products.Set products to search.products.Set addedCount to 0.Set addedCount to 0.Set noPriceCount to 0.Set noPriceCount to 0.
For each product in products:For each product in products:If addedCount multiplied by 1 is greater than or equal to maxProducts multiplied…If addedCount multiplied by 1 is greater than or equal to maxProducts multiplied…Stop repeating.Stop repeating.
If a step below fails, save the error as productErrorIf a step below fails, save the error as productError
Trim product.title and save it as productTitle.Trim product.title and save it as productTitle.If productTitle is nullIf productTitle is null
Change productTitle to blank.Change productTitle to blank.If productTitle is emptyIf productTitle is empty
Show in the output: Skipped a shopping result that came back without a product name..Show in the output: Skipped a shopping result that came back without a product name..Trim product.price and save it as priceAsListed.Trim product.price and save it as priceAsListed.If priceAsListed is nullIf priceAsListed is nullChange priceAsListed to blank.Change priceAsListed to blank.Trim product.source and save it as seller.Trim product.source and save it as seller.If seller is nullIf seller is nullChange seller to blank.Change seller to blank.Trim product.delivery and save it as delivery.Trim product.delivery and save it as delivery.If delivery is nullIf delivery is nullChange delivery to blank.Change delivery to blank.Trim product.rating and save it as rating.Trim product.rating and save it as rating.If rating is nullIf rating is nullChange rating to blank.Change rating to blank.Trim product.rating_count and save it as reviews.Trim product.rating_count and save it as reviews.If reviews is nullIf reviews is nullChange reviews to blank.Change reviews to blank.Trim product.link and save it as link.Trim product.link and save it as link.If link is nullIf link is nullChange link to blank.Change link to blank.Set priceValue to blank.Set priceValue to blank.If priceAsListed isn't emptyIf priceAsListed isn't emptyExtract the first number from priceAsListed and save it as priceValue.Extract the first number from priceAsListed and save it as priceValue.Add 1 to noPriceCount.Add 1 to noPriceCount.Google SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.Add 1 to addedCount.Add 1 to addedCount.Show in the output: Skipped a shopping result that could not be read: productError as text.Show in the output: Skipped a shopping result that could not be read: productError as text.If addedCount multiplied by 1 is 0If addedCount multiplied by 1 is 0Show in the output: The search for '@searchQuery' returned nothing that could be written, so no rows were added.Show in the output: The search for '@searchQuery' returned nothing that could be written, so no rows were added.Show in the output: Wrote addedCount as text products to the '@sheetName' tab. noPriceCount as text of them were listed without a price, so their price columns are empty.Show in the output: Wrote addedCount as text products to the '@sheetName' tab. noPriceCount as text of them were listed without a price, so their price columns are empty.