Usage Guide

Learn how to use Blink AI functions in your Google Sheets™ to automate tasks, analyze data, and generate content.

Examples

Get a list of all available AI models

=BLINK_MODELS()

Translate text to Spanish using Claude 3.7 Sonnet

=BLINKAI(A2, "Translate this text to Spanish", "claude-3.7-sonnet")

Generate marketing copy with a cost-effective model

=BLINKAI("Write a product description", "You are a marketing expert. Write compelling and concise copy.", "claude-3-haiku-20240307")

Analyze sales data with Gemini

=BLINKAI(B2:B20, "Analyze this sales data and provide key insights", "gemini-1.5-pro-latest")

Generate Python code with a specialized model

=BLINKAI("Create a Python function", "You are a Python expert. Write clean, documented code.", "qwen2p5-coder-32b-instruct")

Summarize customer reviews

=BLINKAI(C1:C50, "Summarize these customer reviews in 3 bullet points", "o1-preview")

Perform sentiment analysis on customer feedback

=AiSentiment(A2:A100)

Search for specific mentions in a dataset

=AiSearch("Find mentions of pricing concerns", B1:B200, "gpt-4o")

Generate a summary of text data

=AiSummarize(E1:E30)

Analyze data patterns and trends

=AiAnalyze(G1:H20, "qwen-2.5-72b-instruct")