Welcome to your Bulk AI Video Script Generator! This tool will help you quickly generate video scripts optimized for various social media platforms like TikTok, YouTube, LinkedIn, Instagram Reels, and more, all from within Google Sheets. Below is a step-by-step guide to get you started.

1. Make a Copy of the Sheet

First and foremost, make a copy of the sheet. Do not request edit access to the template sheet.

2. Grant Script to Sheet Acess

After you make a copy of the sheet, a pop-up message will appear, asking for authorization to allow the script to function within your Google Sheet. This authorization is necessary for the script to run and perform the actions required to generate content in your sheet.

Important Note: Granting this permission does not give the script creator or anyone else access to your sheet, personal files, or any data beyond what’s in this specific sheet. The authorization simply enables the script to edit the sheet by generating content based on the features you’re using.

---

3. Setting Up Your API Keys

To start generating scripts, you’ll need to enter both the OpenAI API key and, optionally, the Perplexity API key in the designated cells of the Settings sheet in your Google Spreadsheet:

• OpenAI API Key: Enter this key in cell A2. This key is essential as it enables the core script generation functionality within the sheet.
  
• Perplexity API Key (Optional): Enter this key in cell A7. This key is optional and is only necessary if you want to include research-based content generated by Perplexity in addition to the OpenAI content.

For more information on obtaining your API keys and how to use them, read this simple step-by-step guide.

Adjusting Values on the Settings Sheet

You can adjust the values on the Settings sheet to customize script behavior, including the model, temperature, token limits, and other parameters. Each of these values directly impacts how the scripts are generated, allowing you to fine-tune output quality, length, and tone to meet your needs.

Important Notes on the Settings Layout
The cells in the Settings sheet are mapped to specific functions in the script. Do not move, rearrange, or delete any cells outside of these designated fields—each cell must stay in its original position to maintain functionality. Adjust only the values within the specified cells (like A2 for OpenAI, A7 for Perplexity) and any other parameters that are meant for customization.

---

4. Understanding the Core Functionality

• This tool is designed to provide video scripts tailored for specific social media platforms. Each platform function (e.g., TikTokScript, YTShort, LinkedInScript) generates a unique style of script appropriate to the platform’s audience, format, and engagement style.
  
• You can use each function in any cell, simply by calling it as a formula with the relevant inputs.

Using a Function

• To generate a script, type the function in a cell as a formula.
  
  Here’s a simple example:

=TikTokScript("sustainable fashion tips")

• When you press Enter, the tool will process your input and generate a TikTok-optimized script on the theme “sustainable fashion tips” right in your cell.

Use Multiple Cells to Create a Super Prompt

Every function supports multiple inputs via the ...input parameter, allowing it to handle multiple cell values if passed in. This feature lets you expand your prompt by selecting multiple cells as inputs.

Here’s how:

Suppose you have content spread across cells, like A1 (topic), B1 (tone), and C1 (research data).

You can combine these cells into a single, more detailed prompt:

=TikTokScript(A1, B1, C1)

• In this example, each cell’s content will be included as an argument in the input array. Each input is concatenated with a space (" ") when generating the prompt, so multiple cell values will merge into a cohesive “super prompt.”
  
• This approach allows you to work with data across different cells, even from multiple rows if needed, giving you flexibility to structure your prompts in any way that suits your content creation needs.

Use multiple cells for a super prompt to add depth and specifics, such as the audience, tone, research and purpose.

---

5. Customizing Prompts

• The generator also includes custom functions labeled Custom1 through Custom20. These let you create scripts for unique, specialized needs outside the pre-set platform scripts and call them quickly.

• Just type your desired prompt in one or more cells and call the custom function as needed:

=Custom1(A1, "holiday marketing ideas", C1)

• Customize each custom prompt’s content in the Settings sheet under cells G8 to G27 for Custom1 to Custom20.

---

7. Viewing Sources (For Research Functions)

The tool offers two powerful research functions powered by the Perplexity API: ResearchTerm and ResearchWithSources.

• ResearchTerm generates concise, informative content on a given topic, providing key insights and summarizing essential points.
• ResearchWithSources goes a step further by not only generating research but also including credible sources as clickable URLs when available. This allows you to easily access verified information and enrich your content with authoritative references.

Both functions make it simple to incorporate high-quality research into your content directly within Google Sheets.

Use ResearchTerm for quick summaries or ResearchWithSources for additional citations to support your content with evidence.

How to Use ResearchTerm

• Basic Usage: To research a topic, type =ResearchTerm("your keyword or topic") or =ResearchTerm(A2) in any cell.

For instance:

=ResearchTerm("sustainable fashion") 

This will produce a summary of the topic, including an overview of key points.

• Viewing Sources: When the Perplexity API finds relevant citations, it will display them as clickable links within the cell output. This allows you to verify the information or gather additional insights directly from the original sources.

Benefits of Including Sources

Why incorporate sources?

1. Enhanced Credibility: Your content gains authority with verifiable information, making it more trustworthy.
2. Depth of Knowledge: Sources provide context, allowing you to dive deeper into the subject if needed.
3. Content Enrichment: Source-backed research gives you additional talking points or evidence, especially useful for creating educational or informative content.

The ResearchTerm function thus serves as a valuable tool for quickly gathering well-researched, source-backed content, ready to be used or further refined for scripts, social media posts, or other formats.

---

8. Scaling Your Content with Click-and-Drag Formulas

Once your initial setup is complete, you can easily scale your content creation by using the click-and-drag feature in Google Sheets. This enables you to duplicate your formulas across cells, allowing you to quickly generate multiple video scripts, titles, descriptions, hashtags, research summaries, and more—all at once.

How to Use Click-and-Drag for Bulk Content Generation

