Capstone Project Part 4 - Agentic Assessment Agent

​@odornala Line numbers are not visible in your screen shot. Is the error coming from the Loop action?

If so, does your Google Sheets: Open action have the "file contains headers" (or similar) open checked?

Hi ​@Aaron.Gleason,

Thanks for the swift response.

Yes, the error is coming from the loop action.

Yes, In my Google Sheets: Open action have the “file contains header” has been checked by default when I imported the .zip file. 

​@odornala Check the Google sheet itself. The headings of the file are the record names. For example, there should be a heading that says "Submission Datetime" if that's what you put in the loop. You can also consider using a Record variable to get the row of data from the spreadsheet. Then, in Debug mode, you can inspect the values of the Record variable and see which headings it's retrieving. 

​@Aaron.Gleason thank you so much! Now I found the issue after checking the Google Sheet itself especially the heading “Submission Datetime”. Initially it was “Submission Datatime” in the google sheet. After changing it to “Submission Datetime” debug was successfull.