Sheets =AI Function: Current Facts Per Row, Checked in Sources

8 Views
0 Uses

Prompt

ChatGPT
Claude
Grok
OpenRouter
(Enter the formula in the first empty cell next to your list and fill it down. Select the cells and click Generate and Insert. Then a person should click into the CHECK rows and a sample of the others, hover over the result, and click Sources to judge whether the pages support the value. Google says "only the first 350 selected cells with AI functions will be generated", so for a longer column, select and generate up to 350 cells at a time; check Google's page for the current limit.)

=AI("Find the current {{FACT_NEEDED}} for the {{ITEM_TYPE}} named in the given cell, using up-to-date information from the web. Output only the value, in this format: {{OUTPUT_FORMAT}}. If you cannot find a value for this exact {{ITEM_TYPE}}, output CHECK instead of a value; do not give a value for a different {{ITEM_TYPE}} with a similar name.", {{FIRST_CELL}})

Customize this prompt

Fill in the variables below to personalize this prompt:

ChatGPT
Claude
Grok
OpenRouter

Report this prompt

Model Settings

Recommended Models

Gemini

Temperature

0.7

Max Tokens

2000

Additional Notes

Best for: Filling a column with web facts you can trace

About this prompt

“Sheets =AI Function: Current Facts Per Row, Checked in Sources” is a free prompt for Gemini in the Business category, 146 words long, added to The Prompt Index on November 18, 2026 by The Prompt Index. Copy it with the button above, paste it into Gemini or any other AI chat assistant, and send it.

It has 4 placeholders to fill in first: {{FACT_NEEDED}}, {{ITEM_TYPE}}, {{OUTPUT_FORMAT}}, {{FIRST_CELL}}. Use the “Customize this prompt” fields to personalise it before you copy.

Recommended models: Gemini.

0 upvotes, sent to an AI tool 0 times, viewed 8 times.

Browse all Business prompts, the AI prompt database or use the AI prompt finder to search every prompt.