400: INVALID_ARGUMENT - Unable to parse range: 'BSAI- Stockmarket'!A2:Z2

CobraLinho · February 4, 2026, 2:10pm

What is your goal?

I would like to enter financial data into Excel via a workflow and have it update

What is the problem?

RuntimeError
400: INVALID_ARGUMENT - Unable to parse range: ‘BSAI- Stockmarket’!A2:Z2

Origin
Google Sheets

Create public scenario page

Screenshots: scenario setup, module configuration, errors

Msquare_Automation · February 5, 2026, 7:33am

Hi @CobraLinho ,

This error usually occurs when the range format is invalid or incorrectly specified in the Google Sheets module (for example, using an unsupported or misformatted range like 'SheetName'!A2:Z2) or when contains extra characters/spaces, or the range doesn’t align with the selected operation** in the module.

Also, could you please check the scenario you shared? When we review it, we can see an HTTP module, but there is no Google Sheets module present in the scenario.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

CobraLinho · February 5, 2026, 11:46am

here is the correct link.

damato · February 5, 2026, 7:47pm

Hi @CobraLinho

On the Search Method of Update a Row module change from “Enter manually” to “Select from all”.

Disable “Map” on Sheet Name and choose the sheet from the dropdown.

Msquare_Automation · February 6, 2026, 7:15am

Hi @CobraLinho ,

Could you please recheck whether the sheet range you’ve provided is correct?

Also, try setting the Search Method to “Select from all”, then select the Spreadsheet ID and choose the required Sheet Name from the list.

After that, test the scenario again.

This could be the reason for the error you’re currently facing.

Hope this helps! If you face any issues, feel free to reach out.