⭠ all tutorials

Automatically post content to Hacker News

Available for Unlimited All Access members only

Get access

**Please read Hacker News rules before using a system like this. It's more for showing what is possible and help you with the submitting process, this does not submit automatically.

The full tutorial is available for pro members only

Request access

Set up a Google sheet with columns: Title, URL, Link param, HN with link param, Title param, URL Title, Submit URL.

Add your example title and URL. In the Link param add: https://news.ycombinator.com/submitlink?u= the ?u= is for populating a link in the submission.

HN with link param: add the formula =CONCAT(C2,B2) to connect the URL and the link param.

Title param: add the formula =CONCAT(D2,"&t=") to connect the HN link you just made with "&t=" to pull in the title data for submission

URL Title: add the formula =SUBSTITUTE(A2," ","%20") to replace any spaces from your title with %20 to populate the correct title text in the submission

Submit URL: add the formula =CONCAT(E2,F2) to pull it all together as your one-click to populate the submission

Log in to Zapier and create a Zap. The Trigger will be Google Sheets when a new spreadsheet row is added. Connect your account and customise the data. Now add an action step SMS by Zapier to send an SMS and pull in the Submit URL.

You can also add (or replace the SMS) sending an email with a one-click URL for populating the submission or even add a Slack message to post it.

The only thing you will need to add here is when your content is posted on Webflow, Twitter, wherever - create a zap to populate the title and URL in Google Sheets so that will close the loop and make it fully automated.

**Please read Hacker News rules before using a system like this. It's more for showing what is possible and help you with the submitting process, this does not submit automatically.

Set up a Google sheet with columns: Title, URL, Link param, HN with link param, Title param, URL Title, Submit URL.

Add your example title and URL. In the Link param add: https://news.ycombinator.com/submitlink?u= the ?u= is for populating a link in the submission.

HN with link param: add the formula =CONCAT(C2,B2) to connect the URL and the link param.

Title param: add the formula =CONCAT(D2,"&t=") to connect the HN link you just made with "&t=" to pull in the title data for submission

URL Title: add the formula =SUBSTITUTE(A2," ","%20") to replace any spaces from your title with %20 to populate the correct title text in the submission

Submit URL: add the formula =CONCAT(E2,F2) to pull it all together as your one-click to populate the submission

Log in to Zapier and create a Zap. The Trigger will be Google Sheets when a new spreadsheet row is added. Connect your account and customise the data. Now add an action step SMS by Zapier to send an SMS and pull in the Submit URL.

You can also add (or replace the SMS) sending an email with a one-click URL for populating the submission or even add a Slack message to post it.

The only thing you will need to add here is when your content is posted on Webflow, Twitter, wherever - create a zap to populate the title and URL in Google Sheets so that will close the loop and make it fully automated.

**Please read Hacker News rules before using a system like this. It's more for showing what is possible and help you with the submitting process, this does not submit automatically.

Set up a Google sheet with columns: Title, URL, Link param, HN with link param, Title param, URL Title, Submit URL.

Add your example title and URL. In the Link param add: https://news.ycombinator.com/submitlink?u= the ?u= is for populating a link in the submission.

HN with link param: add the formula =CONCAT(C2,B2) to connect the URL and the link param.

Title param: add the formula =CONCAT(D2,"&t=") to connect the HN link you just made with "&t=" to pull in the title data for submission

URL Title: add the formula =SUBSTITUTE(A2," ","%20") to replace any spaces from your title with %20 to populate the correct title text in the submission

Submit URL: add the formula =CONCAT(E2,F2) to pull it all together as your one-click to populate the submission

Log in to Zapier and create a Zap. The Trigger will be Google Sheets when a new spreadsheet row is added. Connect your account and customise the data. Now add an action step SMS by Zapier to send an SMS and pull in the Submit URL.

You can also add (or replace the SMS) sending an email with a one-click URL for populating the submission or even add a Slack message to post it.

The only thing you will need to add here is when your content is posted on Webflow, Twitter, wherever - create a zap to populate the title and URL in Google Sheets so that will close the loop and make it fully automated.

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

Set up a Google sheet with columns: Title, URL, Link param, HN with link param, Title param, URL Title, Submit URL.

Add your example title and URL. In the Link param add: https://news.ycombinator.com/submitlink?u= the ?u= is for populating a link in the submission.

HN with link param: add the formula =CONCAT(C2,B2) to connect the URL and the link param.

Title param: add the formula =CONCAT(D2,"&t=") to connect the HN link you just made with "&t=" to pull in the title data for submission

URL Title: add the formula =SUBSTITUTE(A2," ","%20") to replace any spaces from your title with %20 to populate the correct title text in the submission

Submit URL: add the formula =CONCAT(E2,F2) to pull it all together as your one-click to populate the submission

Log in to Zapier and create a Zap. The Trigger will be Google Sheets when a new spreadsheet row is added. Connect your account and customise the data. Now add an action step SMS by Zapier to send an SMS and pull in the Submit URL.

You can also add (or replace the SMS) sending an email with a one-click URL for populating the submission or even add a Slack message to post it.

The only thing you will need to add here is when your content is posted on Webflow, Twitter, wherever - create a zap to populate the title and URL in Google Sheets so that will close the loop and make it fully automated.

Tools used

Get help and discuss

Open community forum

Related lessons

Build Lemonade in Niro
Container Building Block
Button Building Block
Getting Started with Niro
Selling digital products with Gumroad with Notion & Super
Integrating MemberSpace with Super & Circle for SSO, gated content, and paid communities
Integrating Circle with Super & Notion
Setting up Super with Notion
Collecting recurring payments with involve.me
Collecting one time and recurring payments with involve.me
Calculating custom prices with involve.me
Making a calculator with involve.me
What is involve.me?
Marketing automation with Palabra, Bubble and Segment
How to setup a members-only Circle community (without a website) in Memberspace
How to integrate Circle (community forum) with Memberspace
Create Interactive Content with Outgrow
Target specific pages with a chatbox using Olark
Send emails from Airtable
Monitor content distribution on Twitter
Create a Welcome Bot in Slack
Dynamically Create Webinar Pages in Webflow
Create a social content scheduling workflow
Automating Newsletter Content in Mailchimp
Find and upload Instagram videos from by hashtag
Typeform - the basics
Rank blog posts in Webflow by pageviews
Logic-based lead forms in Typeform
Dynamically generate Google Docs
Dynamically generate Google Slides
Weekly email digest of interesting links with Zapier
Automate + qualify your lead generation with Standard Library
Sentiment analysis of Instagram comments with Parabola
Subscription powered community like Patreon with Adalo
Referral marketing program
Send SMS Surveys with Twilio + Airtable on Standard Library
📖 Visit your favourite blogs & save posts for later with Shortcuts
Monitor and save posts from Reddit
Simple multiple-step form with Boundless
Build a Mail Merge with Airtable, Gmail, and Standard Library.
How Superhuman Built an Engine to Find Product/Market Fit
How to create a SaaS website, CMS landing page & blog
How to automatically feed data to google sheets
Export data from MySQL into a CSV in Google Sheets
Automatically get data from Mailchimp to your CRM
Creating an event check-in app
Enroll new users when they purchase
Browse all →

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.