Library / Documents, PDF & OCR
Documents, PDF & OCR
Score Japanese procurement notices with OpenAI GPT-5-mini and send bid checklists to
On a schedule, it reads and extracts data from documents with OpenAI / ChatGPT using Data Table.
What it does
## Find Japanese government procurement notices worth bidding on using your past bids, AI scoring, and AI bid checklists Japan's public procurement portal (官公需情報ポータルサイト) lists new bids every day. This workflow searches it for your keywords, checks each notice against your own past bids, lets AI rate and summarize it, and drafts a bid preparation checklist for the promising ones before posting a digest to Microsoft Teams. ### How it works 1. Every weekday morning it loads your past bids from the past_bids data table and searches the portal's public API (no key) for each keyword. 2. Results are split into notices; duplicates and notices sent in earlier runs are removed. 3. Match Past Bids (Code) finds earlier bids with the same buyer or topic and how many you won. 4. The first LLM chain rates relevance with that history and writes a short Japanese summary. Low-relevance notices stop here. 5. The second LLM chain drafts a checklist, questions for the buyer, and a bid, consider, or skip recommendation. 6. All promising notices are posted to Teams in one card. ### Setup steps 1. Create an n8n data table named past_bids with text columns: year, buyer, project, keywords, result (won or lost). 2. Run Load Sample Past Bids once, then replace the rows with your own history. 3. Edit Set Search Settings, including the Teams webhook URL. 4. Connect your OpenAI credential to both chat model nodes.
The steps
- Every Weekday Morning
- Set Search Settings
- Load Past Bids
- List Keywords
- Split Keywords
- Search Procurement Portal
- Parse Results XML
- Split Notices
- Remove Duplicate Matches
- Skip Notices Already Sent
- Read Notice Fields
- Match Past Bids
- Score and Summarize Notice
- OpenAI Chat Model
27 steps in total.
Similar automations
Forms & SurveysTranslate and review Japanese product listings with OpenAI GPT-5-mini8 stepsForms & SurveysCheck and fix Japanese PR TIMES press releases with rule tables and OpenAI14 stepsEmail AutomationAnswer Japanese contact forms with OpenAI, Microsoft Teams and Gmail27 stepsForms & SurveysDraft keigo-checked Japanese contact form replies with OpenAI and Teams22 steps