# Google sheets scenarios

**URL:** <https://community.make.com/t/google-sheets-scenarios/83154>\
**Category:** Questions\
**Tags:** arrays, api, connections\
**Created:** [May 22, 2025, 6:19pm UTC](https://community.make.com/t/google-sheets-scenarios/83154 "2025-05-22T18:19:12Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ahmed\_Yassin](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Ahmed\_Yassin](https://community.make.com/u/Ahmed_Yassin)\
**Post date:** [May 22, 2025, 6:19pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/1 "2025-05-22T18:19:12Z")

</div>

I am using a webhook to retrieve data from botpress, then I want to add google sheets scenario, where the data should start writing in the sheet from Row 3. The problem is that I’ve tried many options of Google sheets available integrations and the result is that it always retrieves data starting from Row 1. Another issue is that the data retrieved is variable, some times 1 row and sometimes 50 rows. Wish to find a help for this struggle soon. Thanks in advance.

---

<div class="post-metadata">

**Author:** ![Ben\_Grisinger](https://avatars.discourse-cdn.com/v4/letter/b/9fc348/32.png) [@Ben\_Grisinger](https://community.make.com/u/Ben_Grisinger)\
**Post date:** [May 23, 2025, 1:31am UTC](https://community.make.com/t/google-sheets-scenarios/83154/2 "2025-05-23T01:31:12Z")

</div>

I used a Math module. and entered 2+ {{bundleOrderPosition}}. That started filling out items on row 3 in the Sheet.

---

<div class="post-metadata">

**Author:** ![Ahmed\_Yassin](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Ahmed\_Yassin](https://community.make.com/u/Ahmed_Yassin)\
**Post date:** [May 23, 2025, 7:40am UTC](https://community.make.com/t/google-sheets-scenarios/83154/3 "2025-05-23T07:40:52Z")

</div>

Would you please explain more. What are the steps of this solution?

---

<div class="post-metadata">

**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\
**Post date:** [May 23, 2025, 11:59am UTC](https://community.make.com/t/google-sheets-scenarios/83154/4 "2025-05-23T11:59:17Z")

</div>

Hey Ahmed,

how are you currently adding the data to the sheet? Also - is there something in rows 1 and 2?

---

<div class="post-metadata">

**Author:** ![Ahmed\_Yassin](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Ahmed\_Yassin](https://community.make.com/u/Ahmed_Yassin)\
**Post date:** [May 23, 2025, 7:13pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/5 "2025-05-23T19:13:28Z")

</div>

I add data to the sheet through webhook with botpress, the first row is for column tags to connect it with google sheets, and the second row is for the column headers I want the user to view. I hide row one.

---

<div class="post-metadata">

**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\
**Post date:** [May 26, 2025, 11:23am UTC](https://community.make.com/t/google-sheets-scenarios/83154/6 "2025-05-26T11:23:09Z")

</div>

Sorry I meant literary - which module are you using to add the data?

---

<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:** [May 26, 2025, 1:04pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/7 "2025-05-26T13:04:37Z")

</div>

Hi @Ahmed_Yassin ,  
Could you please share an image of the scenario? Also, if you’re comfortable, sharing the blueprint would help us assist you better.

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

---

<div class="post-metadata">

**Author:** ![Ahmed\_Yassin](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Ahmed\_Yassin](https://community.make.com/u/Ahmed_Yassin)\
**Post date:** [May 27, 2025, 4:08pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/8 "2025-05-27T16:08:19Z")

</div>

Now I have reached to a point where, the row is retrieved two times, one in the first row and the other is in the third row, while the other items weren’t retrieved. Please find the attached scenario  
[blueprint (4).json](https://community.make.com/uploads/short-url/8uYESdHWBH2mXg228s50S7Fi8XV.json) (49.8 KB)

---

<div class="post-metadata">

**Author:** ![Ahmed\_Yassin](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Ahmed\_Yassin](https://community.make.com/u/Ahmed_Yassin)\
**Post date:** [May 27, 2025, 4:09pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/9 "2025-05-27T16:09:42Z")

</div>

Webhook, Google sheets (create a spreadsheet from a template), set variable, Iterator, google sheets (update a row), set variable, send to mail

---

<div class="post-metadata">

**Author:** ![Greatness\_Solutions](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/greatness_solutions/32/93374_2.png) [@Greatness\_Solutions](https://community.make.com/u/Greatness_Solutions)\
**Post date:** [May 28, 2025, 4:39pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/10 "2025-05-28T16:39:25Z")

</div>

Please share an image of the scenario so I can see where the issue might be coming from.

---

<div class="post-metadata">

**Author:** ![Ahmed\_Yassin](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Ahmed\_Yassin](https://community.make.com/u/Ahmed_Yassin)\
**Post date:** [May 30, 2025, 9:03pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/11 "2025-05-30T21:03:36Z")

</div>

![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/e/0ee3e53f87b09d447585ee20625777b62bc1d5d8.png)

---

<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:** [August 28, 2025, 9:17pm UTC](https://community.make.com/t/google-sheets-scenarios/83154/12 "2025-08-28T21:17:28Z")

</div>


