How to extract only some columns from Sheets (Video)

[Michael_ES]

I have a google sheet that I need to be able to pull data from and append to AP storage. Video below if that is easier.

Basically I have a google sheet that gets populated with dated data. Every week, I want to pull all entries from the sheet and have AI summarize them.

There are several columns in each sheet and each day can have multiple entries.

So the first loop loops through the date for the past 7 days.

The first task in the loop is to identify all the rows within the sheet that has the day being looped on.

Then I am looping over those rows and want to store just one column to storage but am drawing a blank on how I could accomplish that.

Video and Purpose: https://video.getwaas.io/conversations/dc0f172f-a8d8-5ac9-85dc-e9921ade0893

[kishanprmr]

Hello @Michael_ES ,

In the storage piece step, you have mapped the entire item (which is the output of the loop step). You can expand this item in the data panel and select a specific column to store in storage. Let me know if you face any errors while doing it.

[Michael_ES]

I thought I had tried that, but I was so tired by the time I finished yesterday… This worked, thanks.