Going past column Z in Google Sheets

Hi there,

I’m running a scenario that pulls information from a Google Sheet and does various things with it in Wordpress. However, I have several columns of information that go past the “last” column “Z” in Sheets that don’t appear as an option in the wordpress module (AA, AB, AC, etc).

Am I missing something here, or is there a hard limitation on which columns Make can draw from? Is there a manual way to call up the columns that don’t appear in the list?

Any help is greatly appreciated!

Are you using the “Search Rows” module?

There is this field here that you need to consider

Screenshot_2024-04-03_090455

Alternatively, you can use the “Get Range” module, which allows you to specify the range.

Screenshot_2024-04-03_090404

2 Likes

I’m actually using the Watch New Rows Google Sheets module and connecting it to a Wordpress Create A Post module.

In the Wordpress module, when I click a field that I’d like to map to column AA or AB (for example), it only lists as far as “Z” in the options.

You can submit this suggestion to the Idea exchange, under App improvement ideas.

Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.
Screenshot_2024-01-17_130153

In the meantime, you can use the “Get a Row” or “Get Range Values” module to get the entire row’s columns.

2 Likes

I fixed it!

Based on your question, I had the thought to change the “Row with headers” field in the Watch New Rows module to “A1:AC1” (instead of A1:Z1) and it pulled in the new rows to the Wordpress module.

Thanks again for the help!

3 Likes

Hey there @DomDom :wave:

Amazing to hear that you solved your issue! Thank you so much for keeping us updated on this matter. This way our community stays tidy and organized for everybody.

Keep up the good work!

1 Like