Connect WeConnect.Chat with Google Sheets

1. Go to your WeConnect.Chat dashboard and select your bot. Then click on the builder, and go to Settings->Integrations.
   
2. Click on Connect button.
3. Click on Connect button
4. Choose any one of your Google accounts. The sheet in which the responses will be saved will belong to this account.
5. You will get this pop-up asking for permission. Click on Continue. The pop-up will redirect to the same page.
6. Now first create a new sheet in the account in which you have logged in and name it. Add these column names.(First Name, Last Name, Email, Phone, Company, City, Country, Address, Pincode, Age, Gender, Date, Website Url)
7. Now go to WeConnect.Chat product, click on Configure button
8. Enable the Push Created Lead to CRM toggle and click on Configure button.
9. First you need to configure Data Source. Click on gear icon
   
10. To select your recently created sheet, click on Change button.
    
11. Now you can see list of sheets, select the one which you have created recently.
    
12. Select sheet1
    
13. Now configure Field Mapping by clicking on gear icon
    
14. Click on Add Field button to fields like First Name, Last Name, etc.
    
15. Select the value from dropdown for the selected field.
16. Leave the Look up section as it is.

Test the Integration

1. Go to Conversation of the selected chat interface
2. Start lead-related components like Email, Number, Open Question, etc. And make sure you have enabled the Contacts checkbox and the tag is selected and click the Save button.
3. Have a complete interaction with your chat interface.
4. Check the Google Sheet you just created. You should see that the data has been saved in the Sheet

Disconnect the Integration

1. Just click on the Disconnect button and your integration will get disconnected.