Sign up for updates

Get a weekly update every Sunday with our announcements, company updates and a behind-the-scenes of what our community are building.
Over 11,000 people get our updates, join us!
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.
â­  all tutorials

Automatically post content to Hacker News

This tutorial is available for pro members only

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

Lesson details

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

Previous submissions
No items found.
Supporting details

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.

More lessons

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

Ready to get started?

Join the community and start turning your ideas into solutions