• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

How to use multiple columns of information to generate response

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

Well-known member
Staff member
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.


 
Top