Menu

How Gemini and Make Turn Uploaded PDFs Into Structured Research Records

Table of Contents

AI Tool Gemini
Automation Platform Make
Work Automated Turning an uploaded research PDF into a structured, searchable database record and a linked summary document
Trigger New file added to a Google Drive folder
Schedule Event-based, runs whenever a new PDF is added
Input A research PDF
AI Processing Gemini structures the extracted PDF text into findings, methodology, and open questions, and returns an indication of whether the result is clear or incomplete
Automation Make checks whether the PDF has already been processed, pulls the raw text from the file, sends it to Gemini, and based on that indication, creates a new database row and linked summary document marked either processed or flagged for review
Output A structured database record plus a linked summary document
Destination A Notion database (structured record) and Google Docs (summary document), cross-linked to the source PDF

The Scenario

A graduate researcher downloads research PDFs faster than she can read them. Every literature search adds another five or six PDFs to a folder, each one a potential source for her own work, but actually reading and extracting the useful parts of each one takes real, focused time she does not always have between other deadlines. PDFs pile up unread, and by the time she gets to one, she has often forgotten why she saved it in the first place.

The Challenge

  • Reading a full research PDF just to find out whether it is relevant takes time that is hard to justify for every single download.
  • PDFs pile up in a folder faster than they get reviewed, so the backlog only grows.
  • Without a saved summary, revisiting an old PDF means rereading it from scratch to remember what it actually said.
  • Even when notes exist, they usually live in scattered documents rather than one searchable place.
  • The same PDF sometimes gets downloaded more than once during different searches, with no way to notice that until it is opened.
  • Manually typing up notes for every PDF, even a summary, is a repetitive step most researchers skip until it becomes unavoidable.

The Automation Solution

Gemini is used here to structure a PDF’s extracted text into its main findings, its methodology, and any open questions or limitations it raises, rather than just producing a shorter version of the same text.

Whenever a new PDF lands in her “To Review” Drive folder, that upload itself starts the workflow. There is no reason to check the folder on a schedule; the work only needs to happen when a PDF actually arrives, so an event trigger fits here in a way a recurring check would not. Make’s first step is a duplicate check: it checks whether the PDF has already been processed using available file identifiers, and if a match is found,d the workflow stops there rather than creating a second, redundant record for a PDF already on file.

For a genuinely new PDF, Make pulls the raw text out of the file and sends it to Gemini with a request for structured fields: the PDF’s title, its main findings, its methodology, and any open questions or limitations it raises. If the PDF cannot yield usable text, for example a scanned PDF with no readable text layer, that failure is caught immediately and the file is flagged for manual review instead of silently producing an empty or low-quality record.

Gemini returns its structured extraction along with an indication of whether the result is clear or incomplete, and that indication decides what happens next, not the other way around. Before anything is written to Notion or Google Docs, Make checks it: a clear result gets a new database row and a linked Google Doc created and marked processed at the same time, with the database row, the summary document, and the source PDF all cross-referenced to each other. An incomplete or ambiguous result, such as a methodology section Gemini could not extract with confidence, still gets a database row and summary document created, but marked for human review instead of processed by default, so human review is a decision point in the middle of the workflow, not just a final glance at the end.

Make is the connective layer throughout: watching the folder, checking for duplicates, pulling the raw text, calling Gemini, and creating each record already marked with the right status. Gemini is the part used to structure what the PDF’s text says and to return how clear or complete that structuring came out.

1
Trigger

New PDF added to Drive folder

2
Duplicate check

Make checks whether the PDF was already processed; stops here if it was

3
PDF text extraction

Make pulls the raw text out of the file

4
AI structured extraction

Gemini structures findings, method, and open questions

Extraction clear?
Yes
Record and doc created, marked processed
No
Record and doc created, flagged for human review

Example Structured Output

A short illustrative example of the structured record Gemini and Make produce together, before a person ever needs to look at it:

				
					{
  "pdf_title": "As read from the PDF",
  "duplicate_check": "not_duplicate",
  "findings": [
    "As extracted from the PDF, or empty if unclear"
  ],
  "methodology": "As described, or unclear if not confident",
  "open_questions": [
    "As noted in the PDF, or empty if none stated"
  ],
  "extraction_status": "clear",
  "review_status": "processed"
}

				
			

This is a simplified illustration of the type of structured record the workflow produces. It is not a real PDF’s actual content, and any field the source PDF does not clearly state stays empty or marked unclear rather than being filled in artificially.

What AI Handles vs What Stays Human

AI HandlesAutomation HandlesHuman Handles
Structuring findings, methodology, and open questionsChecking whether the PDF was already processedReviewing unclear or failed extractions
Assessing whether its structured extraction is clear or incompleteExtracting the raw text from the PDFDeciding whether the PDF is relevant
Sending the extracted content to GeminiDeciding what to cite or build on
Creating the Notion and Google Docs recordsPrioritizing which PDFs to read in full
Applying the correct status to each recordCatching errors in supposedly processed records
Routing the workflow to processed or review

Gemini’s extraction is a starting point for deciding whether a PDF matters, not a substitute for reading the parts that turn out to matter. The clarity check catches the clearest cases automatically, but a dense or unusually structured PDF can still confuse the extraction, so review stays available at the point where the workflow itself is unsure, not only after everything is already filed.

Outcome

The main outcome is consistency: every uploaded PDF follows the same extraction, validation, and review path.

  • The workflow converts an unstructured PDF into a consistent, searchable record without requiring manual extraction and note-taking
  • Duplicate uploads of the same PDF are caught before a second record gets created, instead of cluttering the database.
  • Failed or unreadable extractions are flagged immediately instead of quietly producing a blank or misleading record
  • Findings and methodology stay attached to the source PDF, instead of relying on memory weeks later
  • Only extractions the workflow itself considers clear get marked processed automatically, so uncertain cases are not skipped
  • A running, organized, cross-linked record of reviewed PDFs builds up automatically over time

No specific time savings, productivity percentages, or outcome figures are claimed here, since none have been verified for any particular person’s use of this workflow. The benefits above are structural outcomes of triggering this process on upload and routing uncertain cases to review, not measured results.

Schedule & Trigger Details

Schedule Event-based, no fixed time
Trigger New file added to the Drive folder
Input The uploaded PDF
AI Processing Gemini structures the extracted text into findings, methodology, and open questions, and returns an indication of whether the result is clear or incomplete
Automation Make checks whether the PDF was already processed, extracts the raw text, calls Gemini, and creates the database record and linked summary document already marked processed or flagged for review
Output A structured database record plus a linked summary document
Destination Notion (structured record) and Google Docs (summary document)

Tools Used

Gemini: structures extracted PDF text into findings, methodology, and open questions, and returns an indication of whether the result is clear or incomplete

Make: watches the folder, checks for duplicates, extracts the raw text, calls Gemini, creates the records and documents, and assigns the correct status

Google Drive: the input folder where new PDFs are added

Notion: holds the structured database record

Google Docs: holds the linked summary document

Get Started

If research PDFs are piling up faster than they get read, this pattern is worth setting up properly: an AI tool for the extraction work, and an automation platform like Make for catching duplicates and routing anything uncertain to review instead of marking it done by default. Zipprr can help design and implement similar AI-powered research and document workflows using the tools you already rely on.

Book Your Meeting

Let’s Talk! Book Your Meeting