HomeDocumentation

Function Reference

Complete documentation for all 25+ Unlimited Sheets functions with examples and expected outputs.

⚡AI Functions📊SERP Functions🌐Scraping Functions🔍SEO Functions🛠️Utility Functions

Quick Start

1

Install Add-on

Get Unlimited Sheets from the Google Workspace Marketplace

2

Connect Account

Enter your API key via Extensions → Unlimited Sheets → Connect

3

Add AI Key

For AI functions, add your OpenAI key in Settings

⚡

AI Functions

SUPERPOWER

AI built into Google Sheets. Transform, analyze, and generate anything.

🚀 Your AI Toolkit. Do ANYTHING with this function
UNLIMITED_AI(prompt, [model], [maxTokens])

THE most powerful function in Unlimited Sheets. Ask anything, transform any data, generate any content. Powered by GPT-4 and Claude. With your own API key, usage is UNLIMITED.

fx
=UNLIMITED_AI("Summarize in 3 bullet points: " & A1)
Input
A
1
Climate report: Global temps rose 1.2°C, renewables hit $500B investment...
Output in Sheets
A
1
• Global temperatures rose 1.2°C above pre-industrial levels • Renewable energy investments hit record $500B • 50+ countries committed to net-zero by 2050
AI_EXTRACT(text, schema)

Extract structured data from any text. Just describe what you want - names, emails, prices, dates, anything.

fx
=AI_EXTRACT(A1, "company, revenue, year")
Input
A
1
Apple reported $394B revenue in 2023. Microsoft earned $211B. Google had $307B.
Output in Sheets
A
B
C
1
Company
Revenue
Year
2
Apple
$394B
2023
3
Microsoft
$211B
2023
4
Google
$307B
2023
AI_TABLE(prompt, [rows], [cols])

Generate entire tables of data from a description. Perfect for creating datasets, comparisons, and structured content.

fx
=AI_TABLE("Top 5 programming languages with pros and cons", 5, 3)
Input
Direct values in formula
Output in Sheets
A
B
C
1
Language
Pros
Cons
2
Python
Easy to learn, versatile
Slower execution
3
JavaScript
Web native, huge ecosystem
Type coercion issues
4
TypeScript
Type safety, better tooling
Learning curve
5
Go
Fast, simple concurrency
Less libraries
+1 more
AI_FILL(examples, newInput)

Learn from examples and apply the same transformation. Show it 2-3 examples, and it figures out the pattern.

fx
=AI_FILL(A1:B2, A3)
Input
A
B
1
john.doe@gmail.com
John Doe
2
sarah.smith@yahoo.com
Sarah Smith
3
mike.jones@outlook.com
Output in Sheets
A
1
Mike Jones
AI_CLASSIFY(text, categories)

Automatically categorize text into your defined categories. Perfect for sorting feedback, tickets, or leads.

fx
=AI_CLASSIFY(A1, "Bug, Feature Request, Question, Complaint")
Input
A
1
Can you add dark mode to the app? It would be great for nighttime use.
Output in Sheets
A
1
Feature Request
AI_KEYWORDS(seedKeyword, [count])

Generate related keyword ideas from a seed keyword. Returns keywords with type and difficulty estimates.

fx
=AI_KEYWORDS("running shoes", 5)
Input
Direct values in formula
Output in Sheets
A
B
C
1
Keyword
Type
Difficulty
2
best running shoes 2024
long_tail
medium
3
running shoes for flat feet
long_tail
low
4
nike running shoes
branded
high
5
running shoes for beginners
long_tail
low
AI_SCRAPE(url, description)

Extract data from any webpage using AI. Just describe what you want to extract and AI figures out the rest.

fx
=AI_SCRAPE(A1, "product names and prices")
Input
A
1
https://store.example.com/shoes
Output in Sheets
A
B
1
Product
Price
2
Nike Air Max
$129.99
3
Adidas Ultra
$149.99
4
New Balance 990
$119.99
AI_SEO_ANALYZE(content, targetKeyword, [url])

Analyze content for SEO optimization. Returns score, keyword density, and improvement suggestions.

fx
=AI_SEO_ANALYZE(A1, "seo tools")
Input
A
1
Best SEO Tools for 2024: A comprehensive guide to improving your search rankings...
Output in Sheets
A
B
1
Metric
Value
2
Score
72/100
3
Keyword Density
1.8%
4
Suggestion
Add more H2 headings

💡 What can you do with UNLIMITED_AI()?

✍️

Content Generation

  • "Write a product description for: "...
  • "Create a catchy headline for: " & ...
  • "Write 3 tweet variations: " & A1
🔄

Data Transformation

  • "Convert to JSON: " & A1
  • "Translate to Spanish: " & A1
  • "Summarize in 1 sentence: " & A1
📊

Data Extraction

  • "Extract all emails from: " & A1
  • "Extract names and phones: " & A1
  • "List all prices mentioned: " & A1
🧠

Analysis & Insights

  • "Sentiment analysis: " & A1
  • "Rate this review 1-5: " & A1
  • "Find issues in this code: " & A1
🚀

SEO & Marketing

  • "Generate meta description: " & A1
  • "Create 5 ad headlines for: " & A1
  • "Suggest related keywords: " & A1
✨

Formatting & Cleanup

  • "Fix grammar and spelling: " & A1
  • "Format as bullet points: " & A1
  • "Convert to title case: " & A1

Pro tip: The UNLIMITED_AI() function can do almost anything. Describe what you want in plain English. Combine it with cell references like UNLIMITED_AI("Translate to French: " & A1) to process your data.

📊

SERP Functions

PRO

Search engine ranking data and keyword metrics powered by DataForSEO

GET_KEYWORD_POSITION(keyword, domain, [country], [device])

Find your ranking position for any keyword. Returns position 1-100 or "Not found".

fx
=GET_KEYWORD_POSITION(A1, B1)
Input
A
B
1
seo tools
ahrefs.com
Output in Sheets
A
1
3
GET_ORGANIC_PAGES_FROM_SERP(keyword, [limit], [country])

Get organic search results for a keyword. Returns URLs, titles, and positions.

fx
=GET_ORGANIC_PAGES_FROM_SERP(A1, 5)
Input
A
1
best seo tools
Output in Sheets
A
B
C
1
Position
URL
Title
2
1
https://ahrefs.com
Best SEO Tools 2024
3
2
https://moz.com
Top SEO Software
4
3
https://semrush.com
SEO Toolkit
GET_PAID_PAGES_FROM_SERP(keyword, [limit], [country])

Get paid/sponsored search results for a keyword.

fx
=GET_PAID_PAGES_FROM_SERP(A1, 3)
Input
A
1
crm software
Output in Sheets
A
B
1
URL
Title
2
https://salesforce.com
Salesforce - #1 CRM
3
https://hubspot.com
Free CRM Software
GET_ALL_PAGES_FROM_SERP(keyword, [limit], [country])

Get all search results including organic, paid, and featured snippets.

fx
=GET_ALL_PAGES_FROM_SERP(A1, 5)
Input
A
1
project management
Output in Sheets
A
B
C
D
1
Type
Position
URL
Title
2
paid
-
https://monday.com
monday.com
3
organic
1
https://asana.com
Asana
4
organic
2
https://trello.com
Trello
GET_SEARCH_VOLUME_FROM_GOOGLE(keywords, [country])

Get monthly search volume for keywords. Accepts single keyword or range.

fx
=GET_SEARCH_VOLUME_FROM_GOOGLE(A1:A3)
Input
A
1
running shoes
2
best running shoes
3
nike running shoes
Output in Sheets
A
B
1
Keyword
Volume
2
running shoes
110,000
3
best running shoes
49,500
4
nike running shoes
33,100
🌐

Scraping Functions

PRO

Extract data from any website using CSS selectors, XPath, or regex patterns

SCRAPE_BY_CSS_PATH(url, cssSelector, [attribute])

