StartseiteDokumentation

Funktionsreferenz

Vollständige Dokumentation für alle 25+ Unlimited Sheets-Funktionen mit Beispielen und erwarteten Ausgaben.

⚡AI-Funktionen📊SERP-Funktionen🌐Scraping-Funktionen🔍SEO-Funktionen🛠️Utility-Funktionen

Schnellstart

1

Add-on Installieren

Holen Sie sich Unlimited Sheets aus dem Google Workspace Marketplace

2

Konto Verbinden

Geben Sie Ihren API-Schlüssel über Erweiterungen → Unlimited Sheets → Verbinden ein

3

AI-Schlüssel Hinzufügen

Für AI-Funktionen fügen Sie Ihren OpenAI-Schlüssel in den Einstellungen hinzu

⚡

AI-Funktionen

SUPERKRAFT

Ihre AI-Superkraft in Google Sheets. Transformieren, analysieren und generieren Sie alles.

🚀 Ihre AI-Superkraft — Tun Sie ALLES mit dieser Funktion
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)
Eingabe
A
1
Climate report: Global temps rose 1.2°C, renewables hit $500B investment...
Ausgabe 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")
Eingabe
A
1
Apple reported $394B revenue in 2023. Microsoft earned $211B. Google had $307B.
Ausgabe 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)
Eingabe
Direct values in formula
Ausgabe 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)
Eingabe
A
B
1
john.doe@gmail.com
John Doe
2
sarah.smith@yahoo.com
Sarah Smith
3
mike.jones@outlook.com
Ausgabe 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")
Eingabe
A
1
Can you add dark mode to the app? It would be great for nighttime use.
Ausgabe 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)
Eingabe
Direct values in formula
Ausgabe 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")
Eingabe
A
1
https://store.example.com/shoes
Ausgabe 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")
Eingabe
A
1
Best SEO Tools for 2024: A comprehensive guide to improving your search rankings...
Ausgabe in Sheets
A
B
1
Metric
Value
2
Score
72/100
3
Keyword Density
1.8%
4
Suggestion
Add more H2 headings

💡 Was können Sie mit UNLIMITED_AI() tun?

✍️

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: Die UNLIMITED_AI()-Funktion kann fast alles — beschreiben Sie einfach, was Sie möchten, in einfachem Deutsch. Kombinieren Sie sie mit Zellbezügen wie UNLIMITED_AI("Translate to French: " & A1) um Ihre Daten zu verarbeiten.

📊

SERP-Funktionen

PRO

Suchmaschinen-Ranking-Daten und Keyword-Metriken 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)
Eingabe
A
B
1
seo tools
ahrefs.com
Ausgabe 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)
Eingabe
A
1
best seo tools
Ausgabe 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)
Eingabe
A
1
crm software
Ausgabe 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)
Eingabe
A
1
project management
Ausgabe 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)
Eingabe
A
1
running shoes
2
best running shoes
3
nike running shoes
Ausgabe 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-Funktionen

PRO

Extrahieren Sie Daten von jeder Website mit CSS-Selektoren, XPath oder Regex-Mustern

SCRAPE_BY_CSS_PATH(url, cssSelector, [attribute])

Scrape content using CSS selectors. Optionally extract specific attributes.

fx
=SCRAPE_BY_CSS_PATH(A1, "h1.title")
Eingabe
A
1
https://blog.example.com/article
Ausgabe 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']")
Eingabe
A
1
https://shop.example.com/product
Ausgabe 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]*")
Eingabe
A
1
https://shop.example.com/prices
Ausgabe 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)
Eingabe
A
1
https://old.example.com/page
Ausgabe 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)
Eingabe
A
1
https://example.com/new-blog-post
Ausgabe in Sheets
A
1
Submitted to Bing, Yandex
🔍

SEO-Funktionen

KOSTENLOS

Wesentliche SEO-Utilities für technische Audits und Content-Optimierung

GET_STATUS_CODE(url)

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

fx
=GET_STATUS_CODE(A1)
Eingabe
A
1
https://example.com/about
Ausgabe 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)
Eingabe
A
1
https://example.com/sitemap.xml
Ausgabe 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)
Eingabe
A
1
how to learn
Ausgabe 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)
Eingabe
A
1
Hello World! This is a Test
Ausgabe 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)
Eingabe
A
1
https://es.example.com/productos
Ausgabe in Sheets
A
1
es
🛠️

Utility-Funktionen

KOSTENLOS

Leistungsstarke Spreadsheet-Utilities, die Google Sheets-Funktionen erweitern

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)
Eingabe
A
B
C
D
1
Name
Department
Role
Salary
2
John
Sales
Manager
$75,000
3
Sarah
Marketing
Director
$85,000
Ausgabe 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)
Eingabe
A
B
C
1
Year
Quarter
Revenue
2
2024
Q1
$125,000
3
2024
Q2
$142,000
Ausgabe 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)
Eingabe
A
B
C
1
apple
date
2
banana
elderberry
3
cherry
Ausgabe 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, ", ")
Eingabe
A
1
apple
2
banana
3
cherry
4
date
Ausgabe in Sheets
A
1
apple, banana, cherry, date
CLUSTERIZE(keywords)

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

fx
=CLUSTERIZE(A1:A5)
Eingabe
A
1
running shoes
2
running gear
3
marathon training
4
running tips
5
marathon shoes
Ausgabe 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")
Eingabe
A
1
Hello World, World is great
Ausgabe 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)
Eingabe
A
1
apple
2
banana
3
cherry
4
date
Ausgabe 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)
Eingabe
A
1
January
2
February
3
March
4
5
Ausgabe in Sheets
A
1
March
SPLIT_IN_COLUMNS(text, [separator])

Split text into horizontal columns using a separator.

fx
=SPLIT_IN_COLUMNS(A1, ",")
Eingabe
A
1
red,green,blue
Ausgabe 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)
Eingabe
A
1
7000
Ausgabe 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)
Eingabe
A
1
5000
Ausgabe 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)
Eingabe
A
1
10000
Ausgabe in Sheets
A
1
11,000
SELECT_RANDOM_CELL(range)

Return a random cell value from a range.

fx
=SELECT_RANDOM_CELL(A1:A4)
Eingabe
A
1
Winner A
2
Winner B
3
Winner C
4
Winner D
Ausgabe 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)
Eingabe
A
1
First
2
Second
3
Third
4
Fourth
Ausgabe in Sheets
A
1
Third

Bring Your Own Key (BYOK)

Alle AI-Funktionen unterstützen Ihre eigenen OpenAI- oder Anthropic-API-Schlüssel. Bezahlen Sie die Anbieter direkt zu deren Preisen — kein Aufschlag von uns.Fügen Sie Ihren Schlüssel hinzu in Extensions → Unlimited Sheets → Settings.

Brauchen Sie Hilfe?

Können Sie nicht finden, wonach Sie suchen? Unser Support-Team ist bereit zu helfen.

Support KontaktierenZum Dashboard Gehen