# 400: INVALID\_ARGUMENT - Unable to parse range: 'BSAI- Stockmarket'!A2:Z2

**URL:** <https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771>\
**Category:** Beginner Questions\
**Tags:** error\
**Created:** [February 4, 2026, 2:10pm UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771 "2026-02-04T14:10:30Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![CobraLinho](https://avatars.discourse-cdn.com/v4/letter/c/dc4da7/32.png) [@CobraLinho](https://community.make.com/u/CobraLinho)\
**Post date:** [February 4, 2026, 2:10pm UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771/1 "2026-02-04T14:10:30Z")

</div>

### 🎯 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

> **[Integration HTTP - Make.com Automation Scenario](https://eu1.make.com/public/shared-scenario/s19ajxGpqS8/integration-http)**
>
> Preview Integration HTTP created with Make.com. Connect your favorite apps and automate repetitive tasks.

### 📸 Screenshots: scenario setup, module configuration, errors

 ![2026-02-04 14_08_32-Integration HTTP _ Make – Opera.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/f/5fca8c823e4dd81fd2bdbf12f79be2f254122b1a.png)  
 ![2026-02-04 14_09_07-Integration HTTP _ Make – Opera.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/2/32ddab252330838bd8a2b7ba48fb82e09ed87c0e.png)

---

<div class="post-metadata">

**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\
**Post date:** [February 5, 2026, 7:33am UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771/3 "2026-02-05T07:33:53Z")

</div>

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.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/7/c701d24f6bbcf80df074d0da3ad4d5903ea5f4a0.png)

**Best regards,**  
**Msquare Automation**  
_Platinum Partner of Make_  
@Msquare_Automation

---

<div class="post-metadata">

**Author:** ![CobraLinho](https://avatars.discourse-cdn.com/v4/letter/c/dc4da7/32.png) [@CobraLinho](https://community.make.com/u/CobraLinho)\
**Post date:** [February 5, 2026, 11:46am UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771/4 "2026-02-05T11:46:11Z")

</div>

here is the correct link.

> **[Integration HTTP - Make.com Automation Scenario](https://eu1.make.com/public/shared-scenario/s19ajxGpqS8/integration-http)**
>
> Preview Integration HTTP created with Make.com. Connect your favorite apps and automate repetitive tasks.

---

<div class="post-metadata">

**Author:** ![damato](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/damato/32/78329_2.png) [@damato](https://community.make.com/u/damato)\
**Post date:** [February 5, 2026, 7:47pm UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771/5 "2026-02-05T19:47:39Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Msquare\_Automation](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/msquare_automation/32/6634_2.png) [@Msquare\_Automation](https://community.make.com/u/Msquare_Automation)\
**Post date:** [February 6, 2026, 7:15am UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771/6 "2026-02-06T07:15:34Z")

</div>

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.

**Best regards,**  
**Msquare Automation**  
_Platinum Partner of Make_  
@Msquare_Automation

---

<div class="post-metadata">

**Author:** ![CobraLinho](https://avatars.discourse-cdn.com/v4/letter/c/dc4da7/32.png) [@CobraLinho](https://community.make.com/u/CobraLinho)\
**Post date:** [February 6, 2026, 7:46pm UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771/7 "2026-02-06T19:46:58Z")

</div>

i will check but i think its a little bit more complicated xD. lets see

---

<div class="post-metadata">

**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:** [May 7, 2026, 6:48pm UTC](https://community.make.com/t/400-invalid-argument-unable-to-parse-range-bsai-stockmarket-a2-z2/102771/8 "2026-05-07T18:48:13Z")

</div>


