Trying to iterate a CSV of file names to a Google Sheet

Support
1

Hey, MindStudio team!

I am trying to iterate a CSV of file names to a Google Sheet row. I upload the CSV file, convert it to a comma-delimited JSON array, then (try to) iterate using a Run Workflow block.

This does not seem to be working, and I’m not sure what I’m doing wrong. Can you help, please?

This is the Agent ID: 785bee1d-7518-4db6-931e-c3fb20d1d66a

I can’t seem to upload a CSV file. I have one that I can give you separately if that’s helpful.

I’m trying to add each file name to the bottom of A column in the specified spreadsheet.

Thank you for your help!

2

Hi @TechWriterLouis,

It looks like everything works fine until the Agent tries to pass each value to the Google Sheet. Since the block expects multiple comma-separated values and isn’t getting any, it fails.

Quick fix: add a comma after the variable in the Update Google Sheet block:

image
image396×234 10.5 KB

3

Hey, Alex!

Ah, that is definitely part of the problem!

Though when I set the Run Workflow block to iterate either in parallel or sequentially, it fails. When running in parallel, it almost seems as if the agent “stumbles over itself” where it places 62 of the 65 file names into the Google Sheet row.

When I run it sequentially, it doesn’t run at all. I think I will need to run this sequentially so that the file names populate into the Google Sheet in alphabetical order.

Any ideas? (I have updated the agent. You can view the latest publication.)

4

Hi @TechWriterLouis,

Thanks for the quick reply!

Is there a specific reason you’re passing individual values to the Google Sheet through a Run Workflow block? From what I can see, it might be easier to pass the formatted data directly to the Update Google Sheet block:

image
image858×792 66.6 KB

5

Hey, Alex!

Well, I wanted it into a Run Workflow block because I like making things more difficult for myself. I also do a handstand while each test workflow runs.

But your solution is much easier and more elegant! No wonder you’re MindStudio’s Customer Support dude!

Thank you for your help!

6

Hi @TechWriterLouis,

Glad the simpler setup works better for you! And hey, if the handstand routine boosts productivity, I say keep it :smile: