Skip to main content
Question

How to create code/pgm/function for reuse in Manychat ?


Mr.TestKin
  • I want to fetch data from an Excel/Google Sheet in ManyChat to create a chatbot for Instagram..?

  • Whenever I ask a question to the InstaBot, it should provide a response using the data available from Google Sheets, just like a database..?

Fabio Gaulke
Forum|alt.badge.img+3
  • Manychat Community Moderator
  • April 8, 2025

Hi, ​@Mr.TestKin!

 

You implement something using the native Google Sheets integration. Here is the documentation: https://help.manychat.com/hc/en-us/articles/14281248811292-Google-Sheets-integration#h_01JDT2W8VR5XTZPQQWMD6SD4Z3

 

In short words, you'll need some standard ID to use as Lookup Value and use the "Get a row from Google Sheets by lookup value” functionality. 😉

 

Hope this helps!


Mr.TestKin

Hi, ​@Fabio Gaulke ,

Thanks so much for sharing this — I really appreciate the quick help and the documentation link!

I actually tried the native Google Sheets integration with the lookup method, but unfortunately, it doesn’t quite meet my current requirement. I'm dealing with [insert short context here if you want — like dynamic data, complex logic, multiple matches, etc.], so I might need a more custom solution.

If you have any other suggestions or workarounds in mind, I'd love to hear them!

Thanks again 🙏


Fabio Gaulke
Forum|alt.badge.img+3
  • Manychat Community Moderator
  • April 14, 2025
Mr.TestKin wrote:

Hi, ​@Fabio Gaulke ,

Thanks so much for sharing this — I really appreciate the quick help and the documentation link!

I actually tried the native Google Sheets integration with the lookup method, but unfortunately, it doesn’t quite meet my current requirement. I'm dealing with [insert short context here if you want — like dynamic data, complex logic, multiple matches, etc.], so I might need a more custom solution.

If you have any other suggestions or workarounds in mind, I'd love to hear them!

Thanks again 🙏

 

I see… In this case, the best way to go is sending Manychat's data to another automation tool (like n8n, Make, Zapier) and do all this conditional logic there.

 

You could build some complex login in Manychat, but it isn't the best tool to do something like this.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings