Icon

How to Export Google Agent Conversation Data from BigQuery

Learn step-by-step how to export Google agent conversation data from a BigQuery table using Google Cloud Console.

By Rory McKenna

In this guide, we'll learn how to export Google agent conversation data from a BigQuery table. This process involves navigating through the Google Cloud console to locate the relevant BigQuery table and exporting the data to Google Sheets. By following these steps, you can efficiently manage and analyze your chatbot interactions.

Let's get started

Hello, today I'll show you how to export Google agent conversation data from a BigQuery table. First, go to the Google Cloud console and type "BigQuery" in the search bar.

2
Click on "dev - broadsheet"
Step #2: Click on "dev - broadsheet"

We will type in the BigQuery table.

No, BigQuery is fine. You come here, click on dev/broadsheet, then click on chatbot v1 responses. Next, select dialog flow, then BigQuery export. This should have all the data in it.

3
Click here
Step #3: Click here
4
Click here
Step #4: Click here
5
Click here
Step #5: Click here

Next, go to Export and select Export Sheets.

6
Click on "QUntitled query"
Step #6: Click on "QUntitled query"

Let it load. Then you should have all the data connected. Get started, and we should have all the data there. If we check the dates, it likely begins from the 5th to the 10th as we started.

8
Click here
Step #8: Click here

That goes all the way to the end of the preview, covering 3, 5, and 6 rows.

9
Click here
Step #9: Click here
10
Click here
Step #10: Click here

We use the entire data set, so you should still be able to use this.

11
Click here
Step #11: Click here
12
Click here
Step #12: Click here
13
Click here
Step #13: Click here
14
Click here
Step #14: Click here

Here you go. I hope this works and that this tool is helpful.