Skip to main content

We would like to add a feature that allows us to send users who comment on one of our posts unique discount codes via Instagram DM by uploading an Excel file.

Hey @John Moreno you can set that up with Manychat right now, using the native Google Sheets integration!

Each time a new user comes in, you grab a new code from the Sheet and send it to them.


Thank you very much Gustavo! Would you be so kind as to tell me how I can integrate Google Sheets?


Here's a how-to @John Moreno 

  1. Connect Manychat to Google Sheets - you need to go to Settings > Integrations, and you'll see the Google Sheets option
  2. Setup your Google Sheet like this (column B would have the actual discount codes)
  3. In Manychat, setup a number Bot Field with a counter, set its value to 0.
  4. Setup your automation so that each time you need to give out a code, you increase the counter. This field will keep count of the fields you're using and have given away. So when the first person comes in, they'll get the code with ID 1. The second person will get the code with ID 2. And so on.
  5. To get the codes, use the 'Get Row by Value' Google Sheets action. The value you'll look for (your lookup value) will be the ID with the counter field that you're using.
  6. You may need to add additional logic to make sure people only get the code once, and you may also want to add some tracking to know which user got which code.

This is the basic outline of how to do it.

Here's Manychat's documentation for this: https://help.manychat.com/hc/en-us/articles/14281248811292-Google-Sheets-integration

Hope this helps! Feel free to ping me if you need help setting this up ;)


Thank you very much Gustavo!


Reply