Hello! I need to get the data from a fixed row in my google sheet so I can copy the content of some cells in new rows but I cant map this data because I cant find the Get row module, only Get cell one. Any idee how I can map the entire row and not cell by cell.
At the end of the scenario I need al the data from the new row used in a Google doc template, so I need it maped again so its to much with Get Cell.
Welcome to the Make community!
To do this, you can try using the Google Sheets “Get Range Values” module —
Returns a sheet’s content defined by range values.
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.
I tried Your solution but the problem I have is that the values that I need are the result of a watch new rows module and I need it to process the last row not a fix value. I tried to map the range value from watch new rows module ,but the Get range Values module gives me an error (The operation failed with an error. 400: INVALID_ARGUMENT - Unable to parse range: ‘Form Responses 1’!3/28/2025 11:04:16). Can I make the range dependent of the row from watch new rows module? Thanks for the advice and time!
So I managed to make this module work(Get range values) but it only gives me a single bundle with all thee data from that row and I cant map the text that I want( its only one bundle). Any idea how to separate this information in bundles ( maybe a iterator?)?
Hi @Apex
You map each column values as follows
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation
2 Likes
Thank you very much! This will be a very good module to remember.
Hi @Apex
Glad to know that your issue is resolved now.
Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation