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