Example: Loop Spreadsheets/CSV Rows Agent

Niklas Richardson

During the process of trying to figure out how to get Loop actions to work with Google Sheets I created a super simple example agent to demonstrate functionality and give others a simple base to work off. I'm not sure if there's a better way. I would be interested in any feedback.

Hopefully, it saves someone else some time.

Questions:

1. In the Sub-agent step, I haven't figured out how to use the AI Instructions to populate any Sub-agent custom input variables if you have created additional input variables aside from the system Loop item input variable. It would be great to deal with the row at this level and split it into columns/fields for passing into the Sub-agent. If there is a way I haven't figured out how to do that.
2. I'm not sure I need Step 1 in the Sub-Agent to extract the columns/fields from [[Loop item]] or whether it's already in a format? Is there a better way?
3. Glean: Can we have some documentation for Loops, please? Thanks!

PARENT AGENT

Step 0 - Trigger

Step 1 - Loop

[[ Uploaded File ]]

Include a row number in the data for use in the loop sub-agent excluding header row if one exists.

Step 2 - Sub-agent

Step 3 - Respond

Output a horizontal rule, and then the following message replacing N with the number of rows excluding the header row:

### Status: Finished
#### N rows processed from the uploaded file, excluding the header row.

SUB-AGENT

Step 1 - Think

For Each [[Loop item]] identify the columns/fields for each row.

Extract these columns/fields from [[Loop item]] 

Create a JSON file and populate the columns/fields with their corresponding information.

Step 2 - Respond

Output a horizontal rule and then the following message replacing N with the row number from [[Loop item]] :

### In Loop: Row N

Step 3 - Respond

Output [[ 1. Think ]]  as JSON in a JSON code block.