google sheats va Manychat malumot alishuvi

Good news, it's not one-way. ManyChat can both send data to Google Sheets and pull data from it.

The feature you want is "Get Row by Value" in ManyChat's Google Sheets integration. For your case:

1. The user sends a keyword (a product name or code).

2. Save that keyword into a ManyChat custom field.

3. Add a "Get Row by Value" action: set the lookup column to the column in your sheet that holds the product name/code, and set the lookup value to that custom field.

4. ManyChat finds the matching row and pulls the other columns (price, stock, image URL) into custom fields you choose.

5. Send a message using those fields: price and stock as text, and the image by sending an image message that uses the image URL field.

Two important things:

- The lookup value has to be unique per row. If two rows share the same keyword, ManyChat only returns the first one, so give each product a unique code or name in the lookup column.

- For the image, ManyChat reads the image URL from the cell (the link), not an actual picture file. So store a public image URL in that column and send it as an image message.

That covers a keyword pulling one product's price, stock and image. If you ever want a keyword to return a scrolling gallery of several products at once, that's where an external tool like Make.com or Botsheets comes in, searching the sheet and sending back a dynamic gallery. But for one product per keyword, native Get Row by Value is enough.

ManyChat’da Instagram DM uchun automation qurayapmiz. Flow ichida Data Collection / Waiting for Text from contact ishlatyapmiz.

Tuzilishi hozir shunday:

1. Instagram Send Message:
“Mahsulot nomi yoki rangini yozing 😊”

2. Shu message ichida:
Waiting for Text from contact

3. Mijoz javob yozgandan keyin:
Action on reply → Actions #2

4. Actions #2 ichida:
External Request Google Apps Script Web App’ga yuboriladi.

Muammo:
Actions #2 blokidan keyin davom ettirish uchun Next Step chiqmayapti yoki boshqa Send Message blokiga ulab bo‘lmayapti. Shu sabab External Request’dan keyin mijozga javob yuborish qiyin bo‘lyapti.

Bizga kerak bo‘lgan flow:

Trigger → Send Message with Data Collection → Action on reply → External Request → Send Message

Lekin “Action on reply”dan Actions blokiga o‘tgandan keyin Actions blokidan keyingi Send Message’ga ulashda muammo bor. Ayrim holatda Next Step ko‘rinmaydi yoki ishlamaydi.

Iltimos, tekshirib bering:

1. Data Collection ichidagi “Action on reply”dan keyin External Request ishlatish to‘g‘rimi?
2. External Request joylashgan Actions blokidan keyin Send Message’ga qanday ulash kerak?
3. Agar Actions blokida Next Step chiqmasa, bu ManyChat cheklovimi yoki sozlamada xatomi?
4. Mijoz javob bergandan keyin API chaqirib, API javobini keyingi Send Message’da yuborish uchun to‘g‘ri sxema qanday bo‘lishi kerak?

Bizga aniq kerak bo‘lgan natija:
Mijoz mahsulot nomini yozadi → ManyChat javobni custom fieldga saqlaydi → External Request API’ga yuboradi → API reply_text qaytaradi → ManyChat reply_textni mijozga yuboradi.

Rahmat.