# Getting Google Sheets Column Name **URL:** https://community.make.com/t/getting-google-sheets-column-name/17017 **Category:** Questions **Tags:** google-sheets **Created:** [October 4, 2023, 4:24pm UTC](https://community.make.com/t/getting-google-sheets-column-name/17017 "2023-10-04T16:24:00Z") **Posts on this page:** 9 **Page:** 1
### Author: ![Prem\_Patel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/prem_patel/32/93657_2.png) [@Prem\_Patel](https://community.make.com/u/Prem_Patel) #### Post date: [October 4, 2023, 4:24pm UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/1 "2023-10-04T16:24:00Z")
Hello Makers, I hope all are doing great! I have a query regarding how to get a column name in text, as “Raw” is showing column index numbers but dispayed as text. I want to find the column name or number Anything can work but in this case how can i find the “key” column name or number with respect to any values to search from output collection of 1 row and n columns. ![Screenshot (62)](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/d/ed5a2b12d604caaf368b1de3bdd505fd3bbc0f20.png) As in image attached If i want to search for column name or number by searching for value 391.50. How can i get out as 26 or R2 for this value 391.50 as in output from search module of Google sheets. ---
### Author: ![Carlos\_Herrera](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/carlos_herrera/32/16076_2.png) [@Carlos\_Herrera](https://community.make.com/u/Carlos_Herrera) #### Post date: [October 4, 2023, 6:36pm UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/3 "2023-10-04T18:36:37Z")
Hi Prem\_Patel What do you need to do with the result? What is the next module you need use it? ---
### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew) #### Post date: [October 5, 2023, 1:17am UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/4 "2023-10-05T01:17:17Z")
Welcome to the Make community! Please provide the output bundles of the trigger module by running the scenario, then click the bubble on the top-right of the module, save the contents as a `bundle.json` file, and upload it here into this discussion thread: ![Screenshot_2023-08-29_100800](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/e/e19e554d49359a79fe59f20d110dd917a4cbd22f.png) This will allow others to better assist you. Thanks! ---
### Author: ![Prem\_Patel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/prem_patel/32/93657_2.png) [@Prem\_Patel](https://community.make.com/u/Prem_Patel) #### Post date: [October 5, 2023, 4:00am UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/5 "2023-10-05T04:00:35Z")
Hiii… Simplified the values. I want to know the column name by looking for values as in output i don’t find the names as only numbers are there. If i can get column numbers that is also fine. I will be using google sheets modules next to generate a weekly report. [ { “0”: “10/5/2023”, “1”: “Value”, “2”: “390.00”, “3”: “393.00”, “4”: “395.00”, “5”: “0.96”, “6”: “1.73”, “7”: “2.25”, “ **ROW\_NUMBER** ”: 2, “ **SPREADSHEET\_ID** ”: “1RKC2uPIWqcPgVP62M2fUdC1wALj3CjNuL30m8JMQU1k”, “ **SHEET** ”: “Sheet7”, “ **IMTLENGTH** ”: 1, “ **IMTINDEX** ”: 1 } ] [output.json](https://community.make.com/uploads/short-url/CFtGbjpnmDhCVLcu6bXRRtblXc.json) (403 Bytes) ---
### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew) #### Post date: [October 5, 2023, 5:11am UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/6 "2023-10-05T05:11:13Z")
You can use the Google Sheets “Get Range Values” module to get the first/header row names. ![Screenshot_2023-10-05_131017](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/6/e66ecca0308f2383b4d423acb940d1aaa83d57a3.png) Output: ![Screenshot_2023-10-05_131037](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/a/ea5793170b3da7fdf0a0a919b44780ba2e8204b3.png) Then, you can reference them however you like: ![Screenshot_2023-10-05_131039](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/e/ce1e725e00df6ca562df58d8ebd1980544683fb7.png) (`header column value : data value`) ---
### Author: ![Prem\_Patel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/prem_patel/32/93657_2.png) [@Prem\_Patel](https://community.make.com/u/Prem_Patel) #### Post date: [October 5, 2023, 6:09am UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/7 "2023-10-05T06:09:45Z")
But then how can i i search for column name with respect to numbers. Like 390.00? ---
### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew) #### Post date: [October 5, 2023, 7:19am UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/8 "2023-10-05T07:19:35Z")
# Steps ### 1. You can use an iterator to loop through all the values ![Screenshot_2023-10-05_151022](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/1/e153be13f221e32bfeaa76197e13b7829affd5bf.png) ![Screenshot_2023-10-05_151017](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/3/73e7855b290c23cbbeaa4c5d5c9e132bf6a92c6d.png) ### 2. Then use a filter to only allow the value you want to search for ![Screenshot_2023-10-05_151059](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/7/87f697b1c9cc5554ca245384442ab707b3562a2e.png) ### 3. Then get the column name from the bundle position ![Screenshot_2023-10-05_151043](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/6/d68c1f695640bc0eef155fc4c19cd473cbc73b8b.png) * * * # Example ### 1. Data ![Screenshot_2023-10-05_151046](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/3/f358f303556696f29c1f9ac025c2995639d54763.png) ### 2. Search for value “`2`” ![Screenshot_2023-10-05_151059](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/7/87f697b1c9cc5554ca245384442ab707b3562a2e.png) ### 3. Get column name (Number of Tickets) ![Screenshot_2023-10-05_151003 (2)](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/1/a1e303924420bf251c982e1f7a6b33f78c362cd3.png) ---
### Author: ![Prem\_Patel](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/prem_patel/32/93657_2.png) [@Prem\_Patel](https://community.make.com/u/Prem_Patel) #### Post date: [October 5, 2023, 9:09am UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/9 "2023-10-05T09:09:04Z")
Thanks for the Solution… ---
### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot) #### Post date: [October 19, 2023, 10:07am UTC](https://community.make.com/t/getting-google-sheets-column-name/17017/10 "2023-10-19T10:07:18Z")