This workflow automates the research process for aviation parts sourcing. Instead of manually looking up each part number across multiple government databases, you just maintain a list of National Stock Numbers (NSNs) in a spreadsheet — the system does the rest.
It visits RFQ listing sites like DIBBS and WBParts, checks for active requests, extracts supplier contact information, and logs everything back into your spreadsheet with clear status tracking.
Designed for aviation parts procurement teams who need to process hundreds of RFQs without spending days on manual data entry.
The workflow reads a Google Sheet containing a list of National Stock Numbers marked for processing. You control which items to process by toggling a status column.
For each NSN, the system searches DIBBS (Defense Logistics Agency) and WBParts for active RFQs. It navigates the search results, extracts relevant listings, and collects the data.
When RFQs are found, the system drills into each listing to pull supplier details — company name, contact information, and bid deadlines. Everything is captured for follow-up.
All extracted data — NSN, RFQ number, supplier, contact, status — is written back to the Google Sheet. The workflow also updates the processing status so you know which items have been checked.
The system respects rate limits to avoid being blocked by government sites. If it stops midway, it picks up where it left off on the next run — no duplicated work.
Searches across DIBBS and WBParts simultaneously, cross-referencing results to find the most relevant RFQs for each part number.
Configurable delay between requests prevents IP blocks and ensures the automation can run continuously over large datasets without interruption.
Each NSN is tracked through the pipeline — listed, in progress, completed, or flagged. You can see exactly where things stand at a glance.
If the workflow stops (scheduled break, rate limit hit, or manual pause), it resumes from the last unprocessed item — no rework needed.