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

Описание и применение

Автоматический сбор новых и изменённых тендеров ЕС с помощью бесплатного API TED и запись их в Google Sheet для ежедневного мониторинга.

Задача

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:

Источник