I want to find the name of a column in Google Sheets based on a given input. For example, if I enter ‘Firstname,’ I want to locate the corresponding column and retrieve its details. How can I achieve this in Make.com?
Welcome to the Make community!
Try using the Google Sheets “Search Rows (Advanced)” module:
Returns results matching the given criteria. This module doesn’t return a row number.
For more information, see https://www.make.com/en/integrations/google-sheets, and https://www.make.com/en/help/app/google-sheets in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Hi
In Google Sheet, I want to retrieve a specific column value and map it. However, when a new column is added to the sheet, the target column shifts, requiring me to remap everything. Is there a way to prevent this and keep the mapping consistent?
Welcome to the Make community!
Yes, that is possible. You’ll need a minimum of four modules to search for the header containing the header “value” you want to update, and get the column reference (A for first column, B for second, etc.).
So, you can update a row by finding the column matching the header value.
Headers in an array
Filter by header value, and use i variable from repeater to target the column
This is just an example. Your final solution may or may not look like this depending on your requirements.
I have provided examples of how to do this elsewhere on the forum if you want to go down this route. I think it’s in one of the threads I replied to previously. You can use the forum search feature on my profile page to find related topics.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.