Can anyone help me figure out how to stop this from happening? I am trying to get a single user’s information to be collected in a single row.
I’ve tried both Insert Row and Update Row, and all of my Fields are named appropriately (I believe). Can anyone show me a simple walkthrough? I’m new to using ManyChat, and I likely need to have my hand held through this.
Additionally, any idea why the “Worker Experience” column will never show any input data? Perhaps this is a symptom of the same issue affecting this creation of a new row for each user input; but again, I am not sure.
Thank you in advance!
Isaac
Best answer by Fabio Gaulke
Hey, Issac/ @TepatWork!
Could you send a screenshot of your Google Sheet Action? There's a huge chance that the problem lies there.
For example, this is how it must look to work as yuo expect:
You'll use the Update Row action
The Lookup Column acts as an ID. And this must be stored to the contact in some Custom Field or you use some system field to use as ID (in the image below, I have a column called IG_User that receives the Instagram username (if no exists) or updates the corresponding columns (if it exists).
I don't see something that works like an ID in your table.
Following this logic, it should work and update the data instead of always creating new lines.
Could you send a screenshot of your Google Sheet Action? There's a huge chance that the problem lies there.
For example, this is how it must look to work as yuo expect:
You'll use the Update Row action
The Lookup Column acts as an ID. And this must be stored to the contact in some Custom Field or you use some system field to use as ID (in the image below, I have a column called IG_User that receives the Instagram username (if no exists) or updates the corresponding columns (if it exists).
I don't see something that works like an ID in your table.
Following this logic, it should work and update the data instead of always creating new lines.
Thanks for jumping on to help me with this. I believe I implemented your changes correctly, and yet the problem persists. I seem to be missing something. As requested, here’s a screenshot of my Google Sheets Action. This is an updated version of the Google Sheets Action, based on your suggestion. I’ve also attached my flow, so you can see what I’ve done; and perhaps I’ve misused the function.
As well, you will note that my spreadsheet now has a “[Worker - ID]” column. This was in response to your mention for the necessity for an ID on the table, but it has only blank cells with no formatting.
Finally, the problem with “[Worker - Experience]” not being added to the spreadsheet persists, and I’m at a loss as to why.
Please forgive such a long response, I’m still trying to wrap my head around how this program works.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
