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.
Would you please explain more. What are the steps of this solution?
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.