How to use multiple columns of information to generate response

[JS_SummitNyack]

I apologize if this was asked before and I missed it. I have a google sheet that is populated via a google form with multiple questions that translate into multiple columns in the sheet. How do a take all the columns of information and feed them into ChatGPT to create a report based on all the information not just 1 entry in 1 column?

Example: (source data could be)
Date, Name, Location, incident details and resolution

I want to take all that information and create a generic report based on all the above information.

On sep 10 2024, staff member karen fell in the cafe and spilled her coffee. maintenance called and area was cleaned accordingly. something like that assuming most of that is in the form data collected.

Please advise.

 

[Preeti Paryani]

Hello @JS_SummitNyack,

You can achieve this depending on whether you want to process one row at a time or generate a report based on all data in the sheet.

1. Processing One Row at a Time (New Form Submission)
   • Use Google Sheets: New or Updated Row as the trigger in Pabbly Connect.
   • When a new response is added, retrieve all relevant columns, including Date, Name, Location, Incident Details, and Resolution.
   • Send this data to OpenAI (ChatGPT) to generate a structured report based on the provided information.
2. Processing All Data in the Sheet (Scheduled Report)
   • Use Schedule as the trigger in Pabbly Connect, setting it to run at a preferred frequency, such as daily or weekly.
   • Add Google Sheets: Get Rows to retrieve all records from the sheet.
   • Pass the collected data to OpenAI (ChatGPT) to generate a comprehensive report summarizing all incidents.

For detailed step-by-step instructions, you may refer to the shared tutorial on using the required actions. Please let me know if you require further assistance.