psychology
=GPT(prompt, [value])
expand_more

The simplest function to start using GPT in Sheets. Outputs the result in a single cell.

Arguments:

prompt (required): The instruction or text for GPT to process.
value (optional): Additional context or value to use in processing.
Example:
=GPT("write a tagline for coffee shop")
Example with Value:
=GPT("write a tagline for ", A1)
Example with Concatenation:
=GPT("describe the product: " & A1 & " available at the price: " & B1)
Example with Multiple Concatenations:
=GPT("Create an ad for " & A1 & " and highlight its features: " & B1 & ", " & C1)
search
=SERP(query, limit)
expand_more

Submits a search query to a search engine and returns the top search results.

Supported operators

Arguments:

query (required): The search query.
limit (optional): The maximum number of search results to return. Default is 20.
Example:
=SERP("docgpt.ai", 10)
Example for Pulling Emails from Instagram:
=SERP("site:instagram.com Yoga gmail.com", 40)

Note: This function is currently in beta. It can be called once every 20 seconds.

psychology
=PERPLEXITY(prompt)
User Pro
expand_more

The simplest function to start using PERPLEXITY (support WEB ACCESS!) in Sheets. Outputs the result in a single cell.

Arguments:

prompt (required): The instruction or text for PERPLEXITY to process.
Example:
=PERPLEXITY("write a tagline for coffee shop")
Example with Concatenation:
=PERPLEXITY("describe the product: " & A1 & " available at the price: " & B1)
Example with Multiple Concatenations:
=PERPLEXITY("Create an ad for " & A1 & " and highlight its features: " & B1 & ", " & C1)
psychology
=GEMINI(prompt)
User Pro
expand_more

The simplest function to start using GEMINI in Sheets. Outputs the result in a single cell.

Arguments:

prompt (required): The instruction or text for GEMINI to process.
Example:
=GEMINI("write a tagline for coffee shop")
psychology
=CLAUDE(prompt)
User Pro
expand_more

The simplest function to start using CLAUDE in Sheets. Outputs the result in a single cell.

Example:
=CLAUDE("write a tagline for coffee shop")
psychology
=LINKEDIN_POST(text)
Business
expand_more

This function facilitates creating a post on LinkedIn. You can include emojis, multi-line text, and links as part of this content.

Arguments:

text (required): The text that you want to share on LinkedIn. Can be a direct string (e.g., "Hello LinkedIn!") or a reference to a cell (e.g., A1).
Example: Simple Text
=LINKEDIN_POST("Hello from LinkedIn!๐Ÿš€๐Ÿš€๐Ÿš€")

Clicking the resulting link should open a LinkedIn โ€œShare Offsiteโ€ dialog, attempting to pre-fill your text.

Example: Emojis
=LINKEDIN_POST("Check out my new product ๐Ÿš€")

Emojis will be URL-encoded so they should appear correctly in the share dialog.

Example: Multi-Line & Links
=LINKEDIN_POST("Join our webinar๐Ÿš€๐Ÿš€๐Ÿš€!\nSign up at https://example.com\nLetโ€™s learn together!")

