Automatically Add Finished LiveChat Chats to Google Sheets with Pabbly Connect

Learn how to automatically add finished LiveChat chats to Google Sheets using Pabbly Connect in this step-by-step tutorial. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin the integration process, access Pabbly Connect by signing in to your account. This platform is essential for connecting various applications seamlessly.

Once logged in, navigate to the dashboard where you can create a new workflow. Pabbly Connect facilitates the integration of LiveChat with Google Sheets, allowing for automation of your chat data storage.

2. Creating a New Workflow in Pabbly Connect

Begin by clicking on the ‘Create Workflow’ button in Pabbly Connect. This action opens a new window where you can set up your integration.

• Name your workflow, for example, ‘LiveChat to Google Sheets’.
• Choose LiveChat as your trigger application.
• Select the trigger event, which in this case would be ‘New Chat Finished’.

After setting up the trigger, click on ‘Save and Continue’. This process allows Pabbly Connect to listen for new finished chats from LiveChat.

3. Setting Up LiveChat in Pabbly Connect

Now that you have set up the trigger, it’s time to configure LiveChat. In Pabbly Connect, you will need to authenticate your LiveChat account.

Once authenticated, you will be prompted to test the trigger. This involves sending a test chat from LiveChat to ensure that Pabbly Connect receives the data correctly. Make sure to check the data received in the Pabbly interface.

4. Adding Google Sheets as an Action

The next step involves adding Google Sheets as the action application in Pabbly Connect. Click on the ‘Add Action’ button to proceed.

• Select Google Sheets as your action application.
• Choose the action event, which should be ‘Add Row’.
• Connect your Google account to allow Pabbly to access your sheets.

After connecting, select the specific Google Sheet where you want to store the finished chat data. This step is crucial as it ensures that all relevant chat information is stored in the correct location.

5. Mapping Data from LiveChat to Google Sheets

Finally, you need to map data from LiveChat to Google Sheets within Pabbly Connect. This is where you specify which LiveChat fields correspond to the columns in your Google Sheet.

For instance, you might map the chat ID, customer name, and message content to their respective columns in Google Sheets. Once you have mapped all necessary fields, click on ‘Save and Send Test Request’. This will send a test row to your Google Sheet to confirm that everything is set up correctly.

Conclusion

Integrating LiveChat with Google Sheets using Pabbly Connect automates your workflow effectively. This tutorial provided a step-by-step guide to ensure your finished chats are stored automatically, improving your data management process.