Integromat
  • Back to website
Articles in this section
  • Example of a Default route configured for a router
  • Send data to Integromat as JSON via an action in a Bubble workflow using the API Connector plugin
  • How to iterate columns of a Google Sheet worksheet
  • How to fully reset your Google connections
  • Calling Google APIs via the "HTTP > Make a OAuth 2.0 request" module
  • Calling Microsoft Graph REST API via the "HTTP > Make a OAuth 2.0 request" module
  • Create a Data Thing or a Bulk of Data Things on Bubble
  • Use JSON Generator to create a JSON Data Structure and make an HTTP request using an API Key (SendGrid example)
  • Extract an item and/or its value from an array of collections
  • Automate Invoicing with Invoice Ninja
See more
  1. Integromat Support
  2. Tutorials
  3. Tutorials

How to iterate columns of a Google Sheet worksheet

Michal Máša Michal Máša Updated January 28, 2021 23:27

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)
Was this article helpful?
0 out of 8 found this helpful
Menu
  • Features
  • Apps & Services
  • Templates
  • Pricing
  • What's new
  • Use cases
Information
  • Terms,  Privacy
  • FAQ
  • Help & Tutorials
  • Community
  • Affiliate Program
  • Blog
Developers
  • Developer Platform
Company
  • About the company
  • Join our team
  • Contact
Follow us
© 2020 Integromat by Celonis. All rights reserved. Integromat® is a registered trademark.
  • English