Automate Substack Prospecting: n8n Workflow for Author Tracking

Revolutionize Substack Prospecting with Automated Author Tracking via n8n Workflow

Take 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.

What This Workflow Does

This workflow is manually triggered to initiate a precise series of automated tasks:

• Trigger and Search: Manually activate the workflow in n8n, setting a search term sent to a Crawlee HTTP endpoint for relevant Substack-style publication results.
• Process and Check: 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.
• Record and Link: For new authors, categorize their publication by subscriber count, format essential domain link data, and create corresponding Company and Person records within Twenty.
• Integration: Update the author (Person record) in Twenty to establish a link with their corresponding publication (Company record) for comprehensive data integration.

Use Cases

This workflow is ideal for:

• Sales Teams: Quickly identify and track upcoming authors and tailor your outreach strategies by collecting structured data within your Twenty CRM.
• Content Marketers: Maintain a dynamic database of Substack authors for potential collaborations or guest contributions.
• CRM Managers: Automate the entry and linking of new author data, improving data consistency and reducing manual tasks.

Technical Details

• Nodes Used: Manual Trigger, HTTP Request, Set, If, Split Out, Code nodes.
• Integrations: Crawlee HTTP service and Twenty CRM GraphQL API.
• Setup Requirements: Ensure accessibility and availability of the Twenty API endpoint (http://host.docker.internal:2000/graphql) and the Crawlee service endpoint (http://workflow_crawlee:3000/search).
• Customization: Adjust search terms and field mappings to match your CRM schema and prospecting criteria.