Daily EU public tender alerts in Google Sheets with the free TED API

说明与用途

使用免费的TED API自动收集欧盟新旧招标，并每天将其追加到Google表格中进行监控。

问题

Need to automatically collect new or changed EU public tenders matching specific CPV codes and countries and store them in a Google Sheet for daily monitoring.

结果

The job runs daily, automatically adding new or updated EU tender notices to a shared Google Sheet, enabling timely alerts.

工作流

• Query TED search API with CPV and country filters via POST https://api.ted.europa.eu/v3/notices/search
• Parse JSON response, handling pagination with iterationNextToken
• Hash selected fields (notice-title, deadline, buyer-name) to detect changes
• Compare hashes against stored publication-number → hash mapping to identify new or changed notices
• Update local seen.json with latest hashes
• Append new/changed rows to Google Sheet using gspread service account

证据

The EU publishes every above-threshold public tender on TED (Tenders Electronic Daily), and it offers a free search API that needs no API key.

来源

The endpoint is POST https://api.ted.europa.eu/v3/notices/search (docs: https://docs.ted.europa.eu/api/latest/search.html).

来源

With gspread and a service account that has edit access to the sheet:

来源