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 68 comments Veo 3.1 vs Sora 2: AI Video Generation in 2025 🎬🤖 User Avatar 30 comments I built eSIMKitStore — helping travelers stay online with instant QR-based eSIMs 🌍 User Avatar 21 comments 🚀 Get Your Brand Featured on FaceSeek User Avatar 20 comments Day 6 - Slow days as a solo founder User Avatar 16 comments From side script → early users → real feedback (update on my SaaS journey) User Avatar 11 comments