Problem writing Data Extracted from Document Understanding in Google Sheet

Help StudioX
,
1

I’m trying to set up an automation in Studio Web to extract information from police reports in different folders inside one folder on Google Drive then add the data from each extracted field to a master spreadsheet. The folders are labeled according to each arrestee.

I built the automation to test it on one folder. It worked, so I expanded it to iterate through the folders using “For each file and folder.” I also set up log messages that show everything is iterating correctly and the data is being pulled from Document Understanding based on the model.

This image shows a user interface with an automated document processing system that has extracted and classified information from police reports, listing details such as case numbers, subject names, report locations, and reporting officers. (Captioned by AI)
This image shows a user interface with an automated document processing system that has extracted and classified information from police reports, listing details such as case numbers, subject names, report locations, and reporting officers. (Captioned by AI)610×726 67.4 KB

Now it’s not writing to the spreadsheet. I don’t understand what the issue is because everything is configured exactly the same. The only difference is that it’s pointed at a different spreadsheet.

The image shows a configuration screen for writing rows to a Google Sheets spreadsheet titled "HUI Police Report Data" with various fields related to police reports, using individual fields and appending data to an existing range called 'police reports'. (Captioned by AI)
The image shows a configuration screen for writing rows to a Google Sheets spreadsheet titled "HUI Police Report Data" with various fields related to police reports, using individual fields and appending data to an existing range called 'police reports'. (Captioned by AI)608×996 68.5 KB

Any guidance on this would be greatly appreciated. Thanks!

2

@justindward

Is it failing with any error?

Or is it just bypassed ?

Is continue on error true?

Are you verifying the right spreadsheet?

Cheers

3

It’s not failing. It appears to just bypass it and move to the next step. Continue on Error isn’t enabled as far as I can tell. I checked the “Properties.” I don’t think that’s even an option on Studio Web. I suppose I could try setting it up on premises and see if it works.

As for the spreadsheet, it’s configured to the correct one. All the headings pop up just like they are on the Sheet.