User
Write something
Live Webinar With Nico is happening in 13 days
Working on the Optimizing the OpenRouter SEO Writer sheet
Been editing the OpenRouter API SEO Sheet. Making progress. - Changed the API keys to be on a settings sheet - Added Additional LSI Keyword section - Got it to loop through keywords (I don't know why it refused to do it for me, probably becase I renamed the sheet and created an additional Settings sheet for Custom prompts and api key storage.) Still need to do: - Change image generator from Dall-E to Flux - Selection of special instructions for different brand voices and humanize the content (maybe need to add a model picker that is different from generating outline to generating the blog.) - formatting is a little wanky for me but that can be fixed through prompting. - add other generators like title options, descriptions, tags, etc since I use it for video not blogs - separate intro/hook section from the body and add CTAs (video specific and can be put into prompts) - Add length picker for article type, which will have to be tied to different models and prompts. Anyway, 6 out of the 8 artices generated in 2 minutes. and all 8 articles cost $0.195 which is crazy. (I had an Open AI API writer that would cost $0.50 per article. This is obviously a huge difference)
0
0
Working on the Optimizing the OpenRouter SEO Writer sheet
Create Your Own AI Blog Writer: Automate SEO Content with Google Sheets
In this detailed tutorial I walk your through my step-by-step process of how I a generated a custom ChatGPT Powered SEO Content Writer Automation Tool inside Google Sheets. You have all the assets below. The Premium version of this app that includes Perplexity research into the work flow, which will vastly improve the quality of the output is available in the Premium Community. The free version is below in the assets. ASSETS ✅ Google Sheet Template ✅ How to Get your OpenAI API Key ✅ Appscript File (Attached)
26
43
New comment 12d ago
Create Your Own AI Blog Writer: Automate SEO Content with Google Sheets
Pillar Pages
I just finished watching step 2 - AI-written blogs. How do you go about crafting the actual pillar page for your content automation strategy? Or did I miss a step? It seems to me you have only written the sub-pillar pages.
2
3
New comment Oct 8
Custom AI content copywriter FIX
I wanted to share an important update regarding the custom AI content copywriter we discussed in a previous video. There were some issues with the old version, but I’ve created a new, improved version that you can install to ensure it works flawlessly! Here’s What You Need to Know: ✅1. New Version Available: • The previous Apps Script had issues due to unauthorized changes. The new version is ready for you to install, and it won’t have those problems! ✅2. Installation Steps: • Make a Copy: Click the link below to copy the updated Google Sheets template. • Set Up the Script: • Go to Extensions > Apps Script. • Paste the code from the provided text file (download it from the link below). • Refresh your Google Sheet to activate the new features! ✅3. OpenAI API Key Required: Make sure you have your OpenAI API key handy to start using the tool effectively. ✅4. Content Generation: The updated script allows you to generate blog outlines and manage various content functionalities directly from Google Sheets, keeping everything organized in Google Drive. ✅5. Image Prompt Functionality: There might be some delays with the image prompt feature; if it doesn’t work right away, just try again a couple of times. ✅6. Support: If you have any questions, feel free to drop them in the comments or the premium group. I’m here to help 🚨Now’s the time to try the premium community! The price is going up at the end of the month, but if you join now, you’ll be grandfathered in at the current price. If you’ve ever wanted more support and can’t get your questions answered in this free group, the best way to receive assistance is by joining the premium community. You’ll gain access to the latest Apps Script, tutorials, and expert guidance to help you rank your website in no time!🚨 JOIN HERE GOOGLE SHEET TEMPLATE TO COPY
13
22
New comment Oct 8
Custom AI content copywriter FIX
🔥 Advanced SEO Tips: Pro Moves from High-End Experts
When it comes to SEO, the pros like Steve Toth don’t just settle for basic tactics. They go deep. If you’re aiming to play at their level, you’ve got to go beyond the basics and start working with the big leagues. Here’s how they roll: 1. Semantic SEO: It's All About Context It’s not just about sprinkling a few keywords here and there anymore. Semantic SEO is where it's at. You want search engines to understand the bigger picture of what you’re saying. Think of it like painting with a broader brush—include related terms and phrases to give more context to your content. It’s kind of like leaving breadcrumbs for Google to follow, showing it how everything connects. The result? Higher rankings because your content looks more comprehensive and relevant. 2. Internal Linking: Spread the Love (and the Link Juice) Here's a neat trick: strategic internal linking. It’s not just about randomly linking pages within your site; it’s about being intentional. Find those high-authority pages that are already doing well and link them to your less popular pages. This is like sending a virtual high-five that helps spread authority across your site. Think of it as redistributing the SEO wealth! 3. Optimizing for Search Intent: It’s Not Just About You Let’s face it—SEO isn’t about what you want to say. It’s about what your audience wants to know. If you’re not aligning your content with what people are actually searching for, you're missing the mark. Dig into that search intent, figure out what folks are really after, and tweak your content to match. It’s like being the perfect host who knows exactly what their guests want before they even ask. Trust me, they’ll stick around longer, and your rankings will soar. Best of Luck and happy Ranking 🙂
18
18
New comment Oct 4
1-9 of 9
AI Ranking (FREE)
skool.com/ai-ranking-free
Learn how to rank your website #1 with the latest AI tools and tested techniques.
Leaderboard (30-day)
powered by