1
1 Comment

Create Programmatic Blog using Google Sheet

I created a Programmatic Blog where the data is stored on Google Sheets using https://onsheets.io.

I basically used https://onsheets.io to create the APIs for the blog where in it would dynamically retrieve blog posts and data whenever I add a new row in my google sheets.

I connected the APIs from https://onsheets.io to a front-end NextJs App and dynamically rendered the blog posts. I used this method to programmatically add and update blog posts for my site.

The site just has 18 blog posts and you can already see the growth on the search console from the screenshot attached, by using the above method and the services of https://onsheets.io which are free to use, I was able to create a programmatic blog & SEO for my site for free.

posted to Icon for group SEO
SEO
on April 24, 2023
  1. 1

    It's a good idea! Did you get the results to work? I tried something similar a while back as a test for AI and it ranked very quickly but then go unindexed

Trending on Indie Hackers
I spent $0 on marketing and got 1,200 website visitors - Here's my exact playbook User Avatar 41 comments Why Early-Stage Founders Should Consider Skipping Prior Art Searches for Their Patent Applications User Avatar 22 comments I built eSIMKitStore — helping travelers stay online with instant QR-based eSIMs 🌍 User Avatar 20 comments Codenhack Beta — Full Access + Referral User Avatar 20 comments Veo 3.1 vs Sora 2: AI Video Generation in 2025 🎬🤖 User Avatar 18 comments Day 6 - Slow days as a solo founder User Avatar 13 comments