Hi everyone!I need some help with my automation setup in ManyChat using Google Sheets. Here’s what I’m doing: I’ve connected Google Sheets to my flow. I’ve divided my data collection into two parts: Part 1: When a user shows interest, I insert their info (name, phone, tag, etc.) as a new row in Google Sheets. Part 2: Later in the conversation, if the same user confirms interest and books a meeting, I collect their meeting date and time. Now, instead of adding a new row again, I want to update the same row from Part 1 with the meeting date and time. So basically — I want to update the user’s existing row (where their data was first inserted) instead of creating a new one.Can someone please guide me on how to update the same row in Google Sheets from ManyChat?Any step-by-step help would be great! 🙏 P.S: I have tried the update a row action but it is not working, it is adding another row and inserting the new data there.. adding screenshots below.
