Bulk Publishing Framework + AI-Integrated Google Sheet By Arielle Phoenix For Immediate Digital Download!
I have something amazing to share… (well, two amazing things to share).
If you follow me on Twitter, then you have probably seen snippets of me banging on about Google Sheets, concatenate, publishing batches of content, and Programmatic SEO.
Some tweets may have left you confused or merely curious, so I have decided to create something we can all enjoy…
I have created a spreadsheet tool that uses the GPT language model and this tool has helped me take publishing to the next level!
The two things I have to share have helped me take my newest site to 40k pageviews in 11 months:
1. My Bulk Publishing Framework
2. My AI-Integrated Google Sheet ( aka spreadsheet on steroids!)
What is Bulk Publishing??
Bulk Publishing is a happy medium between programmatic SEO and informational content.
It makes the most of those keyword variations, such as, can cats eat cheese, can cats eat rice, can cats eat roast beef, etc., and turns them into a system.
This is the same system I’ve been using to publish 20-30 quality articles a day!
The only limit is your imagination (and keyword research!)
And, as much as I love “concatenate,” I haven’t had to use it nearly as much, I just generate whatever I need for that variation of the keyword!
AI-Integrated Google Sheet: What Does It Do?
The spreadsheet has 4 in-built GPT functions and up to 10 custom prompts.
=GETANSWER : Answer PAA or FAQs for rows of questions.
=GETTITLE : Generate an engaging headline for multiple rows of keywords at once.
=GETPARA : Generate a paragraph for any query, keyword or heading
=GETSUMMARY : Summarise complex research or a chunk of text into a set of unique bullet points at an 8th Grade Level
Your custom prompts can be anything and they can be set and changed at any time in the front end of your sheet. Some of my favorites are “rewrite this in a more human-sounding tone,” and, “put this in a html list”.
“All the AI features you love, all within Google Sheets!”
Why Topical Dominance Is Going To Be The Only Thing That Matters In 2023…
In-Sheet Image Generation ✅
Value added: Generating AI images at 0.02c per image allows you to create unique images for all of your posts AT SCALE!
You can use these images as is, or connect to Placid and create featured images for your posts!
Multilingual Generations ✅
While this is experimental, it works! You can generate text in multiple languages by customizing your custom prompts.
What You Get
I have packaged this together with my Bulk Publishing Framework as they go hand in hand for the smart, creative niche site owner who is ready to take growth-hacking seriously 😏
In this mini-course, I also show you exactly how I use this killer combo and provide you with some examples of how to find the types of keywords that work best with this approach and how to break them down so you are turning them into quality outlines and posts.
I also go over how to publish them all at once using WP All Import (free) and what to do about internal linking and featured images 😉
Without giving too much of the game away, if I’ve hooked ya I’ve hooked ya… the rest is behind the sweet Gumroad Pay Wall!
🚨 READ THIS BEFORE YOU PURCHASE 🚨
You will need:
- WP All Import (the free version is fine) is the tool I use to publish all of the articles at once.
- An Open.AI API Key (You can find your API key at https://beta.openai.com), Open AI gives you $18 worth of free credits which goes a long way for testing, but if you hope to publish hundreds of articles keep this in mind and set your usage cap if need be.
*** Creature Comforts:
These are optional, but help make the workload even smoother!
- Placid – For bulk custom featured image generation.
- A data scraping tool – If you know how to do this yourself, great! This is not a necessity but it depends on the type of articles you are creating.
I have used Hexomatic and Outscraper. Both are pretty good, Hexomatic has more features but Outscraper is basic and to the point and has all of the Google scraping and Amazon scraping covered.
Getting organic search traffic is as easy as it will ever be (it isn’t going to get easier, only harder); don’t get left behind in 2023!
There is still so much more to come…