Skip to main content

  • 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..?

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!

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 ginsert 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 🙏

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 ginsert 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


Community Terms & ConditionsCookie settings