Scrape content using CSS selectors. Optionally extract specific attributes.

fx
=SCRAPE_BY_CSS_PATH(A1, "h1.title")
Input
A
1
https://blog.example.com/article
Output in Sheets
A
1
How to Master SEO in 2024
SCRAPE_BY_XPATH(url, xpathExpression)

Scrape content using XPath expressions for complex DOM traversal.

fx
=SCRAPE_BY_XPATH(A1, "//span[@class='price']")
Input
A
1
https://shop.example.com/product
Output in Sheets
A
1
$49.99
SCRAPE_BY_REGEX(url, regexPattern)

Extract content matching a regex pattern from the page HTML.

fx
=SCRAPE_BY_REGEX(A1, "\\$[0-9]+\\.?[0-9]*")
Input
A
1
https://shop.example.com/prices
Output in Sheets
A
1
Price
2
$29.99
3
$49.99
4
$99.99
CHECK_REDIRECT_CHAIN(url)

Follow all redirects and return the complete redirect chain with status codes.

fx
=CHECK_REDIRECT_CHAIN(A1)
Input
A
1
https://old.example.com/page
Output in Sheets
A
B
1
Status
URL
2
301
https://old.example.com/page
3
301
https://www.example.com/page
4
200
https://example.com/page
INDEX_NOW(url, [searchEngine])

Submit URLs to search engines for immediate indexing via IndexNow protocol.

fx
=INDEX_NOW(A1)
Input
A
1
https://example.com/new-blog-post
Output in Sheets
A
1
Submitted to Bing, Yandex
🔍

SEO Functions

FREE

Essential SEO utilities for technical audits and content optimization

GET_STATUS_CODE(url)

Get the HTTP status code for any URL. Useful for finding broken links.

fx
=GET_STATUS_CODE(A1)
Input
A
1
https://example.com/about
Output in Sheets
A
1
200
GET_URLS_FROM_SITEMAP(sitemapUrl, [limit])

Extract all URLs from an XML sitemap. Handles nested sitemaps automatically.

fx
=GET_URLS_FROM_SITEMAP(A1, 5)
Input
A
1
https://example.com/sitemap.xml
Output in Sheets
A
1
URL
2
https://example.com/
3
https://example.com/about
4
https://example.com/blog
5
https://example.com/contact
SUGGEST_QUERIES(query, [country])

Get Google autocomplete suggestions for a query. Great for keyword research.

fx
=SUGGEST_QUERIES(A1)
Input
A
1
how to learn
Output in Sheets
A
1
Suggestion
2
how to learn python
3
how to learn guitar
4
how to learn excel
5
how to learn spanish
SLUGIFY(text)

Convert text to a URL-friendly slug. Removes special characters and spaces.

fx
=SLUGIFY(A1)
Input
A
1
Hello World! This is a Test
Output in Sheets
A
1
hello-world-this-is-a-test
GET_LOCALE_BY_SUBDOMAIN(url)

Extract the locale/language code from a subdomain URL.

fx
=GET_LOCALE_BY_SUBDOMAIN(A1)
Input
A
1
https://es.example.com/productos
Output in Sheets
A
1
es
🛠️

Utility Functions

FREE

Powerful spreadsheet utilities that extend Google Sheets capabilities

UNLIMITED_VLOOKUP(value, range, returnCol, [value2], [col2], ...)

VLOOKUP with unlimited criteria. Match on multiple columns simultaneously.

fx
=UNLIMITED_VLOOKUP("John", A:D, 4, "Sales", 2)
Input
A
B
C
D
1
Name
Department
Role
Salary
2
John
Sales
Manager
$75,000
3
Sarah
Marketing
Director
$85,000
Output in Sheets
A
1
$75,000
V2_LOOKUP(value1, value2, range, returnCol)

VLOOKUP with exactly two criteria. Simpler syntax for common use case.

