How to fix AI for Sheets formula errors in Google Sheets

Quick answer

• If you see Unknown function or Please click 🚀 Use AI Formulas in the menu to start., open Extensions → AI for Sheets → Use AI Formulas once.
• If an image or PDF formula fails, use a full http:// or https:// URL, or use Upload/Download Files to generate a working file URL.
• If the task is too large or too slow, reduce the range, shorten the prompt, and run fewer rows at a time.
• If the error mentions limits or permissions, use the matching section below before retrying.

“Please click 🚀 Use AI Formulas in the menu to start.”

This usually means the add-on has not finished initializing for your current spreadsheet or Google account.

• In Google Sheets, open Extensions → AI for Sheets → Use AI Formulas once.
• Wait for the sidebar to load fully, then return to the sheet and retry the formula.
• If you are in a copied file, a Shared Drive file, or the wrong Google account, switch to the correct account or make your own copy and try again.
• See Getting started if this is your first run.

#NAME? or “Unknown function”

This means Google Sheets does not currently recognize the AI for Sheets function name.

• Open the add-on once from Extensions → AI for Sheets → Use AI Formulas.
• Confirm the add-on is installed for the same Google account that opened the sheet.
• If you are on a work or school account, your Google Workspace admin may block Marketplace add-ons or required scopes.
• Use the current formula names from Formula reference, such as =GEN(), =VISION(), =PDF(), and =ANALYZE().

“Permission has not been granted to this add-on”

This is an authorization issue, not a prompt issue.

• Re-open the add-on and accept the Google permission prompt if it appears.
• If you already granted access before, reload the spreadsheet and open the sidebar again.
• If your organization manages Google Workspace permissions, ask your admin to allow the add-on and its required scopes.
• If you were trying to refresh billing or account status, go back to Extensions → AI for Sheets → Upgrade Account only after permissions are fixed.

“Please provide an absolute URL starting with http:// or https://”

AI for Sheets file formulas expect a real URL, not a partial path, Drive file ID, or local-looking text.

• Use a full file URL that starts with http:// or https://.
• For Google Drive files, make sure the link is accessible to the formula run. If not, use Upload/Download Files instead.
• This matters most for file-based formulas like =VISION() and =PDF().

“The image is not accessible”

This means the formula could not fetch the image from the URL you provided.

• Check the sharing settings of the image URL, especially for Google Drive links.
• If the file is private or inconsistent, use Upload/Download Files to create a working URL for AI for Sheets.
• See Make Drive images accessible for the safest setup.

“The data is too large”

Your input range or prompt payload is too big for the current run.

• Pass fewer rows or columns into the formula.
• Split long text into helper cells and summarize in smaller steps.
• If you are on the free plan, the allowed input size is smaller than paid plans.
• For big analysis tasks, use a narrower selection or break the job into smaller batches.

“This task took longer than usual” or “Exceeded maximum execution time”

The request probably took too long because the prompt, file, or selected range was too heavy.

• Shorten the prompt and add a clear output limit, for example “Keep the answer under 100 words.”
• Run fewer rows at a time, then use Save formula output if you want stable results.
• If you are using image or PDF inputs, reduce the file size or simplify the question.
• If you are using a broad workflow, start with a smaller test range before filling down.

“Google Sheets daily limit reached”

This is a Google Apps Script quota issue rather than a content issue.

• Wait for the quota window to reset, which usually happens within about 24 hours.
• Avoid repeatedly retrying the same failing batch because that can waste quota faster.
• See Google Sheets daily limit for the practical recovery steps.

“Monthly usage limit exceeded”

Your current monthly AI usage is exhausted for the plan attached to this account.

• Open Extensions → AI for Sheets → Upgrade Account to refresh billing or change plan.
• If available on your account, open Get Free Usages from the add-on menu and complete the listed tasks.
• If you recently upgraded but the limit still shows, reopen the sidebar and refresh your account status.

Still stuck?

If the error keeps coming back, send support enough detail to reproduce it quickly.

• The exact error message
• The formula you used
• Whether you were using text, image, or PDF input
• A screenshot if the sidebar or permission flow looked unusual

Start with Common setup issues, then contact [email protected] if needed.