Feature Request/Guidance: Google Sheets Gemini Agent to open PDF from hyperlink, extract data and then compare to data given within the spreadsheet

Gemini API
1

Hello,
I am setting up an automated audit workflow in Google Sheets using the Gemini app.

My Goal: I need the agent to perform a programmatic cross-reference audit check between a numerical value in a Google Sheet cell and a corresponding figure inside a linked source document (PDF, Image, or Bank Statement) stored in Google Drive.

Current Setup & Problem:

  1. Workpaper: A cell in Google Sheets (D9) contains the closing balance for an account.

  2. Source Document Link: A nearby cell (F9) contains a Google Drive link to the external source document (e.g., a PDF Bank Statement).

  3. Agent Constraint: The agent is saying it can access and manipulate the data within the active Sheet but is currently unable to follow the link, open the external PDF, reliably extract the specific closing balance from the PDF, and perform the required comparison.

My Query:What is the recommended design pattern, tool usage, or API call sequence to enable this level of cross-document data extraction and verification?

Is there a way to:

  1. Instruct the agent to read the content of a linked Drive file based on a URL within a Sheet

  2. Extract a specific, predictable piece of information (e.g., “closing balance”) from that document?

  3. Pass that extracted value back to the Gemini environment for comparison against a cell value?Any guidance on how to best bridge this gap between structured sheet data and unstructured linked document data would be greatly appreciated, as it is a critical requirement for a fully automated compliance workflow.

    Thank you.