n8n

How to Automate Slack LinkedIn Advice Responses?

Get steady LinkedIn engagement without the daily grind. The flow finds new LinkedIn advice articles each week, drafts helpful replies with AI, posts them to Slack, and saves everything in a database for reuse. It suits marketing teams and solo builders who want regular activity with less manual work.

Every Monday at 8am or on demand, a Google search collects fresh results. Code extracts only LinkedIn advice links, then a merge step removes duplicates by checking what is already stored in NocoDB. Each link is fetched, the HTML node pulls the title and topics, and OpenAI writes short, original contributions. The output goes to a chosen Slack channel and into NocoDB as new rows.

Set your search topic, connect OpenAI, Slack, and NocoDB, and choose the channel and table. Expect research time to drop from hours to minutes and build a growing library of ready ideas. This is useful for social teams, agencies, and founders who want a repeatable weekly routine for LinkedIn advice posts.

What are the key features?

  • Weekly schedule runs every Monday at 8am plus a manual test trigger
  • HTTP Request pulls Google search results for LinkedIn advice pages
  • Code node extracts valid LinkedIn advice URLs with a regex
  • Split Out processes each link one by one for clean handling
  • Merge step removes duplicates by comparing against NocoDB records
  • HTML extract grabs the article title, topics, and other user contributions
  • OpenAI generates short, original advice for each topic using a set temperature
  • Slack node posts the article title, link, and AI advice to a channel
  • NocoDB stores each result with title, URL, and generated content for tracking

What are the benefits?

  • Reduce manual research from 2 hours to 10 minutes each week
  • Automate 80 percent of drafting by using AI to write contributions
  • Prevent repeat topics by checking stored links before writing
  • Connect Slack and NocoDB to keep ideas and posts in one place
  • Handle up to 25 search results per run with batching

How do you set it up?

  1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
  2. You'll need accounts with OpenAI, Slack, NocoDB, Airtable and Google Sheets. See the Tools Required section above for links to create accounts with these services.
  3. In n8n, open the Set Topic node and enter your topic term that should appear in the Google search, for example marketing automation or sales enablement.
  4. Open the HTTP Request node named Get advice articles from a Google search and confirm the URL includes your topic variable. Keep batching at 25 unless you need more links.
  5. Double click the OpenAI node and in the credential dropdown click Create new credential, then paste your OpenAI API key from your OpenAI account API page. Name the credential clearly, for example OpenAI Main.
  6. Open the Slack node and create a new Slack OAuth2 credential. Follow the on screen steps, approve channel posting access, and select the target Slack channel.
  7. Open both NocoDB nodes. Create a new NocoDB API Token credential using an API token from your NocoDB project. Map the correct project and table for reading existing rows and creating new rows.
  8. If you plan to log data in Airtable or Google Sheets, open those nodes and create new OAuth credentials. Select the base or spreadsheet and map the fields you want to store.
  9. Check the HTML extract node to ensure the selectors return a title and topics. Run once with the manual trigger to confirm the output shows ArticleTitle and topic items.
  10. Run the manual trigger. Verify Slack receives a message with the article title, link, and advice. Then confirm NocoDB has a new row with the same data.
  11. If you get no links, adjust your search topic or try a narrower query. If Slack fails, check the channel permission and the selected workspace. If OpenAI errors, verify your API key and account billing.
  12. Enable the workflow and confirm the schedule is set to Monday at 08:00 so the weekly run is automatic.

Tools Required

$24 / mo or $20 / mo billed annually to use n8n in the cloud. However, the local or self-hosted n8n Community Edition is free.

Airtable

Sign up

Free (1,000 API calls / mo)

Google Sheets

Sign up

Free: $0 (Google Sheets API usage has no additional cost; quota limits apply)

NocoDB

Sign up

Free tier: $0 / mo, 1,000 API calls / mo

OpenAI

Sign up

Pay-as-you-go: GPT-5 at $1.25 per 1M input tokens and $10 per 1M output tokens

Slack

Sign up

Free plan: $0 / mo; limited to 10 apps (third-party or custom) and usable via Slack API

Credits:
Built by Optimus Agency. Community link: Let's Automate It Community. Agency site: Optimus Agency.

Similar Templates

Join Futurise to access 1,200+ automation templates

Get instant access to ready-made automation workflows for n8n, Make.com, AI agents, and more. Download, customise, and deploy in minutes.