Help Center

Google Sheets Integration

Google sheets is a free online spreadsheet tool. It stores structured data and can be used to create charts and graphs from your data.

These sheets can be accessed and edited from any device, anywhere. You can use our integration with Google Sheets to capture your data from the chat interface to these Sheets.

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 More Apps, and you will see the list of Integrations.
  3. Click on Connect button.
  4. Click on Connect button
  5. Choose any one of your Google accounts. The sheet in which the responses will be saved will belong to this account.
  6. You will get this pop-up asking for permission. Click on Continue. The pop-up will redirect to the same page.
  7. Now first create a new sheet in the account in which you have logged in and name it. Add these column names.
  8. Now go to WeConnect.Chat product, click on Configure button
  9. Enable the Push Created Lead to CRM toggle and click on Configure button.
  10. Skip the 1st step and click on Next: Create Contact.
  11. Select Data Source first and select the sheet in which contacts need to be moved.
  12. Select the sheet
  13. Click Field Mapping and Start adding Fields by clicking on Add field.
  14. Now assign variables to all the added fields. Click Save & Close

Test the Integration

  1. Go to Conversation of the selected chat interfacemctest1
  2. Start lead-related components like Email, Number, Open Question, etc. And make sure you have enabled the Leads checkbox and the tag is selected and click the Save button.mctest2
  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.

Related Contents