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.
I used a Math module. and entered 2+ {{bundleOrderPosition}}. That started filling out items on row 3 in the Sheet.
1 Like
Would you please explain more. What are the steps of this solution?
1 Like
Hey Ahmed,
how are you currently adding the data to the sheet? Also - is there something in rows 1 and 2?
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.
1 Like
Sorry I meant literary - which module are you using to add the data?
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
1 Like
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 (49.8 KB)
Webhook, Google sheets (create a spreadsheet from a template), set variable, Iterator, google sheets (update a row), set variable, send to mail
Please share an image of the scenario so I can see where the issue might be coming from.
