Map a google sheets column values

[Shawn]

I am trying to map values in a google sheets column and am getting an empty array. What am I doing wrong?

[IOA_Harman]

Hey @Shawn,

So here what your doing incorrect is defining your key (the part after the first semicolon).

What you are essentially doing is trying to map your array where the key is = the first bill id from your array (3826).

Instead you want to use the “raw value” for your Bill ID (click download output in your array aggregator and find the value here).

Find the key you are interested in (in this example I want the key for column c in my sheet):

Then edit your mapping:

[Shawn]

Hey @IOA_Harman ,
That did the trick! Thank you