Hi, ​@KIA Motors!

You need to use the update feature of the Google Sheets integration.

And for that, you also need to create a custom field that receives a custom and unique code to be the identifier for that specific query.

For example, you can use the Contact ID + incremental number.

- The contact ID you get via system variable

- The incremental number you can obtain creating a Bot Number Field and adding 1 to it in an Action Step, so every new interaction creates a unique ID.

Hope this helps!

Hi ​@Fabio Gaulke 

Thanks You so Much, i am new in ManyChat, Can you please explain how can i create Incremental ID with Contact ID.

Regards, 

Sure!

You will need to create:

• 1 User Field (Text)
• 1 Bot Field (Number) = Set the default value to 1

(To create them, go to Settings/ Fields)

Important Info to know:

• Bot field is at the account level. If it gets changed, the new value applies to every contact.
• User field is at the contact level. Each contact can have different values in it.

In your flow, create an Action Step and add two actions:

• Contact data/ Set User Field

  • 

    Select your Text User Field (TEXT_FIELD in my example) and set the value to “Contact Id”-"Your Number Bot Field”

  • To select this variables, click on the "{.}” icon

    • Systems Fields/ Contact Id

    • Custom Bot Field/ Your Bot Field

  • This will create a unique ID for this automation run. In example: “123456-1”

• Automation/ Set Bot Field

  • 

    Select your Number Bot Field (NUM_BOT_FIELD in my example), set the operation to "Increase the number by” and set the value to 1.

  • This will add 1 to the bot field every time someone passes by this step.

Now, in your Google Sheets, create a new column for this ID and save your Custom User Field to it.
When the contact responds, update your spreadsheet using the ID as Lookup Value.

This should work.

Dear ​@Fabio Gaulke 

Thank You So Much for Your Support. 

Let me check and will back to you.