Blog

How To Get Started with Numerous or Numerous.ai with Google Sheets

Numerous.ai Right Sidebar - The top of it

Table of Contents

Getting Started with Numerous.ai on Google Sheets

Introduction to what Numerous.ai does:

Very high level description of this Numerous.ai tool is that it allows you to access Chatgpt GenAI responses through both Google Sheets and Excel.  We will focus on Google Sheets in this article because that is what we use the most.

Numerous.AI stands at the forefront of this revolution, offering a seamless, powerful, and cost-effective solution for embedding the capabilities of ChatGPT directly into Google Sheets. With no need for API keys and a user-friendly =AI(“prompt_goes_here”) function, Numerous.AI is democratizing access to AI for a wide range of users, from content creators to digital marketers, students, researchers, product engineers, and managers.

Key Features of Numerous.AI

  • No API Keys Required: Begin with ease, bypassing the complexity of API keys.
  • Simple Usage: Implement AI functionality in any cell using the =AI function.
  • Robust Support: Choose between email options or priority support for any assistance.
  • Collaboration-Friendly: Designed for teamwork, allowing seamless collaboration on AI initiatives.
  • US-Based Support: Benefit from the expertise of a San Francisco-based team.
  • Speed and Efficiency: Enjoy fast performance, thanks to partnerships with top-tier AI providers.
  • Cost-Efficiency: Save costs by avoiding duplicate queries, making it the most economical AI integration.
  • Teamwide Access: A single plan accommodates the entire team, fostering collective usage and exploration.

Getting Started with Numerous.AI in Google Sheets

Step 1: Installing the Add-on

  1. Open Google Sheets and navigate to the Add-ons menu.
  2. Search for “Numerous.AI” in the G Suite Marketplace.
  3. Click “Install” and follow the prompts to integrate Numerous.AI with your Google Sheets.’

Here is what the sidebar looks like after you have installed it.  To view this though you must go to:

This is your right hand sidebar that you see:

Numerous.ai Right Sidebar - The top of it
Numerous.ai Right Sidebar – The top of it

 

 

 

 

 

 

 

 

That is the top of it.  The rest of it looks like this:

Numerous.ai Right Sidebar - The bottom of it
Numerous.ai Right Sidebar – The bottom of it

 

 

 

 

 

 

 

 

 

 

Step 2: Utilizing the MAIN =AI() Function

  • Simply type =AI("your prompt here") in any cell to execute an AI-driven task, from generating content ideas to summarizing data or cleaning up messy inputs.

Step 3: Exploring AI Capabilities

  • Digital Marketing: Automate the creation of AdWords keywords, Facebook campaign structures, and SEO content.
  • Content Generation: From ideation to creation, generate topics and content for blogs, social media, and more.
  • Data Organization: Summarize, categorize, classify, and cleanse vast datasets, making information management effortless.
  • Prototyping and Collaboration: Test AI prototypes and share findings with your team directly within Google Sheets.

*These are just high level examples.  For the most part it can do anything you would use basic chatgpt for.

Applications of Numerous.AI

For Content Creators

Generate diverse content ideas, plan social media schedules, and create content variants tailored to different audiences, all from a unified platform.

For Digital Marketers

Streamline the creation of digital marketing materials, including Facebook ads, AdWords copy, and SEO keywords, enhancing efficiency and productivity.

For Students and Researchers

Clean, summarize, and categorize research data effortlessly, making academic and scientific exploration more accessible.

For Product Engineers and Managers

Experiment with various AI prompts, prototype new AI features, and foster collaborative innovation within your team.

Numerous.ai Issues and Problems We (I) have had:

  1.  It is not good at dealing with coding prompts as of the beginning of 2024.  Quite often it wastes credits and does not provide any code or if it does provide code it is 95% of the time not good.  I’m better off directly interfacing with chatgpt.
  2.  Initially like many crappy Google Sheets Apps/etc. it would refresh the damn formulas all the time.  Its not completely fixed but you can keep running a button here that will make the output static so you don’t make the Google Sheet(s) unusable or just WASTE all your credits like it did on me.  They have it documented here “Google Sheets sometimes annoyingly refreshes formulas. This button replaces Al,INFER, and WRITE formulas with their results.”
    So that can manually be fixed by using this button:

    Numerous.ai Save Functions Button
    Numerous.ai Save Functions Button – Prevents Google Sheets from Re-running Formula
  3.  I find it hard to use many of the functions besides AI() and AIWRITE() personally.  See what you think.

 

Numerous.ai Conclusion

Numerous.AI’s integration with Google Sheets represents a significant leap forward in making AI accessible and practical for a wide range of applications. By following the simple steps outlined in this guide, users can unlock the full potential of AI to enhance their work, improve productivity, and foster collaboration. Whether you’re a content creator, digital marketer, student, researcher, or product engineer, Numerous.AI offers the tools and support to elevate your projects to the next level.

Also, even though I seriously hate stupid appsumo.com … I believe they still have the same lifetime deal with Numerous.ai similar to what I bought.  This is what I currently have paid for per month for a lifetime supposedly:

You purchased a lifetime license from AppSumo to use Numerous. Your token balance will reset to 15,000 tokens on the 10th of every month.
To upgrade or downgrade your subscription through AppSumo, you can do so here.
Your plan:

  • 15,000 tokens per month
  • 7,500,000 characters of ChatGPT input and output
  • 7,500 formula generations

Finally, if you are a video or youtube person then I think Riley is the founder and here is his video of how to use it.  Its over 1 year old but its still mostly the same:  https://www.youtube.com/watch?v=NFV-WMTO3QQ

My summary of it:  Numerous.ai Tutorial for Google Sheets

Summary

🎬 Riley demonstrates how to automate spreadsheet tasks using the Numerous add-on in Google Sheets.

Facts

  • Riley explains how to install Numerous from the Google Store by accessing it through the extensions button in the menu.
  • Numerous functions like =AI allow users to prompt AI responses directly within cells.
  • Pre-built tools in the sidebar, such as “extract” and “get basic information,” assist in automating tasks like extracting food items and finding cuisine information.
  • The “sentiment analysis” tool helps determine the positivity or negativity of reviews, aiding in understanding customer sentiment.
  • Users can generate spreadsheet formulas using the “generate formula” tool by describing their requirements in words.
  • Riley demonstrates how to calculate the average sentiment using basic spreadsheet functions like =average.