Google Drive Trigger 'New File in a specific folder'

[sameerjain1]

Your Task History ID

IjU3NjUwNTY4MDYzNzA0M2M1MjY5NTUzZDUxM2E1MTY3NTQzNzBmMzUi_pc

While testing I am getting the desired results however, when I add a new file in the specified folder, the trigger doesnt seem to work. Also it is not reflecting as task failed or success. What could be the issue?

 

[ArshilAhmad]

Hi @sameerjain1,

Pabbly

connect.pabbly.com

Based on your Task History, we can see that your workflow is being triggered when you upload a new file to the folder named 'WhatsApp-Excel'. Could you please elaborate a bit more on the exact issue you are encountering?

 

[sameerjain1]

I rechecked the final Google sheet, the response came in quite late. It has posted only one line item. The ideal is that it should post all the line items in the worksheet.

 

[Preeti Paryani]

Hello @sameerjain1,

Apologies, but we're not entirely clear about your use case. Could you please elaborate on how your workflow is intended to function and explain the role of each step involved? This will help us better understand the overall logic and identify what changes might be required to ensure it works as expected.

 

[sameerjain1]

Hello @Preeti Paryani

Following is my use case. To convert an unstructured text file into a structured table format and upload the details in a Google Sheet

Process followed:
Trigger - A text file is uploaded in a specific google drive folder. (This file is a WhatsApp Group Message file which is unstructured and contains product listings by each group member along with description)

Action - API (Pabbly) - I am running this module to extract the complete text from the file

OpenAI - I am running this module to convert the text into a tabular format such that each product will be listed as a single line item. Each file will contain 100's of product listings

Google Sheet - I want each and every product details to be captured in the Google sheet. (Currently only a single line item is being uploaded in the sheet)

I hope I could clarify it for you. Please let me know if you need any other information

 

[Preeti Paryani]

Hello @sameerjain1,

Thanks for sharing the details. Upon checking the response received from the OpenAI action, it appears that the output includes only the data from the first paragraph of the uploaded document, not the entire content.

We recommend updating your prompt to instruct the AI to process the entire text and return all product listings in a structured array format. This will allow the automation to handle each product as a separate line item and ensure that all entries are captured correctly in the Google Sheet.

I hope these instructions are clear. Let us know if you need help refining the prompt.

 

[sameerjain1]

I amended the prompt to include "process the entire text and return all product listings in a structured array format."
The OpenAI module after running gives the desired result of a test case of about 20 product listings, however, all the listings are not updated in the Google Sheet. Only the first product gets updated in the Google sheet.
Request your help in getting the automation right.
Thanks

 

[ArshilAhmad]

Watch the video shared below to learn how you can generate a response with structured output using ChatGPT. Once you have captured the product details in a structured output, do let us know.