Skip to main content
Solved

How do I set up collecting email addresses to Google sheets?

  • July 24, 2024
  • 5 replies
  • 175 views
TemiAjibewa

Dear all,

I’m trying to collect email addresses from my IG DM to a Google sheet. I have done the integration and all but can’t seem to find the “User input” that all the YouTube videos I have watched keep talking about. 

I’ve literally been scouring the internet for this information for the past two hours. The videos I find on YouTube are from 7 months ago and older and don’t have the same interface I have (I guess it’s now updated). 

I’d really appreciate any help here. 

Thanks. 

This is where I’m missing it.

 

Best answer by tejasagja

@TemiAjibewa @sierramendex 

Here’s the screenshot for you to show you:

The second last option “User input” you need to choose to collect email.

 

 

    5 replies

    sierramendex
    • sierramendex
    • Up-and-Comer
    • July 25, 2024

    Im having the same issue .. I have had hundreds of responses with emails but cannot find the emails anywhere! Please let me know if you find anything )):

    tejasagja
    • tejasagja
    • Message Musketeer
    • Answer
    • July 26, 2024

    @TemiAjibewa @sierramendex 

    Here’s the screenshot for you to show you:

    The second last option “User input” you need to choose to collect email.

     

     

    TemiAjibewa
    tejasagja
    • tejasagja
    • Message Musketeer
    • July 26, 2024

    And here’s how you can send email data to google sheet:
     

    Step 1: Connect Google sheet by going to Manychat settings > integration > Google sheet

    Step 2: After that go to your email flow and then add a action tab after the email collection message.

    Step 3: and in that action tab select Google sheet > update row and do the needful. 

    Step 4 : Don't forget to connect that action tab with the next message you're sending.

    But I would highly recommend to not send email data to google sheet and then add people manually to your email platform, instead automate it through manychat integrations or through make or zapier.

    I hope you got the answer. @TemiAjibewa @sierramendex  

    TemiAjibewa
    • TemiAjibewa
    • Author
    • Up-and-Comer
    • July 30, 2024

    Thank you very much @tejasagja 
    I see where I was getting it wrong now.

    I was using the “As Comment Reply”, not “within 24 hours window”.

    Thank you very much.

     

    tejasagja
    tejasagja
    • tejasagja
    • Message Musketeer
    • July 30, 2024

    Thank you very much @tejasagja 
    I see where I was getting it wrong now.

    I was using the “As Comment Reply”, not “within 24 hours window”.

    Thank you very much.

     

    You’re most welcome @TemiAjibewa --- Use comment reply option only on the first message of comment reply flow, other than that you can use the “within 24 hours window” option.

    Community Terms & ConditionsCookie settingsAccessibility statement