FAQ
At this time OpenAI, Claude, Google (& on Pro OpenRouter and Straico). With OpenRouter you can connect all the above plus Meta's new Llama 3.1 and Perplexity. We provide training vids on how to add create accounts and add keys from different tools. Very very easy!
You might find similar functions in other popular Google Sheet apps. All of these are free as an added bonus. We coded all these functions out in a single day ๐ I can teach you how to do the same.
=AIWIZ(...arg) - AI Function: Combine multiple cells or direct text into one prompt for OpenAI. Ideal for generating AI-driven content or responses based on diverse inputs.
=visit("URL") - Visit: Fetches and displays the entire HTML content of a given URL. Useful for content analysis, web research, or data extraction tasks.
=serp("SEARCH QUERY") - SERP: Retrieves the top 20 DuckDuckGo search results for a query, providing URLs, titles, and descriptions. Great for SEO research or competitive analysis.
=getMetaTitle("URL") - Get Meta Title: Extracts the meta title of a specified webpage. Useful for SEO analysis and understanding how pages are titled for search engines.
=getMetaDescription("URL") - Get Meta Description: Pulls the meta description from a given URL, aiding in understanding webpage summaries as seen by search engines.
=getH1("URL") - Get H1: Returns the main H1 heading of a specified webpage, crucial for SEO and understanding the primary focus of the content.
=getH2("URL") - Get H2s: Gathers all H2 subheadings from a webpage, helpful in content structure analysis and identifying key subtopics.
=getHeadings("URL") - Get Headings: Collects all headings (H1, H2, etc.) from a page, offering a quick overview of the content structure and hierarchy.
=getp("URL") - Get Paragraphs: Extracts all text within paragraph tags from a webpage, useful for content analysis, text extraction, or readability assessments.
=visitAll("URL") - Visit All: Aggregates main content elements (H1, H2s, paragraphs, meta title, and description) from a URL and arranges them in sequential cells, starting from the function's location. Ideal for comprehensive webpage content analysis.
Yes, truly lifetime unlike a company on a server or app. We are using Google's own Google Sheets to create our code. This means that if something were to happen to Sheet Wiz as a business you will still keep your Google Sheets with the attached code.
Yes, truly unlimited. No user limits. No content limits. No website limits. No limits to creating sheets. This truly is scalable for any size company. This is a trust project. All I ask is that you honor this project by not sharing this outside of your company or team. I want to avoid creating an app and locking down the code. Right now you get truly unlimited use that you simply will not find with any tool out there.
Yes, there is a video training center with step-by-step videos. Most new users / customers can use the video training very successfully. I am happy to meet on zoom if you should want a helping hand.
No! You do not need to know code in order to use Sheet Wiz. This was built with beginners and professionals in mind that just want an easy to use and scalable tool. You don't need to know anything about code. Knowing a little HTML is probably a good idea for SEO.
Yes! The code is available in the Google Sheets. There is hundreds of lines of code for you to edit that is all organized. Best part is that ChatGPT or Claude can help you edit code if you are interested. Use the built in Chat to write code or use our VibeSheet to build projects. No tool is going to give you direct access to code like Sheet Wiz!