Skip to main content

Hi everyone!
I need some help with my automation setup in ManyChat using Google Sheets. Here’s what I’m doing:

  1. I’ve connected Google Sheets to my flow.

  2. 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.

  3. 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. 

 

 

Hi, ​@Arwajj!

 

You just need 2 things to make it work:

  1. Define any kind of ID for each contact. It can be the phone number, Manychat's contact ID or anything that's exclusive to one person/contact.
    • This must be a column in your spreadsheet
  2. Then you use Update row, instead of Insert row. 

    There you will select the lookup column to compare the values and be able to find the previous row with the user information and update it.

 

Hope it helps!

Community Terms & ConditionsCookie settingsAccessibility statement