automated-blog-system.md

@"/Users/thunderbolt/Downloads/automated-blog-system.md" Create 3 blog templates that are seo optimised for the site Have an internal linking of the blogs, Have a CTA to book a call with Shilika

Convert this site into a next js application with a backend and database connection supabase postgres is the backend

update the vercel build accordingly

supabase : https://yzgaxyxoosazxfnsyqta.supabase.co pub key: sb_publishable_-Kv3Pdefiz7CxwBKM1wZJw_WG3Tiav0 secret: sb_secret_T0NLNJUwjyPhKPpxwKylfg_rDrW6RDp

also create a excel file uploader that updates or inserts blogs, doesn't touch blogs with ids not present in the excel make a password protected url page for the excel file uploader and downloader excel downloader downloads all blogs in excel format

Use supabase storage to manage the media of the blogs

and also implement this blogging system attached as automated-blog-system.md

use gemini nano banana 2 / pro for image generation

Give me suggestions on how the cron jobs would get triggered

I have lots of case studies and human input to add. create a place to add more inputs that act as a knowledge base for the agents to pick up

for creating topic ideas create an agent that finds what are the long tail phrases that ChatGPT, Google AI overview, perplexity, etc use while searching the web.

Maybe you can do competitor analyses, or use google search console or use an AI phrase searcher..

Some long tail queries are

Web3 journalist relationship management

crypto news embargo coordination services

enterprise blockchain media coverage campaigns

rug pull allegation reputation management

community trust rebuilding after Web3 crisis

how to coordinate embargoed press releases for blockchain funding rounds