Open The Sidebar
- Give permission for the sheet to open the Bulk Publishing tool (3rd party warning will appear)
- Google’s warning that the script is not an official Google Sheets Add-on. Do not be alarmed by this 😊. Hit advanced and accept. The script needs to be able to change your data, that’s all. Nobody else has access to your sheet once copied within your own Google account. Without accepting this, you cannot use the tool.
Add Your OpenAI API Key
- I recommend generating a fresh API and naming it accordingly. Providing you have spent at least $1 on the OpenAI API, you will be able to use the new GPT-4 model.
Add Your SerpStack API Key (Optional)
To use the SERP scraping functions you will need to get a SerpStack API Key. You can get a free account and free key with 1000 searches here:
Test out the feature and decide whether it is something you will find useful or not. SerpStack API paid plans start at $30 per month. If you use the BPAI WordPress plugin, you may not need this as there is a PAYG in-sheet scraping feature.
Adjusting Model Parameters
You can set your own parameters or use the default ones assigned to each function.
Creating Custom Prompts
You can create upto 30 of your own prompts and system messages (instructions telling the AI what it is) The formulas for these are not available in the sidebar but can be accessed via =Custom1, =Custom2, etc.
Generating Images
Options
Size:
1024×1024
1024×1792
1792×1024
Quality:
hd
standard
Style:
vivid
natural
Example
=GETIMAGE(A2, “1024×1792”, “hd”, “natural”)
Formulas (updated frequently)
When updated, these will be added to the front of the main sheet.
=GETOUTLINE
Generates a blog post outline.
=GETOUTLINE_MARKDOWN
Generates a blog post outline pre-formatted in markdown (##, ###)
=GETTITLE
Generates a title.
=GETTITLE2
Generates a title (slightly different prompt).
=GETKEYWORDS
Generates a comma-separated list of semantically related *AI-SEO driven keywords.
=GETINTRO
Generates a blog post introduction.
=GETINTRO2
Generates a blog post introduction with tips from Jamie IF’s SPEAR Framework.
=GETPARA
Generates a general paragraph for a given topic that reads as part of a larger body of text.
=GETPARA1ST
Generates a first person paragraph for a given topic that reads as part of a larger body of text.
=GETPOST
Generates a Markdown-formatted short blog post within the 1000 token limit.
=GETMETA
Generates a meta description.
=GETMETA2
Generates a meta description (slightly different prompt).
=GETINTERLINKS
Analyses the targeted keyword and sitemap and comes up with a list of upto 5 related urls to link to.
=GETTWEET
Generates a tweet for a given keyword, outline or topic.
=GETTHREAD
Generates a thread pre-formatted in parts for a given keyword, outline or topic.
=GETSUMMARY
Summarises a chunk of text.
=GETNEWSLETTER
Writes a first-person email that can be used as part of an email sequence.
=GETIMAGE
Generates an image using Dalle-3. Can be modified by adding size, style and quality modifiers
=GETPROMPT
Generates a descriptive image prompt which can be used with the GETIMAGE formula.
=IMAGE
Displays image from url.
=GETSERPS
Scrapes the SERPs using your SerpStack API Key
=GETSERPSUMMARY
Scrapes the SERPs using your SerpStack API Key & creates a summary using AI of the findings.
=GETGUESTPOSTEMAIL
Provide the required data, such as the sender’s name, sender’s site, proposal information, recipient’s name, and recipient’s site (=GETGUESTPOSTEMAIL(A2,B2,C2,D2,E2)).
It will generate a compelling guest post outreach email in a personalized and engaging tone.
=GETFOLLOWUP
Provide the sender’s name, recipient’s name, and the proposal information =GETFOLLOWUP(A2,D2,C2)).
It will generate a polite and friendly follow-up email asking if the recipient had a chance to review the proposal and expressing continued interest in collaboration.
=GETFOLLOWUP2
Generates a followup email to the 1st email body.
=GETSERPOUTLINE
If you have generated/added research data, it will generate an outline based on both the keyword and research data (example, if you have a keyword in A1 and research in B1, use =GETSERPOUTLINE(A1,B1)
=CREATESLUG
Creates the perfect slug from a keyword; no special characters.