{"product_id":"google-patents-weekly-watch-to-google-sheets-n8n-apify","title":"Google Patents Weekly Watch to Google Sheets (n8n + Apify)","description":"\u003ch3\u003eAutomatically track new Google Patents—and log them into Google Sheets every week\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs a \u003cstrong\u003eGoogle Patents Weekly Watch\u003c\/strong\u003e every Monday and appends \u003cstrong\u003eone row per patent\u003c\/strong\u003e to your chosen Google Sheets tab. You’ll capture publication details, assignees, dates, abstracts, and a direct patent link—no ongoing IP watch subscription needed.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly scheduled runs:\u003c\/strong\u003e Executes every Monday morning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your watch settings:\u003c\/strong\u003e Reads your patent watch list, optional \u003cem\u003eassignee\u003c\/em\u003e, target \u003cem\u003ecountry\u003c\/em\u003e, and a configurable \u003cem\u003elookback window\u003c\/em\u003e (lookbackDays).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearch per watch term:\u003c\/strong\u003e Splits the watch list so each term triggers its own Google Patents search.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries via Apify:\u003c\/strong\u003e Uses the Apify actor \u003cstrong\u003ejohnvc\/google-patents-api\u003c\/strong\u003e to fetch recent publications within the lookback window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips empty results:\u003c\/strong\u003e If a search returns no patents, it won’t write blank rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFlattens results into sheet-ready rows:\u003c\/strong\u003e Outputs one spreadsheet row per patent, including \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003eassignee\u003c\/strong\u003e, \u003cstrong\u003einventor\u003c\/strong\u003e, \u003cstrong\u003epublication and filing dates\u003c\/strong\u003e, \u003cstrong\u003eabstract\u003c\/strong\u003e, and a \u003cstrong\u003elink\u003c\/strong\u003e to the patent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends to Google Sheets:\u003c\/strong\u003e Adds the rows to your selected spreadsheet and sheet\/tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTrack competitor patent activity by assignee and keyword in a continuously growing Google Sheets database.\u003c\/li\u003e\n  \u003cli\u003eMonitor a specific technology area by maintaining a watch term list and reviewing weekly patent abstracts.\u003c\/li\u003e\n  \u003cli\u003eSupport SaaS product strategy or engineering planning with lightweight, automated patent intelligence.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n workflow\u003c\/strong\u003e using nodes such as \u003cem\u003eSet\u003c\/em\u003e, \u003cem\u003eCode\u003c\/em\u003e, \u003cem\u003eFilter\u003c\/em\u003e, and \u003cem\u003eSplit Out\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify integration\u003c\/strong\u003e with an Apify account and API token credential.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets integration\u003c\/strong\u003e to append rows to a chosen tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNo per-seat IP watch service\u003c\/strong\u003e; watch terms run via Apify (free tier available; watch terms cost about \u003cstrong\u003e4 cents per week\u003c\/strong\u003e per term).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45758757142707,"sku":"N8N-17779","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MESztZp08QcE1BA-w3DWy_ZHurFqpu.png?v=1785834695","url":"https:\/\/buyflowscripts.com\/products\/google-patents-weekly-watch-to-google-sheets-n8n-apify","provider":"N8N Commerce","version":"1.0","type":"link"}