Without using Zapier or Integromat…
This same method can be used with other Facebook Messenger tools such as
Is quite common to save data from ManyChat in Google Sheets and also common to retrieve data from Sheets and pass it to ManyChat. Fortunately, ManyChat has now (since September 2018) a direct way to do so.
However, ManyChat has not yet implemented a way to edit a row on a Google Sheet natively. So, most folks have done that using Zapier or Integromat.
The thing is you have to pay to use those services.
However, there is a way to do edit rows using Apps Script (part of the G Suite) and it won’t cost you anything.
In this video, I show you how.
You can test the flow here
I hope this is useful.
Let me know in what scenarios you will use something like this.
Also, let me know other things that you would like to do with ManyChat and Google Sheets so I can create other videos.