Get last week's orders as a CSV

import csv, io
from datetime import date, timedelta
from clickruntime import on_trigger, credentials, http, notify

STORE = "your-store.myshopify.com"

def gql(query, variables=None):
    resp = http.post(f"https://{STORE}/admin/api/2025-07/graphql.json",
                     headers={"X-Shopify-Access-Token": credentials.connection("shopify", "store")},
                     json={"query": query, "variables": variables or {}})
    resp.raise_for_status()
    return resp.json()["data"]

QUERY = """query($q: String!, $after: String) { orders(first: 100, query: $q, after: $after) {
  pageInfo { hasNextPage endCursor }
  nodes { name createdAt displayFinancialStatus displayFulfillmentStatus
          customer { displayName } totalPriceSet { shopMoney { amount currencyCode } } } } }"""

@on_trigger
def run(event):
    start = date.today() - timedelta(days=7)
    rows, after = [], None
    while True:
        page = gql(QUERY, {"q": f"created_at:>={start} created_at:<{date.today()}", "after": after})["orders"]
        rows += [[o["name"], o["createdAt"][:10], (o["customer"] or {}).get("displayName", ""),
                  o["totalPriceSet"]["shopMoney"]["amount"], o["displayFinancialStatus"], o["displayFulfillmentStatus"]]
                 for o in page["nodes"]]
        if not page["pageInfo"]["hasNextPage"]:
            break
        after = page["pageInfo"]["endCursor"]
    out = io.StringIO()
    csv.writer(out).writerows([["Order", "Date", "Customer", "Total", "Payment", "Fulfillment"]] + rows)
    notify.email_me(f"Shopify orders {start} to {date.today() - timedelta(days=1)}: {len(rows)}", out.getvalue())
    return {"orders": len(rows)}