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
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 emptyYes
Google SheetsAdd a row to sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.No
No steps
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…Yes
Stop repeating.Stop repeating.No
No steps
If a step below fails, save the error as productErrorIf a step below fails, save the error as productErrorTry
Trim product.title and save it as productTitle.Trim product.title and save it as productTitle.If productTitle is nullIf productTitle is nullYes
Change productTitle to blank.Change productTitle to blank.No
No steps
If productTitle is emptyIf productTitle is emptyYes
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..No
Trim product.price and save it as priceAsListed.Trim product.price and save it as priceAsListed.If priceAsListed is nullIf priceAsListed is nullYes
Change priceAsListed to blank.Change priceAsListed to blank.No
No steps
Trim product.source and save it as seller.Trim product.source and save it as seller.If seller is nullIf seller is nullYes
Change seller to blank.Change seller to blank.No
No steps
Trim product.delivery and save it as delivery.Trim product.delivery and save it as delivery.If delivery is nullIf delivery is nullYes
Change delivery to blank.Change delivery to blank.No
No steps
Trim product.rating and save it as rating.Trim product.rating and save it as rating.If rating is nullIf rating is nullYes
Change rating to blank.Change rating to blank.No
No steps
Trim product.rating_count and save it as reviews.Trim product.rating_count and save it as reviews.If reviews is nullIf reviews is nullYes
Change reviews to blank.Change reviews to blank.No
No steps
Trim product.link and save it as link.Trim product.link and save it as link.If link is nullIf link is nullYes
Change link to blank.Change link to blank.No
No steps
Set priceValue to blank.Set priceValue to blank.If priceAsListed isn't emptyIf priceAsListed isn't emptyYes
Extract the first number from priceAsListed and save it as priceValue.Extract the first number from priceAsListed and save it as priceValue.No
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.On error
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 0Yes
Show 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.No
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.