Small intro, I started learning coding couple of months before and since then experimenting with different small side projects.
So this I show coding still looks for me:)
Follow my journey on Twitter https://twitter.com/shnai0
What did I build this time?
I built the new side project Startup Funding startupfunding.to - generated lists of funds and investors for different countries, rounds, and industries. It can help founders obtain the list of investors faster.
Before I started learning how to code I was discovering SEO game and used no-code tools and website builders to multiply pages.
As I learnt how to build website it looked super interesting, if I can multiply pages faster by coding.
This project was a perfect fit for it as multiply pages can be simply based on different countries and funding rounds:
- startupfunding.to/india
- startupfunding.to/seed-uk
- startupfunding.to/pre-seed-sweden
- ...
How did I multiply 1 page in 700?
This is my step by step instruction:
1. Find right keywords in Semrush
2. Build the page with variables from the database
Here are 4 variables which change:
slug
country
header
meta
Meta is super important every page should have different meta for google to identify the difference.
return (
<>
<Head>
<title>Investors for startups</title>
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="description" content={page.meta} />
<meta property="og:site_name" content="startupinvestors.vercel.app" />
<meta property="og:description" content="Startup funding" />
<meta name="StartupFunding:card" content="summary_large_image" />
<meta property="og:image" content="/cover.png" />
</Head>
<div className="flex flex-col min-h-screen justify-between bg-slate-900">
<main className="h-full bg-slate-900">
<nav className="bg-black text-white ">
<div className="px-5">
<div className="max-w-5xl mx-auto">
<div className="flex justify-between items-center h-16 ">
<div className="flex items-centertext-base ">
<a
target="_blank"
href="/"
rel="noreferrer"
className="text-white flex max-w-fit items-center justify-center space-x-2 text-xl"
>
<p>Startup investors</p>
</a>
</div>
</div>
</div>
</div>
</nav>
<section className="py-10 lg:py-20 bg-slate-900">
{/* bg-[url('/image1.svg')] */}
<div className="px-4">
<div className="max-w-5xl mx-auto">
<div className="w-full mx-auto">
<h1 className="text-6xl text-center font-bold pb-1 text-white ">
{page.header}
</h1>
<p className="mt-3 mb-10 text-center text-white">
Raise capital with help of AI generated list of investors{" "}
<br />
</p>
<div className="max-w-5xl mx-auto px-8 lg:px-28">
<div className="max-w-5xl mx-auto">
<div className="w-full my-1 mx-auto "></div>
<div className="w-full my-1 mx-auto">
<div className="flex space-x-4">
{" "}
{/* Add this wrapper div with flex and space-x classes */}
<div className="w-full ">
{" "}
{/* Add w-1/2 class to the parent div */}
<CountrySelect
country={country}
setCountry={setCountry}
slug={page.country}
/>
</div>
3. Generate CSV file for 700 pages with ChatGPT
Next step is to fill in database. I used chatgpt for generating the content.
Further I moved the data to Excel so I have my CSV file ready
This actually took most of the time.
4. Connect TablePlus with my CSV and Postgres database
As I am using Postgres in Railway, I connected Table Plus with imported inside data for 730 pages.
5. Check that all pages are indexed in Google Search Console
If you are building new website it maybe will be a manual work to index pages in the beginning. And there is also limit for indexing request per day. (I am still on it)
If you know how to speed this up, appreciate the advice:)
Result: 730 pages in 1 hour
You can find this pages by changing slug practically on each country.
Check these different pages examples:
www.startupfunding.to/india
www.startupfunding.to/seed-india
www.startupfunding.to/pre-seed-india
Asking for a friend: help me reach 1000 ⭐️⭐️
I am on the new challenge to grow Papermark.io on GitHub to 1000 stars in 1 month.
papermark.io - open source alternative to Docsend
https://github.com/mfts/papermark
The project is close to my heart for 2 reasons:
- I started coding only because availability of Open Source projects, either I think I would never attempt it.
- I was raising capital before and always looking for cool alternative to Docsend for sending Pitchdeck.
Top comments (5)
For the love of $deity don't use gpt to generate content pages. There's too much of this online already. Try searching for a low sugar ice cream recipe as an example. Most of the top search results are ai generated. Which wouldn't be too bad except the actual recipe part is a fail with no measurements or worse bad measurements to go with nonsensical instructions.
Just don't do it.
Yeah can we stop calling it "SEO-optimized AI-generated content" and just call it what it really is, spam?
Thanks for sharing your work, Iuliia! 🎉
I wonder if I can use this for more complex pages, like e-commerce shop pages. I will try it out!
To the 700 pages and more:)
You could just do this with a couple of for() loops.