fx
=V2_LOOKUP("2024", "Q1", A:C, 3)
Input
A
B
C
1
Year
Quarter
Revenue
2
2024
Q1
$125,000
3
2024
Q2
$142,000
Output in Sheets
A
1
$125,000
COMBINE_ALL(range1, [range2], ...)

Combine multiple ranges into a single column. Removes empty cells.

fx
=COMBINE_ALL(A1:A3, C1:C2)
Input
A
B
C
1
apple
date
2
banana
elderberry
3
cherry
Output in Sheets
A
1
Combined
2
apple
3
banana
4
cherry
5
date
+1 more
GROUP_BY_CELL(range, [separator])

Combine all cell values into a single string with a separator.

fx
=GROUP_BY_CELL(A1:A4, ", ")
Input
A
1
apple
2
banana
3
cherry
4
date
Output in Sheets
A
1
apple, banana, cherry, date
CLUSTERIZE(keywords)

Cluster keywords by their root stems. Groups similar keywords together.

fx
=CLUSTERIZE(A1:A5)
Input
A
1
running shoes
2
running gear
3
marathon training
4
running tips
5
marathon shoes
Output in Sheets
A
B
1
Cluster
Keywords
2
running
running shoes, running gear, running tips
3
marathon
marathon training, marathon shoes
MY_REPLACE(text, search, replacement)

Replace all occurrences of a string. Works with special characters.

fx
=MY_REPLACE(A1, "World", "Sheets")
Input
A
1
Hello World, World is great
Output in Sheets
A
1
Hello Sheets, Sheets is great
EXISTS_IN_COLUMN(value, range)

Check if a value exists anywhere in a range. Returns TRUE or FALSE.

fx
=EXISTS_IN_COLUMN("banana", A1:A4)
Input
A
1
apple
2
banana
3
cherry
4
date
Output in Sheets
A
1
TRUE
RETURN_LAST_CELL(range)

Return the last non-empty cell value from a range.

fx
=RETURN_LAST_CELL(A1:A5)
Input
A
1
January
2
February
3
March
4
5
Output in Sheets
A
1
March
SPLIT_IN_COLUMNS(text, [separator])

Split text into horizontal columns using a separator.

fx
=SPLIT_IN_COLUMNS(A1, ",")
Input
A
1
red,green,blue
Output in Sheets
A
B
C
1
red
green
blue
GET_AVG_DAILY_TRAFFIC_FROM_WEEK(weeklyValue)

Calculate daily average from weekly data.

fx
=GET_AVG_DAILY_TRAFFIC_FROM_WEEK(A1)
Input
A
1
7000
Output in Sheets
A
1
1000
GET_RUN_RATE_CURRENT_MONTH(valueToDate, [dayOfMonth])

Project month-end total based on current run rate.

fx
=GET_RUN_RATE_CURRENT_MONTH(A1, 15)
Input
A
1
5000
Output in Sheets
A
1
10,333
GET_RUN_RATE_NEXT_MONTH(currentValue, [growthRate])

Project next month value with optional growth rate.

fx
=GET_RUN_RATE_NEXT_MONTH(A1, 0.1)
Input
A
1
10000
Output in Sheets
A
1
11,000
SELECT_RANDOM_CELL(range)

Return a random cell value from a range.

fx
=SELECT_RANDOM_CELL(A1:A4)
Input
A
1
Winner A
2
Winner B
3
Winner C
4
Winner D
Output in Sheets
A
1
Winner C
RETURN_CELL_INVERSED(range, inverseIndex)

Return cell from end of range using inverse index (1 = last, 2 = second to last).

fx
=RETURN_CELL_INVERSED(A1:A4, 2)
Input
A
1
First
2
Second
3
Third
4
Fourth
Output in Sheets
A
1
Third

Bring Your Own Key (BYOK)

All AI functions support your own OpenAI or Anthropic API keys. Pay the providers directly at their rates, no markup from us.Add your key in Extensions → Unlimited Sheets → Settings.

Need Help?

Can't find what you're looking for? Our support team is ready to help.

Contact SupportGo to Dashboard