I’d like to create a scenario where a PDF statement that is uploaded to a Google Drive folder gets passed into OpenAI, certain data is extracted from the statement, and then that data is stored into a Google Sheet.
I’ve attempted to do this with a module that watches for new files a Google Drive folder, then another module that Downloads the file, and I’ve been attempting to send that file to OpenAI with no luck. I’ve tested extraction of the data I want from OpenAI using GPT4 and am able to get exactly what I need manually, but I cannot get the Make scenario to automate this flow.
I would be grateful if someone could explain the correct settings that are needed in the Google Drive Download module in order to pass the file to OpenAI.
Similarly, on the OpenAI step, I would be appreciative of details on the appropriate setup to retrieve the data that I want from the statement.
My prompt for OpenAI is this:
I want you to act as an accountant. You are tasked with handling inbound statements and extracting certain data from the statement. The data you are looking for is:
Account Number, the unique number associated with the statement
Statement Date, the date the overall statement was generated
Amount Due, the dollars and cents that the patient must pay
For the Account Number, record only the last 6 digits
For the Statement date, format to mm/dd/yyyy
Deliver the results as JSON in the format of:{ “accountNumber”: “000897, “statementDate”: “09/18/2023”, “amountDue”: “100.17” }