Googlesheats va Manychat maulot alishuvi faqat bir tomonga emasmi?
yani Manychat googlega faqat malumot jonata oladi holosmi yani Manychat googlesheatsda bor bo 'lgan tavar ma'lumotlarimdan meninga oladimi rasim, narx, qoldiq soni va shunga o'xshash ma'lumotlarni olipga kalit so'z orqali jonata oladimi?
Question
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.