**To integrate Papo with Google Data Studio and create custom dashboards, [Papo](https://papo.global/) offers the Flows module, which allows you to trigger Webhooks whenever a relevant event occurs in the CRM (such as the creation of a deal or a contact). The data is sent in real time to a Google Sheets spreadsheet, which then serves as a data source for Looker Studio (formerly Data Studio). This way, you build charts, pivot tables, and management views that are always up to date, without heavy code or manual exports.**

## Integration overview

The workflow is simple: for every important event in Papo, a Flow captures the information and forwards it via Webhook to an external URL, which inserts the data into a Google Sheets spreadsheet. That spreadsheet is then connected to Looker Studio to generate the dashboards.

| Step | Where it happens | What it does |
| :--- | :--- | :--- |
| **1. Prepare the spreadsheet** | Google Sheets + intermediary | Create the spreadsheet and get a Webhook URL (using Zapier, Make, or Google Apps Script). |
| **2. Create the trigger** | Papo (Flows module) | Define the event that starts the sending, such as “Deal Created” or “Contact Created”. |
| **3. Configure the Webhook** | Papo (Flows) | Add a Webhook action with the URL, POST method, and JSON body containing the data. |
| **4. Feed Google Sheets** | Google Sheets | The URL automatically inserts a new row with the event information. |
| **5. Connect to Looker Studio** | Looker Studio | Use the spreadsheet as a data source and build interactive visual dashboards. |

## How to export data from Papo to Google Sheets

The basis of the process is to configure an automation in Papo that sends the desired data to the spreadsheet, and then connect that spreadsheet to Data Studio. Follow the steps:

### 1. Prepare Google Sheets to receive the data

The spreadsheet needs an endpoint that accepts HTTP POST requests and writes one row at a time. Two approaches are common:

- **Automation platform (Zapier, Make, n8n)** – Create a “capture Webhook” that generates a unique URL. Add an “Add Row” action in Google Sheets, mapping the fields from the received JSON to the spreadsheet columns.
- **Google Apps Script (lightweight code)** – In Google Sheets, go to **Extensions > Apps Script**, paste a `doPost(e)` function that processes the payload and inserts the data. Publish it as a “Web App” with public access permission and copy the generated URL.

Define in the spreadsheet the columns that will receive the data (e.g., name, value, stage, date, status, pipeline).

### 2. Create the Flow in Papo with the appropriate trigger

Go to the **Flows** module in the Papo panel and create a new automation.

- **Trigger:** choose the CRM event that should trigger the sending. The most common are **“Deal Created”** (when a new card enters the Kanban) and **“Contact Created”** (when a lead is added to the CRM). These events cover most sales and relationship dashboards.
- **Action:** add a **Webhook** step.

### 3. Configure the Webhook action

Fill in the action fields:

- **URL:** paste the address generated in step 1 (from Zapier/Make or Apps Script).
- **Method:** `POST`.
- **Body:** use JSON with the event variables you want to export. For example, for a deal:

```json
{
  "name": "{{deal.name}}",
  "value": "{{deal.value}}",
  "stage": "{{deal.stage}}",
  "status": "{{deal.status}}",
  "pipeline": "{{deal.pipeline}}",
  "created_at": "{{deal.created_at}}"
}
```

For contacts, use `{{contact.name}}`, `{{contact.email}}`, `{{contact.source}}`, and other variables available in the Flows module documentation. Save and activate the Flow.

From that moment on, each new event automatically writes a row to the spreadsheet, building a historical base.

## Connecting the data to Google Data Studio (Looker Studio)

With the spreadsheet populated, follow these steps:

1. Go to [lookerstudio.google.com](https://lookerstudio.google.com) and click **Create > Data Source**.
2. Choose the **Google Sheets** connector and select the spreadsheet that is receiving data from Papo.
3. Check that the columns were identified correctly (Looker Studio recognizes dates, numbers, and text) and click **Connect**.
4. In the blank report, insert bar charts, funnel charts, time series, or tables related to the exported data.

Because the spreadsheet is updated automatically, Looker Studio dashboards reflect new records at intervals of up to 15 minutes (depending on Data Studio's refresh configuration). This eliminates the need to export fixed reports and allows management views to always be up to date.

## Who this integration is useful for

- **Sales managers** who want to track the pipeline and conversion by stage in real time, without relying on static spreadsheets.
- **Operations analysts** who need to cross-reference Papo pipeline data with metrics from other sources (marketing, finance) in a single dashboard.
- **Marketing teams** who want to visualize lead sources and campaign performance captured by Papo's CRM, combining them with external traffic data.
- **Customer service managers** who can export contact creation events and, with sectorization data, build panels for daily inbound volume.

## Frequently asked questions

### Do the data arrive in Google Sheets in real time?
Yes. The Flow's Webhook is triggered as soon as the configured trigger is activated (e.g., new deal created). Google Sheets receives the row immediately, and Looker Studio updates the dashboard according to its refresh rate (it can be adjusted to up to 15 minutes in the free version).

### Can I create customer service dashboards in addition to sales?
It is possible to capture other events available in Flows, such as contact creation. For conversation metrics (volume, response time), Papo offers native reports that complement the analysis. More granular data depends on the triggers available in the Flows module — check the complete list in the panel.

### Do I need to use an intermediary such as Zapier or Make?
Not necessarily. Google Apps Script is a free alternative that requires basic JavaScript knowledge. Automation platforms make the process easier visually for those who do not want to code.

### Can I send data from multiple sources (deals and contacts) to the same spreadsheet?
Yes. Create one Flow for each event, pointing to the same URL/spreadsheet. The recommendation is to use distinct columns for each source and, if necessary, a “type” column that identifies whether the row is from a deal or a contact, making segmentation in Looker Studio easier.

### What should I do if the data volume is very large?
Google Sheets has limits on rows and requests. For high volumes, consider using BigQuery as the destination (via Apps Script or Zapier) and connecting Looker Studio to BigQuery, keeping the same Webhook logic.

### Is there a direct API from Papo reports to Data Studio?
Details about additional API integrations can be found in the official documentation or on Papo's API page. The approach with Flows and Webhooks covers most use cases for custom dashboards, as it exports the raw events that feed any visualization.

## Read also

- [How to analyze the sales funnel report to identify conversion bottlenecks](/hc/papo/articles/how-to-analyze-sales-funnel-report-conversion-bottlenecks)
- [How to customize a productivity report with CSAT and response time metrics](/hc/papo/articles/customize-productivity-report-csat-response-time)

---

**[Start for free now and create your Data Studio dashboards →](htts://chat.papo.global/app/auth/signup?papo_lp=home&utm_source=lp&utm_medium=landing&utm_campaign=home&utm_content=start-free&papo_lp_v=start-free)**

The first user is free and does not require a credit card.