How to iterate columns of a Google Sheet worksheet

In some cases it would be beneficial to iterate a row's columns, i.e. to convert each cell in a row into an individual bundle. If you hover mouse cursor over items in the Google Sheets > Search Rows module's output, you will notice that the raw names of items are in fact zero based indexes:

mceclip0.png

Using the Repeater module to cycle from 0 to number of columns minus 1 followed by a module employing the get(bundle;3. i) formula seems like a straightforward solution:

mceclip4.png

The only obstacle is that the first parameter of the get() function should be the whole bundle, which is currently not available in the mapping panel. Nevertheless, the Array aggregator module can be used to push the bundle into a single item array (by exploiting its grouping feature) to which the get() function can already be applied:

mceclip3.png

Here is the complete scenario:

mceclip5.png

The formula in the last module contains two nested get() functions. The inner function gets the whole bundle (first item in the single item array), the outer one returns the i-th column from the row.

get(get(4. Array;1);3. i)

Popular use cases from our blog

slack-automation-illustration

Slack Automation: 20 Free Templates to Get You Inspired

google-sheets-automation-alt

Google Sheets Automation for Ecommerce: 23 Free Templates

tweet-automation-illustration

How to Get Someone's Tweets Before Anyone Else Does

onboarding-automation-with-integromat-alt

How to Automate Employee Onboarding in Minutes with Integromat

shopify-order-to-manufacturer-illustration-alt

How to Auto Send Shopify Orders to Dropshipping Suppliers [Guide]

strava-exercise-to-google-sheets-illustration

Like a Champ: How to Save Strava Activities to Google Sheets

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.