• Duplicate Formulas: Start by entering a formula, such as =TikTokScript("your keyword") or =ResearchWithSources("your topic"), in a cell.
  
  Once the initial formula is set up, hover over the bottom-right corner of the cell until you see the “+” symbol, then click and drag down or across to copy the formula to multiple cells.
  
  This lets you generate multiple pieces of content with just one setup.
  
• Using Cell References for Keywords and Topics: For even faster scaling, organize your keywords or topics in a dedicated column (e.g., cells A2:A45). Instead of manually typing each keyword, reference the cells in your formula, such as =TikTokScript(A2).
  
  Once entered, you can click and drag the formula down to automatically apply =TikTokScript(A3), =TikTokScript(A4), and so on.
  
  This approach allows you to generate scripts for each keyword in your list, building a comprehensive content plan in seconds.
  
• Generate in Batches: With this click-and-drag method, you can quickly create batches of scripts, titles, descriptions, or research summaries based on different keywords or ideas. This ensures your content is tailored for various platforms and topics.
  
• Scale All Content Types: This method works with any of the tool’s functions, allowing you to efficiently scale video titles, hashtags, research summaries, or platform-specific scripts—all by clicking and dragging the formula across your sheet.

---

Consider API Rate Limits

When generating large amounts of content in bulk, keep in mind that API requests are subject to rate limits. Both OpenAI and Perplexity APIs limit the number of requests per minute, which can affect how quickly you’re able to generate content. To avoid hitting these limits, consider creating content in smaller batches rather than clicking and dragging formulas across hundreds of cells at once. This approach allows you to maintain efficiency while staying within the API rate limits, ensuring a smooth content creation process.

---

9. Scaling Your Content with Click-and-Drag Formulas

Once your initial setup is complete, you can easily scale your content creation by using the click-and-drag feature in Google Sheets. This enables you to duplicate your formulas across cells, allowing you to quickly generate multiple video scripts, titles, descriptions, hashtags, research summaries, and more—all at once.

How to Use Click-and-Drag for Bulk Content Generation

• Duplicate Formulas: Start by entering a formula, such as =TikTokScript("your keyword") or =ResearchWithSources("your topic"), in a cell.
  
  Once the initial formula is set up, hover over the bottom-right corner of the cell until you see the “+” symbol, then click and drag down or across to copy the formula to multiple cells.
  
  This lets you generate multiple pieces of content with just one setup.
  
• Using Cell References for Keywords and Topics: For even faster scaling, organize your keywords or topics in a dedicated column (e.g., cells A2:A45).
  
  Instead of manually typing each keyword, reference the cells in your formula, such as =TikTokScript(A2).
  
  Once entered, you can click and drag the formula down to automatically apply =TikTokScript(A3), =TikTokScript(A4), and so on.
  
  This approach allows you to generate scripts for each keyword in your list, building a comprehensive content plan in seconds.
  
• Generate in Batches: With this click-and-drag method, you can quickly create batches of scripts, titles, descriptions, or research summaries based on different keywords or ideas. This ensures your content is tailored for various platforms and topics.
  
• Scale All Content Types: This method works with any of the tool’s functions, allowing you to efficiently scale video titles, hashtags, research summaries, or platform-specific scripts—all by clicking and dragging the formula across your sheet.

Consider API Rate Limits

When generating large amounts of content in bulk, keep in mind that API requests are subject to rate limits. Both OpenAI and Perplexity APIs limit the number of requests per minute, which can affect how quickly you’re able to generate content.

If you’re unfamiliar with API rate limits, learn more about them here to understand how they can impact content generation. To avoid hitting these limits, consider creating content in smaller batches rather than clicking and dragging formulas across hundreds of cells at once.

This approach allows you to maintain efficiency while staying within the API rate limits, ensuring a smooth content creation process.

10. Saving Your Scripts

Once you’ve generated a script, you can easily convert it to plain text to prevent the formula from recalculating each time you edit the sheet.

Using the Save Script Values Button:

Go to the AI Tools menu and select Save Script Values.

This button converts the results of only the script-generating functions (TikTokScript, YTShort, LinkedInScript, etc.), including all custom functions (Custom1 through Custom20), into plain text. All other formulas (such as CONCATENATE) will remain untouched.

Converting your scripts to static values prevents accidental re-generation and ensures your content remains fixed while making other edits.

Tips for Best Results

Here are a few ways you can enhance your Google Sheet setup to improve your workflow, track performance, and get the most out of your content:

• Refine Your Prompts: Experiment with different keywords and phrases in your prompts to fine-tune the style, tone, and level of detail. Small adjustments in wording can make a significant impact on the relevance and effectiveness of the generated scripts.
  
• Maximize Multiple Inputs: Leverage multiple cells to create richer prompts by combining research, keywords, or other insights. This will allow you to generate scripts that are more targeted and tailored to specific audience interests.
  
• Optimize for Each Platform: Each function in the sheet is designed for specific social media platforms, like TikTok or LinkedIn. Always use the corresponding function to produce content that best aligns with the format, audience, and style of each platform.
  
• Add a Posting Schedule Section: Include a column or section for scheduling posts by adding dates or deadlines for each piece of content. This will help you stay organized and consistent in your posting frequency, especially when scaling your output.
  
• Track Performance Metrics: Add columns to record views, likes, shares, and other engagement metrics for each post. By tracking this data, you can identify which types of content perform best, helping you to double down on effective strategies and refine your approach.
  
• Include Notes for Improvements: Keep a notes section for each piece of content to log improvements, learnings, or audience reactions. This will provide valuable insights when revisiting content ideas or planning new posts.

Happy scripting! This guide should get you up and running with your Bulk Video Script Generator in no time.