Use \n to create multi-line text. Links (like https://example.com) are also preserved.

Referencing a Cell
=LINKEDIN_POST(A1)

Whatever text is in cell A1 will be passed to LinkedIn. It can include emojis, multiple lines, or links.

Clickable Hyperlink (Optional)
=HYPERLINK(LINKEDIN_POST("Connect with me on LinkedIn!๐Ÿš€๐Ÿš€๐Ÿš€"), "Click to Share")

Use HYPERLINK to convert the generated URL into a more user-friendly clickable text.

psychology
=TWITTER_POST(text)
Business
expand_more

This function facilitates creating a post on X (formerly Twitter). It automatically handles spaces, emojis, multi-line text, and links by URL-encoding the string.

Arguments:

text (required): The text to place in your pre-filled X post. This can be a literal string ("Hello World"), or a reference to a cell containing textโ€”even multi-line text.
Example: Simple Text
=TWITTER_POST("Hello World๐Ÿš€๐Ÿš€๐Ÿš€")

This will create a link that, when clicked, opens the X post composer with "Hello World" pre-filled.

Example: Emojis
=TWITTER_POST("Greetings from the future! ๐Ÿค–")

Emojis are automatically URL-encoded, so they appear correctly in your pre-filled post.

Example: Referencing a Cell
=TWITTER_POST(A1)

If cell A1 contains Hello from cell data!, the generated link will pre-fill that text in X.

Example: Multi-Line Text with Emojis and Links
=TWITTER_POST("Hi everyone!\nCheck out my site: https://example.com\nHereโ€™s a rocket: ๐Ÿš€")

This example demonstrates multi-line usage.
A new line is represented by \n, and the text includes a link and an emoji. All special characters are properly encoded, ensuring the URL is valid.

Optional: Creating a Clickable Link with HYPERLINK
=HYPERLINK(TWITTER_POST(A1), "Click to Post!")

This wraps the URL in a clickable link titled Click to Post!, so people can just click it to open X and see the pre-filled text.

work
=LINKEDIN_AUTOMATION()
NEW
expand_more

Automates various LinkedIn actions such as collecting profiles by filter from Search, Events, Sales Navigator. Sending connection requests and messages, auto-commenting, liking posts, using predefined workflows.

Setup Required:

IMPORTANT: To use this, please install the extension by visiting this link
public
=GOOGLE_INDEXING(url)
Business
expand_more

Allows site owners to directly notify Google when pages are added or updated.

Authentication:

Before using, please click on this link to Authorize Application.
Ensure you have added the current email to Google Console Search with the role of Owner.

Indexing pages for search results

Arguments:

url (required): The URL to notify Google for indexing.
Example:
=GOOGLE_INDEXING("https://docgpt.ai/docs/")

Note: The function will notify Google of the URL's presence, but indexing status might take some time to update. Ensure your Google Search Console account is configured correctly.

email
=SEND_EMAIL(recipientEmail, subject, messageBody, isHtml)
Business
expand_more

Sends an email using the Gmail API, supporting both HTML and plain text formats.

Authentication:

Before using, please click on this link to Authorize Application.
Ensure your Gmail account is connected and authorized for API access.

Arguments:

recipientEmail (required): The recipient's email address.
subject (required): The subject of the email.
messageBody (required): The content of the email (can be HTML or plain text).
isHtml (optional, default = false): A boolean indicating whether the email content is HTML (true) or plain text (false).
Example (Sending Plain Text):
=SEND_EMAIL("example@example.com", "Greetings", "Hello! This is a plain text email.", false)
Example (Sending HTML):
=SEND_EMAIL("example@example.com", "Hello World!", "<b>Welcome</b> to our service!", true)

Note: This function requires OAuth authorization to send emails on behalf of the user. If authorization has not been granted, the function will return an authorization URL. Once authorized, the email will be sent via the Gmail API. Ensure your Gmail account is configured correctly.

Example (Sending HTML from a Cell):
=SEND_EMAIL( "example@example.com", "Hello from a Cell!", A1, TRUE )
Example (Sending HTML with Emojis):
=SEND_EMAIL( "example@example.com", "Monthly Newsletter", "<h1>Hello, Subscriber! ๐Ÿ‘‹</h1><p>Weโ€™re thrilled to share our latest updates with you.<br>Have a look at this exciting feature: ๐Ÿš€</p><a href='https://example.com'>Click here for details</a><p>Best Regards,<br><strong>The Awesome Team</strong></p>", TRUE )
api
=API(method, url, queryParams, body, headers, isJson)
User Pro
expand_more

Makes HTTP requests to external APIs with customizable parameters.

Arguments:

method (required): GET, POST, PUT, DELETE, OPTIONS, HEAD
url (required): URL for the API request
queryParams (required): Query parameters for URL or empty string ""
body (optional): String body, usually for POST requests. Use DOUBLE QUOTES for JSON fields
headers (optional): Headers in format "header_name1=value1,header_name2=value2"
isJson (required): TRUE or FALSE to return formatted JSON or plain text
GET Example (Plain Text):
=API("GET", "https://dogapi.dog/api/v2/breeds", "", "", "", false)
POST Example with Headers:
=API("POST", "https://google.serper.dev/search", "", "{""q"": ""apple inc""}", "X-API-KEY=YOUR_API_KEY", true)
GET with Query Parameters:
=API("GET", "https://cataas.com/api/cats", "tags=cute&limit=2", "", "", true)
POST with JSON Body:
=API("POST", "https://668e8e93bf9912d4c92eca5e.mockapi.io/test", "", "{""name"": ""dog name 1""}", "", true)
psychology
=MAILTO_LONG_TEXT( to, subject, body, [isHtml] )
User Pro
expand_more

This function generates a mailto: link that includes the email recipient (to), a subject, and a body which can contain multiple lines or even HTML markup. If you specify isHtml as TRUE, it indicates that your content is HTML-based. However, rendering of HTML is client-dependent and not guaranteed by the mailto: standard.

Arguments:

to (required): The email address of the recipient.
subject (required): The subject line for the email.
body (required): The main body of the email. Use \n for line breaks, or HTML tags.
isHtml (optional, boolean): Indicates if the body is HTML content (TRUE) or plain text (FALSE). Behavior depends on the email client.
Example: Plain Text
=MAILTO_LONG_TEXT( "example@example.com", "Hello World!", "Line 1\\nLine 2 with a new line!", FALSE )

This constructs a mailto link that opens an email draft to example@example.com with the specified subject and body. \n is replaced with a real line break.

Example: Multi-Line HTML + Emojis
=MAILTO_LONG_TEXT( "example@example.com", "Welcome ๐Ÿš€", "<h2>Hello!</h2>\\n<p>We're excited to have you.</p>\\n<p>Check out our <a href='https://example.com'>website</a> for more info.</p>", TRUE )

This example uses HTML tags and emojis in the body. Notice the \n for line breaks and escaped HTML characters (like <, >). Some email clients may interpret this as HTML, while others might display it as plain text.

Using HYPERLINK to Make It Clickable
=HYPERLINK( MAILTO_LONG_TEXT("test@example.com", "Test Email", "Hello from Sheets!", FALSE), "Send Email" )

Wrap the URL with HYPERLINK to create a clickable link labeled โ€œSend Email.โ€

place
=GOOGLE_MAPS_GET_PLACES(apiKey, location, radius, type, keyword, limit)
Business
expand_more

Gets a list of places near a specified location with all available data from the Places API.

Arguments:

apiKey (required): Your Google Places API key.
location (required): The location for the search (e.g., "Los Angeles, CA" or "34.0522,-118.2437").
radius (required): The search radius in meters (e.g., 1000 for 1 km).
type (required): The type of place (e.g., "restaurant", "cafe", etc.).
keyword (optional): Additional keyword for refining the search.
limit (optional): The maximum number of results to return (default is 20).
Example (Basic Search):
=GOOGLE_MAPS_GET_PLACES("API_KEY", "34.0522,-118.2437", 1000, "restaurant", "", 20)
Example (Cafes in San Francisco):
=GOOGLE_MAPS_GET_PLACES("API_KEY", "37.7749,-122.4194", 500, "cafe", "", 10)

Setup Instructions:

  1. Visit the Google Cloud Console
  2. Create/select a project
  3. Enable Places API in Library
  4. Generate API key in Credentials

Google offers up to 100 free queries per day.

search
=GOOGLE_MAPS_PLACE_GOOGLE(apiKey, placeId)
Business
expand_more

Retrieves detailed information about a specific place using Google Places API.

Setup:

  1. Visit Google Cloud Console
  2. Enable Places API
  3. Create credentials (API key)

Arguments:

apiKey (required): Your Google Places API key.
placeId (required): Google Place ID of the location.
Example:
=GOOGLE_MAPS_PLACE_GOOGLE("your-api-key", "ChIJN1t_tDeuEmsRUsoyG83frY4")
data_object
=FLATTEN_JSON(jsonString)
User Pro
expand_more

Converts nested JSON structure into a flat format suitable for spreadsheet cells.

Arguments:

jsonString (required): JSON string to flatten.
Basic Example:
=FLATTEN_JSON("{"user": {"name": "John", "age": 30}}")
With Cell Reference:
=FLATTEN_JSON(A1)
connect_without_contact
=PROSPEO_GET_EMAIL_BY_LINKEDIN(apikey, linkedinUrl)
Business
expand_more

Finds professional email address using LinkedIn profile URL via Prospeo API.

Setup:

  1. Sign up at Prospeo
  2. Get your API key from API Settings

Arguments:

apikey (required): Your Prospeo API key.
linkedinUrl (required): Full LinkedIn profile URL.
Example:
=PROSPEO_GET_EMAIL_BY_LINKEDIN("your-api-key", "https://linkedin.com/in/username")
contact_mail
=PROSPEO_GET_EMAILS(apiKey, domain, limit)
Business
expand_more

Find business email addresses associated with a domain using Prospeo API.

Setup:

  1. Sign up at Prospeo
  2. Get your API key from API Settings

Arguments:

apiKey (required): Your Prospeo API key.
domain (required): Company domain to search.
limit (optional): Maximum number of emails to return (default: 100).
Basic Example:
=PROSPEO_GET_EMAILS("your-api-key", "company.com")
With Limit:
=PROSPEO_GET_EMAILS("your-api-key", "company.com", 50)
person_search
=PROSPEO_GET_LINKEDIN(apiKey, domain, limit)
Business
expand_more

Find LinkedIn profiles associated with a company domain using Prospeo API.

Setup:

  1. Sign up at Prospeo
  2. Get your API key from API Settings

Arguments:

apiKey (required): Your Prospeo API key.
domain (required): Company domain to search.
limit (optional): Maximum number of profiles to return (default: 100).
Basic Example:
=PROSPEO_GET_LINKEDIN("your-api-key", "company.com")
With Limit:
=PROSPEO_GET_LINKEDIN("your-api-key", "company.com", 50)
contacts
=APOLLO_GET_CONTACTS(apiKey, domain, limit)
Business
expand_more

Retrieve contact information from Apollo.io based on company domain.

Setup:

  1. Create account at Apollo.io
  2. Get API key from Settings โ†’ API Keys

Arguments:

apiKey (required): Your Apollo API key.
domain (required): Company domain to search.
limit (optional): Maximum number of contacts (default: 100).
Basic Example:
=APOLLO_GET_CONTACTS("your-api-key", "company.com")
With Limit:
=APOLLO_GET_CONTACTS("your-api-key", "company.com", 50)
model_training
=REPLICATE_USING_VERSION(token, prompt, version)
Business
expand_more

Run AI models on Replicate using specific model versions.

Setup:

  1. Sign up at Replicate
  2. Get API token from Account Settings

Arguments:

token (required): Your Replicate API token.
prompt (required): Input prompt or parameters for the model.
version (required): Specific model version ID.
Example:
=REPLICATE_USING_VERSION("your-token", "A scenic landscape", "stability-ai/sdxl/39ed52f2a78e934b3ba6e2a89f5b1c712de7dfea535525255b1aa35c5565e08b")
model_training
=REPLICATE_USING_MODEL_URL(token, prompt, modelUrl)
Business
expand_more

Run AI models on Replicate using model URLs.

Setup:

  1. Sign up at Replicate
  2. Get API token from Account Settings

Arguments:

token (required): Your Replicate API token.
prompt (required): Input prompt or parameters for the model.
modelUrl (required): URL of the model on Replicate.
Example:
=REPLICATE_USING_MODEL_URL("your-token", "A scenic landscape", "https://api.replicate.com/v1/models/stability-ai/sdxl")
cloud_upload
=UPLOAD_TO_CLOUDINARY(cloudName, uploadPreset, imageUrl)
User Pro
expand_more

Upload images to Cloudinary from URLs or cell references.

Setup:

  1. Create account at Cloudinary
  2. Get your cloud name from Dashboard
  3. Create an upload preset in Settings โ†’ Upload

Arguments:

cloudName (required): Your Cloudinary cloud name.
uploadPreset (required): Upload preset name from settings.
imageUrl (required): URL of image to upload or cell reference.
Example with URL:
=UPLOAD_TO_CLOUDINARY("your-cloud-name", "preset-name", "https://example.com/image.jpg")
Example with Cell Reference:
=UPLOAD_TO_CLOUDINARY("your-cloud-name", "preset-name", A1)
search
=GOOGLE_SEARCH_API(query, apiKey, cx, num)
Business
expand_more

Search Google using the Custom Search JSON API.

Setup:

  1. Create a Custom Search Engine at Programmable Search
  2. Get your Search Engine ID (cx)
  3. Enable Custom Search API and get API key from Google Cloud Console

Arguments:

query (required): Search query.
apiKey (required): Your Google Custom Search API key.
cx (required): Your Custom Search Engine ID.
num (optional): Number of results to return (default: 10).
Example:
=GOOGLE_SEARCH_API("latest tech news", "your-api-key", "your-search-engine-id", 5)
travel_explore
=BRAVE_SEARCH_WEB(query, subscriptionToken, resultFilter, count, country)
User Pro
expand_more

Search the web using Brave Search API.

Setup:

  1. Visit Brave Search API
  2. Create an account and subscribe to an API plan
  3. Get your API key from the dashboard

Arguments:

query (required): Search query.
subscriptionToken (required): Your Brave Search API key.
resultFilter (optional): Result types (web, news, etc.).
count (optional): Number of results to return (default: 20).
country (optional): Two-letter country code for localized results.
Basic Example:
=BRAVE_SEARCH_WEB("artificial intelligence news", "your-api-key")
With Country:
=BRAVE_SEARCH_WEB("local news", "your-api-key", "web", 10, "UK")
note_add
=CREATE_FILE_ON_DRIVE(fileName, content, mimeType)
Business
expand_more

Creates a new file in Google Drive with specified content and type.

Authentication Required:

Click on this link to Authorize Application.

Arguments:

fileName (required): Name for the new file (with extension).
content (required): File content.
mimeType (optional): MIME type (default: 'text/plain').

Common MIME Types:

  • text/plain - Text files
  • text/html - HTML files
  • application/json - JSON files
  • application/pdf - PDF files
Create Text File:
=CREATE_FILE_ON_DRIVE("notes.txt", "Meeting notes for today")
Create HTML File:
=CREATE_FILE_ON_DRIVE("page.html", "

Hello World

", "text/html")
article
=SEO_BLOG(blog title, writing Tone, language)
User Pro
expand_more

Generates an SEO-optimized blog post (1k+ words) based on the provided title, writing tone, and language.

Arguments:

blogTitle (required): The title of the blog post.
writingTone (optional): The tone of the blog post. Default is 'Professional'.
language (optional): The language of the blog post. Default is 'English'.
Example:
=SEO_BLOG("How to Improve Your SEO Strategy", "Informative", "English")

This function helps you create an SEO-optimized blog post tailored to your title, tone, and language preferences.

trending_up
=SEO_OUTRANK(url outrank, writing tone, language)
User Pro
expand_more

Analyzes the given URL and provides content recommendations to outrank it in search engine results.

Arguments:

urlOutrank (required): The URL of the page you want to outrank.
writingTone (optional): The tone of the content. Default is 'Professional'.
language (optional): The language of the content. Default is 'English'.
Example:
=SEO_OUTRANK("https://docgpt.ai", "Professional", "English")

This function helps you create optimized content to potentially outrank the specified URL in search results.

description
=SEO_STRATEGY(keywords, language)
User Pro
expand_more

Generates a comprehensive SEO strategy based on the provided keywords and language.

Arguments:

keywords (required): A list of keywords (comma separated) to target in your SEO strategy.
language (optional): The language of the SEO strategy. Default is 'English'.
Example:
=SEO_STRATEGY("SEO, content marketing, keyword research", "English")

This function helps you create a tailored SEO strategy based on your keywords and selected language.

analytics
=GOOGLE_RANKED_KEYWORDS(domain, count, login, password)
Business
expand_more

Fetches the ranked keywords for a specified domain using the DataForSEO API. This function provides insights into the keywords for which a domain is ranking in Google search results.

Arguments:

domain (required): The domain for which you want to retrieve ranked keywords.
count (optional): The number of ranked keywords to return. Default is 100.
login (required): Your DataForSEO account login.
password (required): Your DataForSEO account password.

API Key Information:

You can obtain a free API key from DataForSEO. The free plan allows for approximately 40 queries.

Example:
=GOOGLE_RANKED_KEYWORDS("example.com", 100, "your_login", "your_password")

This function retrieves the ranked keywords for the specified domain from Google's search results, based on your DataForSEO credentials.

search
=GOOGLE_KEYWORD_SUGGESTIONS(seedKeyword, login, password)
Business
expand_more

Generates keyword suggestions based on a seed keyword using the DataForSEO API. This function helps you discover related keywords and phrases that are relevant to your seed keyword.

Arguments:

seedKeyword (required): The main keyword or phrase for which you want to generate suggestions.
login (required): Your DataForSEO account login.
password (required): Your DataForSEO account password.

API Key Information:

You can obtain a free API key from DataForSEO. The free plan allows for approximately 40 queries.

Example:
=GOOGLE_KEYWORD_SUGGESTIONS("digital marketing", "your_login", "your_password")

This function retrieves keyword suggestions based on the seed keyword you provide, helping you to identify additional relevant keywords for your SEO or marketing strategy.

connect_without_contact
=GOOGLE_RELATED_KEYWORDS(keyword, login, password)
Business
expand_more

Retrieves related keywords based on a given keyword using the DataForSEO API. This function helps you find keywords that are contextually related to the keyword you provide, enhancing your keyword research and SEO strategy.

Arguments:

keyword (required): The main keyword for which you want to find related keywords.
login (required): Your DataForSEO account login.
password (required): Your DataForSEO account password.

API Key Information:

You can obtain a free API key from DataForSEO. The free plan allows for approximately 40 queries.

Example:
=GOOGLE_RELATED_KEYWORDS("content marketing", "your_login", "your_password")

This function helps you discover keywords related to your main keyword, aiding in comprehensive keyword research and optimization for better search engine visibility.

lightbulb
=GOOGLE_KEYWORD_IDEAS(seedKeyword, login, password)
Business
expand_more

Generates keyword ideas based on a seed keyword using the DataForSEO API. This function helps you discover new keyword opportunities related to your seed keyword, enhancing your SEO and content strategies.

Arguments:

seedKeyword (required): The main keyword from which you want to generate keyword ideas.
login (required): Your DataForSEO account login.
password (required): Your DataForSEO account password.

API Key Information:

You can obtain a free API key from DataForSEO. The free plan allows for approximately 40 queries.

Example:
=GOOGLE_KEYWORD_IDEAS("digital marketing", "your_login", "your_password")

This function helps you generate a list of keyword ideas related to your seed keyword, providing valuable insights for expanding your keyword research and improving your SEO performance.

find_replace
=REPLACE_TEMPLATES(template, VAR_1, VAR_2, ...)
expand_more

Replaces templated variables in a string with values from specified cells or hardcoded strings. This function allows you to create dynamic text by replacing placeholders like {{VAR_1}}, {{VAR_2}}, etc., with corresponding values provided in the cells or directly in the function call.

Arguments:

template (required): The template string containing placeholders like {{VAR_1}}, {{VAR_2}}, etc.
VAR_1, VAR_2, ... (required): The values that will replace the corresponding placeholders in the template. The first value replaces {{VAR_1}}, the second value replaces {{VAR_2}}, and so on.

Example 1: Using Cell References

=REPLACE_TEMPLATES(A1, B1, C1, D1)

Where:

  • A1: Contains the template string, e.g., "Buy a {{VAR_1}} for {{VAR_2}} at {{VAR_3}}"
  • B1: Contains the value for {{VAR_1}}, e.g., "Laptop"
  • C1: Contains the value for {{VAR_2}}, e.g., "$999"
  • D1: Contains the value for {{VAR_3}}, e.g., "Amazon"

Result: The function will return "Buy a Laptop for $999 at Amazon".

Example 2: Using Hardcoded Strings

=REPLACE_TEMPLATES("Get your {{VAR_1}} for just {{VAR_2}} from {{VAR_3}}", "Smartphone", "$699", "Best Buy")

Result: The function will return "Get your Smartphone for just $699 from Best Buy".

smart_toy
=GEMINI_CUSTOM(apiKey, model, prompt)
User Pro
expand_more

The custom GEMINI function allows you to use the GEMINI API in Google Sheets, with support for multiple models. Outputs the result in a single cell.

API Key: You can obtain your API key from here.

Supported Models:

  • gemini-2.0-flash-exp: Next generation features, speed, and multimodal generation for a diverse variety of tasks
  • gemini-1.5-flash: Fast and versatile performance across a diverse variety of tasks
  • gemini-1.5-flash-8b: High volume and lower intelligence tasks
  • gemini-1.5-pro: Complex reasoning tasks requiring more intelligence
  • text-embedding-004: Measuring the relatedness of text strings
  • aqa: Providing source-grounded answers to questions
Example 1:
=GEMINI_CUSTOM("your-api-key", "gemini-2.0-flash-exp", "Describe the benefits of AI." & " " & "Focus on healthcare applications.")
Example 2:
=GEMINI_CUSTOM("your-api-key", "gemini-1.5-flash", "Describe the benefits of AI.", "Focus on healthcare applications.")
Example 3:
=GEMINI_CUSTOM("your-api-key", "gemini-1.5-flash-8b", "Explain the concept of quantum computing." & " " & "Provide a high-level overview.")
Example 4:
=GEMINI_CUSTOM("your-api-key", "text-embedding-004", "How does a neural network work?", "")
auto_awesome
=MISTRAL(prompt)
User Pro
expand_more

The simplest function to start using MISTRAL in Sheets. Outputs the result in a single cell.

Example:
=MISTRAL("write a tagline for coffee shop")
router
=OPEN_ROUTER(model, apikey, prompt)
User Pro
expand_more

The custom function to call OpenRouter API in Sheets. Outputs the result in a single cell.

Example:
=OPEN_ROUTER("openai/gpt-3.5-turbo", "your_openrouter_api_key", "What is the meaning of life?")
brush
=GPT_CREATE_IMAGE(image description, width x height)
User Pro
expand_more

Creating images from scratch based on a text prompt DALLE 3

Example - get url to the created image:

=GPT_CREATE_IMAGE("bananas", "1024x1024")

Example - get url and display the created image:

=IMAGE(GPT_CREATE_IMAGE("bananas", "1024x1024"))
visibility
=GPT_VISION(url, prompt)
User Pro
expand_more

GPT-4 Turbo with Vision allows the model to take in images and answer questions about them.

Example 1:

=GPT_VISION("https://static.nike.com/a/images/t_PDP_1728_v1/f_auto,q_auto:eco/b7d9211c-26e7-431a-ac24-b0540fb3c00f/air-force-1-07-mens-shoes-jBrhbr.png", "Write a short description for this product")

Example 2:

=GPT_VISION(A1, A2)
GPT Vision Demo
language
=WEB_URL(url)
expand_more

Fetches the content of a URL, removing all css, script, SVG elements

Example:
=WEB_URL("https://docgpt.ai")
title
=WEB_TITLE(url)
expand_more

Fetches the meta title for a given URL

Example:
=WEB_TITLE("https://docgpt.ai")
description
=WEB_DESCRIPTION(url)
expand_more

Fetches the meta description for a given URL

Example:
=WEB_DESCRIPTION("https://docgpt.ai")
description
=WEB_H1(url)
expand_more

Fetches the content of the first H1 tag for a given URL

Example:
=WEB_H1("https://docgpt.ai")
description
=WEB_H2(url)
expand_more

Fetches the content of the first H2 tag for a given URL

Example:
=WEB_H2("https://docgpt.ai")
table_chart
=WEB_URLS_DATA(A44:A47)
expand_more

Fetches page data for a list of URLs and puts it into an organized table

Example:
=WEB_URLS_DATA(A44:A47)
format_size
=WEB_HEADINGS(url)
expand_more

Fetches all headings from a URL

Example:
=WEB_HEADINGS("https://docgpt.ai")
article
=WEB_PARAGRAPHS(url)
expand_more

Fetches all paragraphs from a URL

Example:
=WEB_PARAGRAPHS("https://docgpt.ai")
settings
=GPT_CUSTOM(prompt, apiKey, [model], [max_tokens], [temperature], [top_p])
expand_more

This function calls the OpenAI GPT API to generate text completions directly in Google Sheets. You can customize the model, max_tokens, temperature, and top_p, or use the default values.

Arguments:

prompt (required): The input prompt to generate a response from GPT.
apiKey (required): Your OpenAI API key.
model (optional): The GPT model to use, default is 'gpt-4-turbo'.
max_tokens (optional): The maximum number of tokens in the response, default is 2000.
temperature (optional): Controls the randomness of the response, default is 0.7.
top_p (optional): Controls the diversity of the response, default is 0.9.

Basic Example:

=GPT_CUSTOM("Write a blog post intro about AI.", "your-api-key")

Example with specific parameters:

=GPT_CUSTOM("Describe the benefits of AI.", "your-api-key", "gpt-3.5-turbo", 1500, 0.6, 0.8)

Example with concatenation:

=GPT_CUSTOM("Describe the product: " & A1 & " available at the price: " & B1, "your-api-key")

Example with multiple concatenations:

=GPT_CUSTOM("Create an ad for " & A1 & " and highlight its features: " & B1 & ", " & C1, "your-api-key")

Example with advanced concatenation (product description):

=GPT_CUSTOM("Create a detailed description for " & A1 & " available in the following sizes: " & B1 & " and priced at: " & C1 & ". The color options are: " & D1, "your-api-key")

Example with advanced concatenation (blog post):

=GPT_CUSTOM("Write a blog post titled: " & A1 & ". Include the following sections: " & B1 & ". End with a call to action focused on: " & C1, "your-api-key")
local_offer
=GPT_TAG(text, [tags])
expand_more

Applies user-defined tags to a given text

Example with custom tags:

=GPT_TAG("I love chocolate", "food, positive, negative")

Example with default tags:

=GPT_TAG("I love chocolate")
data_object
=GPT_EXTRACT(text, to_extract)
expand_more

Extracts data (like email addresses or company names) from a text. Outputs as comma-separated values.

Example:
=GPT_EXTRACT("I worked 12 years at Amazon.com at Apple", "companies")
translate
=GPT_TRANSLATE(text, target, [source])
expand_more

Translates input text into another language using GPT.

Example with target language:

=GPT_TRANSLATE("I love ice cream", "spanish")

Example with source and target:

=GPT_TRANSLATE("I love ice cream", "spanish", "english")
summarize
=GPT_SUMMARIZE(text, [format])
expand_more

Summarizes the input text using GPT and returns the summary.

Default format example:

=GPT_SUMMARIZE("This is a long text. It contains a lot of information. We need to summarize it.")

Custom format example:

=GPT_SUMMARIZE("This is a long text. It contains a lot of information. We need to summarize it.", "two sentences")
code
=GPT_FORMAT(text, source, target)
expand_more

Converts between formats.

Example:
=GPT_FORMAT("<ul><li><p>Name: Joe</p><p>Age: 27</p></li><li><p>Name: Jane</p><p>Age: 28</p></li></ul>", "json")
category
=GPT_CLASSIFY(text, categories)
expand_more

Classifies the input into one of the given categories.

Example:
=GPT_CLASSIFY("banana", "fruit, vegetable")
auto_fix_high
=GPT_FILL(examples, inputs)
expand_more

Magically fills or cleans a range from a few examples. AI learns from provided examples and processes inputs with this knowledge

Arguments:

examples - Range containing complete examples that the AI should learn from
inputs - Range containing data to process
Example:
=GPT_FILL(A1:C3, A4:C8)
format_list_bulleted
=GPT_LIST(prompt, [value])
expand_more

Like GPT, but outputs the results in a vertical column. Very practical when the output is a vertical list

Example:
=GPT_LIST("Give me 5 good short ads about spreadsheets.")
GPT List Demo
view_week
=GPT_HLIST(prompt, [value])
expand_more

Like GPT, but outputs the results in a horizontal column. Very practical when the output is a horizontal list

Example:
=GPT_HLIST("Give me 5 good short ads about spreadsheets.")
vertical_split
=GPT_SPLIT(text, split_by)
expand_more

Splits text semantically, such as by section, paragraph, sentence, customer, etc... anything! Output is a vertical list

Example:
=GPT_SPLIT("The sky is blue. The cat purrs softly. The sun shines brightly.", "sentences")
horizontal_split
=GPT_HSPLIT(text, split_by)
expand_more

Splits text semantically, such as by section, paragraph, sentence, customer, etc... anything! Output is a horizontal list

Example:
=GPT_HSPLIT("The sky is blue. The cat purrs softly. The sun shines brightly.", "sentences")
auto_fix_normal
=GPT_APPLY(text, [task])
expand_more

Applies the given task to the given text. The default task is to fix grammar and spelling.

Example:
=GPT_APPLY("He hav a book", "fix grammar and spelling")
table_chart
=GPT_TABLE(prompt, headers)
expand_more

Generates a table from a prompt.

Example:
=GPT_TABLE("top 10 most eaten fruits and their nutrition data", A1:D1)
GPT Table Demo
feedback
REQUEST A NEW FEATURE
expand_more

Have a suggestion or feature request? I'd love to hear from you! Please email me directly at yaroslav91@gmail.com.