SERP APIによる価格監視: 国別のオファー、販売者、価格

import csv
import datetime
import os

import requests

API = "https://serpcrypto.com/api/v1/search"
HEADERS = {"Authorization": "Bearer " + os.environ["SERPCRYPTO_API_KEY"]}
OUR_STORE = "Example Store"
PRODUCTS = {"garmin forerunner 265": 349.99, "jabra elite 10": 199.00}

today = datetime.date.today().isoformat()
with open("prices.csv", "a", newline="", encoding="utf-8") as fh:
    writer = csv.writer(fh)
    for query, our_price in PRODUCTS.items():
        params = {"engine": "google_shopping", "q": query, "gl": "us", "hl": "en"}
        resp = requests.get(API, headers=HEADERS, params=params, timeout=60)
        resp.raise_for_status()
        for offer in resp.json().get("shopping_results", []):
            price = offer.get("extracted_price")
            seller = offer.get("source", "")
            writer.writerow([today, "us", query, seller, price, offer.get("currency", ""), offer.get("position")])
            if price and seller != OUR_STORE and price < our_price:
                print("ALERT:", seller, "sells", query, "at", price, "below", our_price)