{"product_id":"uk-tender-alerts-in-google-sheets-slack-n8n-workflow","title":"UK Tender Alerts in Google Sheets + Slack (n8n Workflow)","description":"\u003ch3\u003eGet UK tender alerts automatically in Google Sheets and Slack\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow pulls fresh UK procurement notices from \u003cstrong\u003eContracts Finder\u003c\/strong\u003e on a schedule, filters for \u003cstrong\u003eactive non-award tenders\u003c\/strong\u003e, saves new items to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and posts a clean summary to your \u003cstrong\u003eSlack\u003c\/strong\u003e channel—so you never miss an opportunity.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduled run:\u003c\/strong\u003e Starts on a timed trigger inside n8n.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetch notices from Contracts Finder:\u003c\/strong\u003e Calls the \u003cem\u003eUK Contracts Finder\u003c\/em\u003e (contractsfinder.service.gov.uk) \u003cstrong\u003eOCDS Search\u003c\/strong\u003e endpoint to retrieve the latest notices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize and split results:\u003c\/strong\u003e Splits the response into individual tender items and standardizes key fields like \u003cstrong\u003etitle, buyer, value, deadline, location, and notice URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilter to active, non-award tenders:\u003c\/strong\u003e Keeps only items marked \u003cstrong\u003eactive\u003c\/strong\u003e and excludes those tagged as \u003cstrong\u003eawards\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDe-duplicate with Google Sheets:\u003c\/strong\u003e Checks Google Sheets for an existing row with the same \u003cstrong\u003etender ID\u003c\/strong\u003e, and only keeps items that don’t already exist.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSave and notify:\u003c\/strong\u003e Appends newly detected tenders to Google Sheets, aggregates them into a formatted list, and posts the summary to \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators and automation engineers who want \u003cstrong\u003eUK tender discovery\u003c\/strong\u003e without manual searching.\u003c\/li\u003e\n  \u003cli\u003eProcurement, bid, or BD teams tracking opportunities and needing a \u003cstrong\u003eSlack alert\u003c\/strong\u003e every time new tenders appear.\u003c\/li\u003e\n  \u003cli\u003eTeams maintaining a single source of truth in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e with reliable de-duplication by tender ID.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Service Account) and \u003cstrong\u003eSlack\u003c\/strong\u003e (OAuth)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used:\u003c\/strong\u003e \u003ccode\u003eif\u003c\/code\u003e, \u003ccode\u003eset\u003c\/code\u003e, \u003ccode\u003ecode\u003c\/code\u003e, \u003ccode\u003eslack\u003c\/code\u003e, \u003ccode\u003eaggregate\u003c\/code\u003e, \u003ccode\u003esticky note\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration steps:\u003c\/strong\u003e Set the spreadsheet ID and tab, ensure an \u003ccode\u003eid\u003c\/code\u003e column for de-duplication, share the sheet with the Google Service Account, choose the Slack channel, and adjust the schedule interval.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46047347835059,"sku":"N8N-19657","price":18.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ri2HLQQZtWv6WPKsKjdnt_KIYhPtKo.png?v=1789636363","url":"https:\/\/buyflowscripts.com\/products\/uk-tender-alerts-in-google-sheets-slack-n8n-workflow","provider":"N8N Commerce","version":"1.0","type":"link"}