Reads any PDF, lists every value it found in a Google Doc, and points out which ones to double-check against the original.

RPRyan Peng · 1 workflow · Updated Nov 13, 2026

UsesExtendGoogle Docs

Pull every value out of a PDF and flag what to check

ValuesSet sourceFile to blank.Set sourceFile to blank.
ValuesSet notebookDocument to blank.Set notebookDocument to blank.
ValuesSet readingGuidance to blank.Set readingGuidance to blank.
ValuesSet flagBelowConfidence to 0.7.Set flagBelowConfidence to 0.7.
TextTrim notebookDocument and save it as documentLink.Trim notebookDocument and save it as documentLink.
ValuesSet notebookId to documentLink.Set notebookId to documentLink.
Decisions & LoopsIf documentLink contains /d/If documentLink contains /d/
Yes
ListsGet the first item of the last item of documentLink split by /d/ split by / and save it as notebookId.Get the first item of the last item of documentLink split by /d/ split by / and save it as notebookId.
Else if @documentLink contains "/"
Decisions & LoopsStop and report a problem: The 'notebookDocument' step does not look like a Google Docs link. Paste the link from the address bar while the document is open, or paste just its document id.Stop and report a problem: The 'notebookDocument' step does not look like a Google Docs link. Paste the link from the address bar while the document is open, or paste just its document id.
Otherwise
No steps
Decisions & LoopsIf notebookId is emptyIf notebookId is empty
Yes
Decisions & LoopsStop and report a problem: No document id could be read out of the 'notebookDocument' step. Paste the link from the address bar while the document is open.Stop and report a problem: No document id could be read out of the 'notebookDocument' step. Paste the link from the address bar while the document is open.
No
No steps
MathSet confidenceFloor to flagBelowConfidence multiplied by 1.Set confidenceFloor to flagBelowConfidence multiplied by 1.
ExtendExtendExtract data from a document. Save it as reading.Extract data from a document. Save it as reading.readingGuidance
TextConvert reading.data to text and save it as recordJson.Convert reading.data to text and save it as recordJson.
Decisions & LoopsIf recordJson is {} or recordJson is nullIf recordJson is {} or recordJson is null
Yes
Decisions & LoopsStop and report a problem: Nothing could be read out of that document, so nothing was written. Check the file opens as a PDF or an image, and describe what it is in the 'readingGuidance' step to help the read along.Stop and report a problem: Nothing could be read out of that document, so nothing was written. Check the file opens as a PDF or an image, and describe what it is in the 'readingGuidance' step to help the read along.
No
No steps
ValuesSet valuesRead to 0.Set valuesRead to 0.
ValuesSet valuesToCheck to 0.Set valuesToCheck to 0.
ValuesSet valueLines to an empty list.Set valueLines to an empty list.
ValuesSet checkLines to an empty list.Set checkLines to an empty list.
ValuesSet coveredNames to an empty list.Set coveredNames to an empty list.
Decisions & LoopsFor each readValue in reading.field_metadata:For each readValue in reading.field_metadata:
TextTrim readValue.field and save it as valueName.Trim readValue.field and save it as valueName.
Decisions & LoopsIf valueName is emptyIf valueName is empty
Yes
Decisions & LoopsSkip to the next item.Skip to the next item.
No
No steps
ValuesAdd 1 to valuesRead.Add 1 to valuesRead.
ListsAdd valueName to the end of coveredNames and save it as coveredNames.Add valueName to the end of coveredNames and save it as coveredNames.
TextReplace _ with in valueName and save it as fieldLabel.Replace _ with in valueName and save it as fieldLabel.
TextLook up valueName in a table and save it as valueFound.Look up valueName in a table and save it as valueFound.
TextUse valueFound, or (left blank) if it is empty and save it as valueText.Use valueFound, or (left blank) if it is empty and save it as valueText.
MathSet valueConfidence to readValue.confidence multiplied by 1.Set valueConfidence to readValue.confidence multiplied by 1.
MathRound valueConfidence to 2 decimal places and save it as confidenceShown.Round valueConfidence to 2 decimal places and save it as confidenceShown.
ValuesSet pageText to page readValue.page.Set pageText to page readValue.page.
Decisions & LoopsIf readValue.page is less than 1If readValue.page is less than 1
Yes
ValuesChange pageText to page not given.Change pageText to page not given.
No
No steps
ListsAdd fieldLabel: valueText (pageText, confidence confidenceShown) to the end of valueLines and save it as valueLines.Add fieldLabel: valueText (pageText, confidence confidenceShown) to the end of valueLines and save it as valueLines.
Decisions & LoopsIf valueConfidence is less than confidenceFloorIf valueConfidence is less than confidenceFloor
Yes
ValuesAdd 1 to valuesToCheck.Add 1 to valuesToCheck.
ListsAdd - fieldLabel (pageText) to the end of checkLines and save it as checkLines.Add - fieldLabel (pageText) to the end of checkLines and save it as checkLines.
No
No steps
ValuesSet otherValues to reading.data.Set otherValues to reading.data.
Decisions & LoopsIf coveredNames isn't emptyIf coveredNames isn't empty
Yes
ListsRemove coveredNames from reading.data and save it as otherValues.Remove coveredNames from reading.data and save it as otherValues.
No
No steps
ValuesSet otherNote to blank.Set otherNote to blank.
Decisions & LoopsIf otherValues as text is not {}If otherValues as text is not {}
Yes
ValuesChange otherNote to Change otherNote to Also read, with no page or confidence given, so check these too: otherValues.
No
No steps
TextTrim reading.file_name and save it as readTitle.Trim reading.file_name and save it as readTitle.
Decisions & LoopsIf readTitle is null or readTitle is emptyIf readTitle is null or readTitle is empty
Yes
ValuesChange readTitle to Document.Change readTitle to Document.
No
No steps
Dates & TimesGet today's date and save it as today.Get today's date and save it as today.
Dates & TimesMake today readable as “Monday, November 2, 2026” and save it as readDate.Make today readable as “Monday, November 2, 2026” and save it as readDate.
TextJoin valueLines with a new line and save it as valueList.Join valueLines with a new line and save it as valueList.
ValuesSet checkNote to Every value was read at or above the confidence you set (flagBelowConfidence).Set checkNote to Every value was read at or above the confidence you set (flagBelowConfidence).
Decisions & LoopsIf valuesToCheck is greater than 0If valuesToCheck is greater than 0
Yes
TextJoin checkLines with a new line and save it as checkList.Join checkLines with a new line and save it as checkList.
TextBuild the text Check these against the original: @valuesToCheck of @valuesRead values were read below the confidence you set (@flagBelowConfidence): @checkList and save it as checkNote.Build the text Check these against the original: @valuesToCheck of @valuesRead values were read below the confidence you set (@flagBelowConfidence): @checkList and save it as checkNote.
No
No steps
Google DocsGoogle DocsAdd text to notebookId. Save it as added.Add text to notebookId. Save it as added.readTitle, read on readDate valueList@otherNote checkNote
Decisions & LoopsFinish the run: Read valuesRead values out of readTitle and added them to your Google Doc. Values to check: valuesToCheck.Finish the run: Read valuesRead values out of readTitle and added them to your Google Doc. Values to check: valuesToCheck.