{"product_id":"automate-substack-prospecting-n8n-workflow-for-author-tracking","title":"Automate Substack Prospecting: n8n Workflow for Author Tracking","description":"\u003ch3\u003eRevolutionize Substack Prospecting with Automated Author Tracking via n8n Workflow\u003c\/h3\u003e\n\n\u003cp\u003eTake your Substack prospecting to the next level with our specialized n8n workflow designed for efficient author tracking and CRM integration. Seamlessly discover new authors and publications, connecting them directly to your Twenty CRM to streamline your outreach efforts.\u003c\/p\u003e\n\n\u003ch3\u003eWhat This Workflow Does\u003c\/h3\u003e\n\u003cp\u003eThis workflow is manually triggered to initiate a precise series of automated tasks:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger and Search:\u003c\/strong\u003e Manually activate the workflow in n8n, setting a search term sent to a Crawlee HTTP endpoint for relevant Substack-style publication results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcess and Check:\u003c\/strong\u003e Split the returned JSON results array to process each publication individually. Query the Twenty GraphQL API to verify the existence of the author's Substack ID as a Person record.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRecord and Link:\u003c\/strong\u003e For new authors, categorize their publication by subscriber count, format essential domain link data, and create corresponding Company and Person records within Twenty.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegration:\u003c\/strong\u003e Update the author (Person record) in Twenty to establish a link with their corresponding publication (Company record) for comprehensive data integration.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse Cases\u003c\/h3\u003e\n\u003cp\u003eThis workflow is ideal for:\u003c\/p\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSales Teams:\u003c\/strong\u003e Quickly identify and track upcoming authors and tailor your outreach strategies by collecting structured data within your Twenty CRM.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContent Marketers:\u003c\/strong\u003e Maintain a dynamic database of Substack authors for potential collaborations or guest contributions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCRM Managers:\u003c\/strong\u003e Automate the entry and linking of new author data, improving data consistency and reducing manual tasks.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical Details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes Used:\u003c\/strong\u003e Manual Trigger, HTTP Request, Set, If, Split Out, Code nodes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Crawlee HTTP service and Twenty CRM GraphQL API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup Requirements:\u003c\/strong\u003e Ensure accessibility and availability of the Twenty API endpoint (\u003ccode\u003ehttp:\/\/host.docker.internal:2000\/graphql\u003c\/code\u003e) and the Crawlee service endpoint (\u003ccode\u003ehttp:\/\/workflow_crawlee:3000\/search\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCustomization:\u003c\/strong\u003e Adjust search terms and field mappings to match your CRM schema and prospecting criteria.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45612515754163,"sku":"N8N-16677","price":4.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/7mszJtOcvyFFIyZegzKId_90c97dafe5534405b3e048080e7b3c3c.jpg?v=1782723810","url":"https:\/\/buyflowscripts.com\/products\/automate-substack-prospecting-n8n-workflow-for-author-tracking","provider":"N8N Commerce","version":"1.0","type":"link"}